34 lines
1.7 KiB
SQL
34 lines
1.7 KiB
SQL
/*==============================================================*/
|
|
/* Table: PUBFLOWPAR 流量控制参数 */
|
|
/*=============================================================*/
|
|
create table PUBFLOWPAR
|
|
(
|
|
REG_ID VARCHAR2(20) not null,
|
|
--域名
|
|
NOD_ID VARCHAR2(6) not null,
|
|
--节点名
|
|
TX_COD VARCHAR2(6) default ' ' not null,
|
|
--交易码
|
|
SYS_CNL VARCHAR2(10) default '999999' not null,
|
|
--系统渠道
|
|
BUS_CNL VARCHAR2(10) not null,
|
|
--业务渠道
|
|
MAX_FLOW NUMBER(5) default 0 not null,
|
|
--最大流量
|
|
STS VARCHAR2(1) default '0' not null,
|
|
--状态 0生效 1无效
|
|
TM_SMP VARCHAR2(14) default ' ' not null,
|
|
--时间戳
|
|
RMK VARCHAR2(100) default ' ' not null,
|
|
--备注
|
|
constraint PUBFLOWPAR_PK primary key (REG_ID,NOD_ID,SYS_CNL,BUS_CNL)
|
|
);
|
|
|
|
insert into PUBFLOWPAR (REG_ID, NOD_ID, TX_COD, SYS_CNL, BUS_CNL, MAX_FLOW, STS, TM_SMP, RMK)
|
|
values ('PAY_REG01', 'PAY', ' ', '999999', 'PAB', 20, '0', ' ', ' ');
|
|
insert into PUBFLOWPAR (REG_ID, NOD_ID, TX_COD, SYS_CNL, BUS_CNL, MAX_FLOW, STS, TM_SMP, RMK)
|
|
values ('PAY_REG01', 'PAY', ' ', '999999', 'CCB', 20, '0', ' ', ' ');
|
|
insert into PUBFLOWPAR (REG_ID, NOD_ID, TX_COD, SYS_CNL, BUS_CNL, MAX_FLOW, STS, TM_SMP, RMK)
|
|
values ('PAY_REG01', 'PAY', ' ', '999999', 'EBPPP', 20, '0', ' ', ' ');
|
|
insert into PUBFLOWPAR (REG_ID, NOD_ID, TX_COD, SYS_CNL, BUS_CNL, MAX_FLOW, STS, TM_SMP, RMK)
|
|
values ('PAY_REG01', 'PAY', ' ', '999999', 'CMBC', 20, '0', ' ', ' '); |