44 lines
1.3 KiB
SQL
44 lines
1.3 KiB
SQL
-- Create table
|
|
create table CAPSOFTROUTE
|
|
(
|
|
BANKCODE VARCHAR2(10) not null,
|
|
FRSPRNO VARCHAR2(10) not null,
|
|
OBJSVR VARCHAR2(30),
|
|
HTXNCD VARCHAR2(30),
|
|
HEADPARAM VARCHAR2(255) not null,
|
|
BODYPARAM VARCHAR2(255) not null,
|
|
ORTSTS VARCHAR2(5) not null,
|
|
HBOBJSVR VARCHAR2(30),
|
|
HBTXNCD VARCHAR2(30),
|
|
FTSSTS VARCHAR2(20),
|
|
SIGNURL VARCHAR2(100),
|
|
TM_SMP VARCHAR2(20) default SYSDATE not null
|
|
);
|
|
comment on column CAPSOFTROUTE.BANKCODE
|
|
is '银行代码';
|
|
comment on column CAPSOFTROUTE.FRSPRNO
|
|
is '前置机编号';
|
|
comment on column CAPSOFTROUTE.OBJSVR
|
|
is '目标服务SCA';
|
|
comment on column CAPSOFTROUTE.HTXNCD
|
|
is '目标交易码SCA';
|
|
comment on column CAPSOFTROUTE.HEADPARAM
|
|
is '头参数IP端口';
|
|
comment on column CAPSOFTROUTE.BODYPARAM
|
|
is '银行业务参数';
|
|
comment on column CAPSOFTROUTE.ORTSTS
|
|
is '状态标识S有效，F无效';
|
|
comment on column CAPSOFTROUTE.HBOBJSVR
|
|
is '心跳服务码';
|
|
comment on column CAPSOFTROUTE.HBTXNCD
|
|
is '心跳交易码';
|
|
comment on column CAPSOFTROUTE.FTSSTS
|
|
is '无效标识修改时间';
|
|
comment on column CAPSOFTROUTE.SIGNURL
|
|
is '目标签名服务器信息';
|
|
alter table CAPSOFTROUTE add constraint ROUTE_PRIMARY primary key(BANKCODE, FRSPRNO);
|
|
|
|
|
|
|
|
|