40 lines
1.6 KiB
SQL
40 lines
1.6 KiB
SQL
create table CAPCHKMERC(
|
|
CORG_NO VARCHAR2(30) not null,
|
|
--银行简称
|
|
MERC_ID VARCHAR2(30) not null,
|
|
--商户号
|
|
MERC_NAM VARCHAR2(30) ,
|
|
--商户名称
|
|
TXN_CNL VARCHAR2(30) not null,
|
|
--渠道标志
|
|
TM_SMP VARCHAR2(26) DEFAULT SYSDATE not null,
|
|
--时间戳
|
|
CONSTRAINT CAPCHKMERC_PK PRIMARY KEY (CORG_NO,MERC_ID)
|
|
);
|
|
|
|
insert into CAPCHKMERC (CORG_NO, MERC_ID, MERC_NAM, TXN_CNL)
|
|
values('PAB','800075500050015','壹钱包','1qianbao | haofang | trust');
|
|
|
|
insert into CAPCHKMERC (CORG_NO, MERC_ID, MERC_NAM, TXN_CNL)
|
|
values('PAB','800021000080018','陆金所','lufax');
|
|
|
|
insert into CAPCHKMERC (CORG_NO, MERC_ID, MERC_NAM, TXN_CNL)
|
|
values('BOC','800075500050015','壹钱包','1qianbao | haofang | trust');
|
|
|
|
insert into CAPCHKMERC (CORG_NO, MERC_ID, MERC_NAM, TXN_CNL)
|
|
values('ICBC','800075500050015','壹钱包','1qianbao');
|
|
|
|
insert into CAPCHKMERC (CORG_NO, MERC_ID, MERC_NAM, TXN_CNL)
|
|
values('ICBC','800021000080018','陆金所','lufax');
|
|
|
|
insert into CAPCHKMERC (CORG_NO, MERC_ID, MERC_NAM, TXN_CNL)
|
|
values('CCB','800075500050015','壹钱包','1qianbao | haofang | trust');
|
|
|
|
insert into CAPCHKMERC (CORG_NO, MERC_ID, MERC_NAM, TXN_CNL)
|
|
values('CCB','800021000080018','陆金所','lufax');
|
|
|
|
insert into CAPCHKMERC (CORG_NO, MERC_ID, MERC_NAM, TXN_CNL)
|
|
values('CMBC','800075500050015','壹钱包','1qianbao');
|
|
|
|
|
|
|