# 消费表增加订单来源区分订单 ~~~ alter table t_consume add flag varchar2(2) default 1 ; comment on column t_consume.flag is ' 默认1，2是支付结算中心传递过来的'; alter table t_consume add rakerate varchar2(200) default 0 ; comment on column t_consume.rakerate is ' 默认0,费率信息'; alter table t_consume add service_charge varchar2(200) default 0 ; comment on column t_consume.service_charge is ' 默认0,手续费信息'; ~~~ # 消费-退款表增加订单来源区分订单 ~~~ alter table t_consume_back add flag varchar2(2) default 1 ; comment on column t_consume_back.flag is ' 默认1，2是支付结算中心传递过来的'; alter table t_consume_back add rakerate varchar2(200) default 0 ; comment on column t_consume_back.rakerate is ' 默认0,费率信息'; alter table t_consume_back add service_charge varchar2(200) default 0 ; comment on column t_consume_back.service_charge is ' 默认0,手续费信息'; ~~~