创建表
create table sample.upps_pay_transdtl_epcc( --都有not null 但是ddl语句已经miss
payserno int,
paydate varchar(8),
paytime varchar(8),
amount varchar(100),
payername varchar(100),
payeracctno varchar(100),
payeraccttype varchar(100),
payeename varchar(100),
payeeacctno varchar(100),
payeeaccttype varchar(100),
pathprocstatus varchar(1),
pathprocmsg varchar(100),
coreprocstatus varchar(1),
coreprocmsg varchar(100),
trxstatus varchar(1),
trxmsg varchar(100),
payorganno varchar(100),
payorganname varchar(100)
)
comment on table sample.upps_pay_transdtl_epcc is '登记簿';
comment on column sample.upps_pay_transdtl_epcc.payserno is '流水号';
comment on column sample.upps_pay_transdtl_epcc.paydate is '支付日期';
comment on column sample.upps_pay_transdtl_epcc.paytime is '支付时间';
comment on column sample.upps_pay_transdtl_epcc.amount is '交易金额';
comment on column sample.upps_pay_transdtl_epcc.payername is '付款人名称';
co