1439 lines
32 KiB
SQL
1439 lines
32 KiB
SQL
create table PUBAPLBUS
|
||
(
|
||
BR_NO VARCHAR2(6),
|
||
APP_CLS VARCHAR2(3),
|
||
APP_SUB VARCHAR2(15) default ' ',
|
||
BUS_TYP VARCHAR2(6),
|
||
BUS_NM VARCHAR2(30)
|
||
)
|
||
/
|
||
|
||
create table PUBAPLMNG
|
||
(
|
||
BR_NO VARCHAR2(6),
|
||
APP_CLS VARCHAR2(3),
|
||
BUS_TYP VARCHAR2(6),
|
||
BUS_SUB VARCHAR2(15) default ' ',
|
||
CRP_CD VARCHAR2(10)
|
||
)
|
||
/
|
||
|
||
create table PUBBATINF
|
||
(
|
||
BR_NO VARCHAR2(6),
|
||
SND_CNT VARCHAR2(3) default '000',
|
||
LST_TM VARCHAR2(10) default '0000000000',
|
||
DSK_NO VARCHAR2(12),
|
||
DSK_NM VARCHAR2(50) default ' ',
|
||
BUS_TYP VARCHAR2(6),
|
||
CRP_CD VARCHAR2(10) default ' ',
|
||
ACC_DT VARCHAR2(8),
|
||
TXN_MOD VARCHAR2(1) default ' ',
|
||
FIL_NM VARCHAR2(50) default ' ',
|
||
CCY_CD VARCHAR2(3) default ' ',
|
||
SND_TLR VARCHAR2(7) default ' ',
|
||
NOD_NO VARCHAR2(6) default ' ',
|
||
RCV_TM VARCHAR2(14) default ' ',
|
||
CHK_TLR VARCHAR2(7) default ' ',
|
||
HST_TM VARCHAR2(14) default ' ',
|
||
RTN_TM VARCHAR2(14) default ' ',
|
||
DN_TLR VARCHAR2(7) default ' ',
|
||
ORN_CNT VARCHAR2(8) default '0',
|
||
ORN_AMT VARCHAR2(15) default '0',
|
||
SUC_CNT VARCHAR2(8) default '0',
|
||
SUC_AMT VARCHAR2(15) default '0',
|
||
FAL_CNT VARCHAR2(8) default '0',
|
||
FAL_AMT VARCHAR2(15) default '0',
|
||
FRSP_CD VARCHAR2(6) default '0',
|
||
TXN_SQN VARCHAR2(3) default '000',
|
||
STS VARCHAR2(1) default 'E',
|
||
CMT_FLG VARCHAR2(1) default '1',
|
||
SND_TMS VARCHAR2(3) default ' ',
|
||
FTXN_CD VARCHAR2(6) default ' ',
|
||
OBJ_SVR VARCHAR2(8) default ' ',
|
||
TRD_TBL VARCHAR2(16) default ' ',
|
||
CHK_FLG VARCHAR2(1) default '0',
|
||
SUM_FLG VARCHAR2(1) default 'N',
|
||
UPD_FLG VARCHAR2(1) default 'N',
|
||
RSV_FLD VARCHAR2(256) default ' '
|
||
)
|
||
/
|
||
|
||
create index NI1_PUBBATINF
|
||
on PUBBATINF (BR_NO, ACC_DT)
|
||
/
|
||
|
||
create index NI2_PUBBATINF
|
||
on PUBBATINF (BR_NO, DSK_NM)
|
||
/
|
||
|
||
create table PUBBATREC
|
||
(
|
||
BR_NO VARCHAR2(6),
|
||
LOG_NO VARCHAR2(14),
|
||
DSK_NO VARCHAR2(12),
|
||
BUS_TYP VARCHAR2(6),
|
||
CRP_CD VARCHAR2(10) default ' ',
|
||
ACC_DT VARCHAR2(8),
|
||
ACT_NO VARCHAR2(21) default ' ',
|
||
CRD_NO VARCHAR2(30) default ' ',
|
||
CCY_CD VARCHAR2(3) default ' ',
|
||
TXN_AMT VARCHAR2(15),
|
||
FEE VARCHAR2(15) default ' ',
|
||
TTXN_CD VARCHAR2(6),
|
||
TXN_CD VARCHAR2(6) default ' ',
|
||
HLOG_NO VARCHAR2(9) default ' ',
|
||
HRSP_CD VARCHAR2(6) default ' ',
|
||
HTXN_STS VARCHAR2(1) default 'U',
|
||
HPR_CHK VARCHAR2(1) default '0',
|
||
HLS_CHK VARCHAR2(1) default '0',
|
||
IS_TXN VARCHAR2(1) default 'Y',
|
||
TXN_CNL VARCHAR2(3),
|
||
TXN_OBJ VARCHAR2(8),
|
||
TLR_ID VARCHAR2(7),
|
||
MST_CHK VARCHAR2(1),
|
||
RS_FLD1 VARCHAR2(32) default ' ',
|
||
RS_FLD2 VARCHAR2(32) default ' ',
|
||
RS_FLD3 VARCHAR2(32) default ' ',
|
||
RS_FLD4 VARCHAR2(32) default ' ',
|
||
RS_FLD5 VARCHAR2(32) default ' '
|
||
)
|
||
/
|
||
|
||
create index NI1_PUBBATREC
|
||
on PUBBATREC (BR_NO, DSK_NO)
|
||
/
|
||
|
||
create table PUBBCHLST
|
||
(
|
||
BR_NO VARCHAR2(6),
|
||
BR_SEQ VARCHAR2(2),
|
||
SYS_ID VARCHAR2(5),
|
||
BR_NM VARCHAR2(20)
|
||
)
|
||
/
|
||
|
||
create table PUBBSPCTL
|
||
(
|
||
INST_ID VARCHAR2(20),
|
||
BAT_NO VARCHAR2(20),
|
||
FIL_NM VARCHAR2(60) default ' ',
|
||
M_BAT_NO VARCHAR2(20),
|
||
IS_PRIMARY VARCHAR2(1) default 'Y',
|
||
EXT_KEY VARCHAR2(70),
|
||
EXT_BAT_NO VARCHAR2(60) default ' ',
|
||
PHASE VARCHAR2(1) default '0',
|
||
STATUS VARCHAR2(1) default 'U',
|
||
PRE_STS VARCHAR2(1) default 'U',
|
||
PROC_STS VARCHAR2(1) default 'U',
|
||
AFTER_STS VARCHAR2(1) default 'U',
|
||
SRV_ID VARCHAR2(2) default ' ',
|
||
SND_CNT NUMBER default 0,
|
||
MAX_CNT NUMBER default 1,
|
||
TX_CD VARCHAR2(30) default ' ',
|
||
BUS_TYP VARCHAR2(5) default ' ',
|
||
AC_DT VARCHAR2(8),
|
||
DUE_DT_CTRL VARCHAR2(1) default '0',
|
||
DUE_DT VARCHAR2(8) default '19000101',
|
||
DUE_BGN_TM VARCHAR2(6) default '000000',
|
||
DUE_END_TM VARCHAR2(6) default '235959',
|
||
BAT_MOD VARCHAR2(1) default '1',
|
||
SUM_FLG VARCHAR2(1) default 'N',
|
||
START_TM VARCHAR2(19) default ' ',
|
||
CONFIRM_TM VARCHAR2(19) default ' ',
|
||
PRE_STR_TM VARCHAR2(19) default ' ',
|
||
PRE_FIN_TM VARCHAR2(19) default ' ',
|
||
PROC_STR_TM VARCHAR2(19) default ' ',
|
||
PROC_FIN_TM VARCHAR2(19) default ' ',
|
||
AFTER_STR_TM VARCHAR2(19) default ' ',
|
||
AFTER_FIN_TM VARCHAR2(19) default ' ',
|
||
FINISH_TM VARCHAR2(19) default ' ',
|
||
CCY_CD VARCHAR2(3) default ' ',
|
||
TOTAL_CNT NUMBER default 0,
|
||
TOTAL_AMT NUMBER default 0,
|
||
SUCC_CNT NUMBER default 0,
|
||
SUCC_AMT NUMBER default 0,
|
||
FAIL_CNT NUMBER default 0,
|
||
FAIL_AMT NUMBER default 0,
|
||
CALL_SRV VARCHAR2(8),
|
||
CALL_TX_CD VARCHAR2(20),
|
||
DO_PRE_PROC VARCHAR2(1) default 'N',
|
||
PRE_SRV VARCHAR2(8) default ' ',
|
||
PRE_TX_CD VARCHAR2(20) default ' ',
|
||
DO_AFTER_PROC VARCHAR2(1) default 'N',
|
||
AFTER_SRV VARCHAR2(8) default ' ',
|
||
AFTER_TX_CD VARCHAR2(20) default ' ',
|
||
DTL_TBL VARCHAR2(20),
|
||
UPD_FLG VARCHAR2(1) default 'N',
|
||
UPD_FLDS VARCHAR2(512) default ' ',
|
||
APPLY_JRN_FLG VARCHAR2(1) default 'N',
|
||
REMARK VARCHAR2(100) default ' ',
|
||
UPD_TS VARCHAR2(14) default ' ',
|
||
TM_SMP VARCHAR2(26) default SYSDATE,
|
||
APP_TYP VARCHAR2(10) default ' '
|
||
)
|
||
/
|
||
|
||
create unique index IDX_PUBBSPCTL_BATNO
|
||
on PUBBSPCTL (BAT_NO)
|
||
/
|
||
|
||
create index IDX_PUBBSPCTL_REPODATE
|
||
on PUBBSPCTL (AC_DT)
|
||
/
|
||
|
||
create index IDX_PUBBSPCTL_STATUS
|
||
on PUBBSPCTL (STATUS)
|
||
/
|
||
|
||
create unique index UI1_PUBBSPCTL
|
||
on PUBBSPCTL (EXT_KEY)
|
||
/
|
||
|
||
create table PUBCHNLSTS
|
||
(
|
||
CHAN_ID VARCHAR2(5),
|
||
CHAN_NM VARCHAR2(40),
|
||
SVR_NM VARCHAR2(8),
|
||
STS VARCHAR2(1)
|
||
)
|
||
/
|
||
|
||
create table PUBDAYEND
|
||
(
|
||
BR_NO VARCHAR2(6),
|
||
WRK_DT VARCHAR2(8),
|
||
STR_TM VARCHAR2(8) default ' ',
|
||
END_TM VARCHAR2(8) default ' ',
|
||
STS VARCHAR2(1)
|
||
)
|
||
/
|
||
|
||
create table PUBDUMTLR
|
||
(
|
||
BR_NO VARCHAR2(6),
|
||
TXN_CNL VARCHAR2(3),
|
||
CNL_SUB VARCHAR2(10),
|
||
DUM_TLR VARCHAR2(7)
|
||
)
|
||
/
|
||
|
||
create index NI1_PUBDUMTLR
|
||
on PUBDUMTLR (BR_NO, TXN_CNL)
|
||
/
|
||
|
||
create table PUBFTPCFG
|
||
(
|
||
BR_NO VARCHAR2(8),
|
||
FTP_ID VARCHAR2(30),
|
||
IP_ADR VARCHAR2(15),
|
||
USR_NAM VARCHAR2(20) default ' ',
|
||
USR_PWD VARCHAR2(20) default ' ',
|
||
OBJ_DIR VARCHAR2(60) default ' ',
|
||
OBJ_FIL VARCHAR2(60) default ' ',
|
||
LCL_DIR VARCHAR2(60) default ' ',
|
||
LCL_FIL VARCHAR2(60) default ' ',
|
||
FTP_MOD VARCHAR2(6) default 'bin',
|
||
PORT VARCHAR2(5) default ' ',
|
||
RMK VARCHAR2(60)
|
||
)
|
||
/
|
||
|
||
create table PUBIGTJNL
|
||
(
|
||
SYS_DT VARCHAR2(8) not null,
|
||
REG_ID VARCHAR2(20) not null,
|
||
NOD_ID VARCHAR2(20) not null,
|
||
TRAN_ID VARCHAR2(20) not null,
|
||
SYS_TM VARCHAR2(6),
|
||
LOG_NO VARCHAR2(20) not null,
|
||
SER_NM VARCHAR2(20) not null,
|
||
OBJ_SVR VARCHAR2(20) not null,
|
||
EXP_SER VARCHAR2(20) not null,
|
||
OPR_CLK NUMBER not null,
|
||
SUC_CLK NUMBER default 0,
|
||
ITV NUMBER not null,
|
||
TM_OUT NUMBER not null,
|
||
TIM_OUT NUMBER not null,
|
||
FAL_TMS NUMBER default 0,
|
||
MAX_TMS NUMBER not null,
|
||
FLAG VARCHAR2(1) default ' ',
|
||
STS VARCHAR2(1) default '0' not null,
|
||
DATA VARCHAR2(3072),
|
||
AC_DT VARCHAR2(8),
|
||
TM_SMP VARCHAR2(14),
|
||
constraint SYS_C0011400
|
||
primary key (SYS_DT, REG_ID, NOD_ID, TRAN_ID)
|
||
)
|
||
/
|
||
|
||
create index NI2_PUBIGTJNL
|
||
on PUBIGTJNL (LOG_NO)
|
||
/
|
||
|
||
create table PUBIGTJNLHIS
|
||
(
|
||
SYS_DT VARCHAR2(8) not null,
|
||
REG_ID VARCHAR2(20) not null,
|
||
NOD_ID VARCHAR2(20) not null,
|
||
TRAN_ID VARCHAR2(20) not null,
|
||
SYS_TM VARCHAR2(6),
|
||
LOG_NO VARCHAR2(20) not null,
|
||
SER_NM VARCHAR2(20) not null,
|
||
OBJ_SVR VARCHAR2(20) not null,
|
||
EXP_SER VARCHAR2(20) not null,
|
||
OPR_CLK NUMBER not null,
|
||
SUC_CLK NUMBER default 0,
|
||
ITV NUMBER not null,
|
||
TM_OUT NUMBER not null,
|
||
TIM_OUT NUMBER not null,
|
||
FAL_TMS NUMBER default 0,
|
||
MAX_TMS NUMBER not null,
|
||
FLAG VARCHAR2(1) default ' ',
|
||
STS VARCHAR2(1) default '0' not null,
|
||
DATA VARCHAR2(3072),
|
||
AC_DT VARCHAR2(8),
|
||
TM_SMP VARCHAR2(14)
|
||
)
|
||
/
|
||
|
||
create index NI1_PUBIGTJNL
|
||
on PUBIGTJNLHIS (LOG_NO)
|
||
/
|
||
|
||
create table PUBIGTJNLHISBACK
|
||
(
|
||
SYS_DT VARCHAR2(8),
|
||
REG_ID VARCHAR2(20),
|
||
NOD_ID VARCHAR2(20),
|
||
TRAN_ID VARCHAR2(20),
|
||
SYS_TM VARCHAR2(6) default ' ',
|
||
LOG_NO VARCHAR2(20),
|
||
SER_NM VARCHAR2(20) default ' ',
|
||
OBJ_SVR VARCHAR2(20),
|
||
EXP_SER VARCHAR2(20),
|
||
OPR_CLK NUMBER,
|
||
SUC_CLK NUMBER default 0,
|
||
ITV NUMBER default 0,
|
||
TM_OUT NUMBER default 0,
|
||
TIM_OUT NUMBER default 0,
|
||
FAL_TMS NUMBER default 0,
|
||
MAX_TMS NUMBER default 0,
|
||
FLAG VARCHAR2(1) default '0',
|
||
STS VARCHAR2(1) default '0',
|
||
DATA VARCHAR2(3072) default '',
|
||
AC_DT VARCHAR2(8),
|
||
TM_SMP VARCHAR2(26)
|
||
)
|
||
/
|
||
|
||
create unique index SYS_C0039132
|
||
on PUBIGTJNLHISBACK (SYS_DT, REG_ID, NOD_ID, TRAN_ID)
|
||
/
|
||
|
||
create table PUBJNLDEF
|
||
(
|
||
BR_NO VARCHAR2(6),
|
||
BUS_TYP VARCHAR2(6),
|
||
CRP_CD VARCHAR2(10),
|
||
ONL_TBL VARCHAR2(30) default ' ',
|
||
BAT_TBL VARCHAR2(30) default ' ',
|
||
ONL_CHK VARCHAR2(1) default '0',
|
||
BAT_CHK VARCHAR2(1) default '0'
|
||
)
|
||
/
|
||
|
||
create table PUBJOBSTS
|
||
(
|
||
BR_NO VARCHAR2(6),
|
||
WRK_DT VARCHAR2(8),
|
||
JOB_NM VARCHAR2(30),
|
||
STR_TM VARCHAR2(8) default ' ',
|
||
END_TM VARCHAR2(8) default ' ',
|
||
JOB_STS VARCHAR2(1)
|
||
)
|
||
/
|
||
|
||
create table PUBJOBTBL
|
||
(
|
||
BR_NO VARCHAR2(6),
|
||
JOB_NM VARCHAR2(30),
|
||
JOB_SEQ VARCHAR2(3),
|
||
PKG_NM VARCHAR2(10),
|
||
DPD_JOBS VARCHAR2(255)
|
||
)
|
||
/
|
||
|
||
create table PUBMSGINF
|
||
(
|
||
BR_NO VARCHAR2(6),
|
||
NAME VARCHAR2(30),
|
||
CNT_TYP VARCHAR2(2) default '1',
|
||
SUBJECT VARCHAR2(60) default ' ',
|
||
CLASS VARCHAR2(2) default ' '
|
||
)
|
||
/
|
||
|
||
create table PUBMSGJNL
|
||
(
|
||
BR_NO VARCHAR2(6),
|
||
MSG_NO VARCHAR2(10),
|
||
HEAD VARCHAR2(60),
|
||
BODY VARCHAR2(3072),
|
||
MESSAGE VARCHAR2(20),
|
||
FIL VARCHAR2(60) default ' ',
|
||
RCV_TM VARCHAR2(14),
|
||
EXP_TM VARCHAR2(14) default '99999999999999',
|
||
STS VARCHAR2(1) default '1',
|
||
PUBLISHER VARCHAR2(20) default ' '
|
||
)
|
||
/
|
||
|
||
create table PUBMULQRY
|
||
(
|
||
REC_KEY VARCHAR2(100),
|
||
TOTAL NUMBER(4),
|
||
NUM_PERPAGE NUMBER(4),
|
||
CURR_PAGE NUMBER(4),
|
||
TOTAL_PAGE NUMBER(4),
|
||
SYS_DATE VARCHAR2(10),
|
||
SYS_TIME VARCHAR2(10)
|
||
)
|
||
/
|
||
|
||
create table PUBPLTINF
|
||
(
|
||
SYS_ID VARCHAR2(6),
|
||
LOG_NO VARCHAR2(14),
|
||
BLOG_NO VARCHAR2(12),
|
||
ACC_DT VARCHAR2(8),
|
||
LST_ACC_DT VARCHAR2(8),
|
||
DAT_END VARCHAR2(2),
|
||
ELE_BK VARCHAR2(6),
|
||
TM_SMP VARCHAR2(14)
|
||
)
|
||
/
|
||
|
||
create table PUBPUBER
|
||
(
|
||
BR_NO VARCHAR2(6),
|
||
NAME VARCHAR2(20),
|
||
TYPE VARCHAR2(1),
|
||
RESPONSE VARCHAR2(1),
|
||
RSP_TYP VARCHAR2(2) default ' ',
|
||
ADDR VARCHAR2(60) default ' ',
|
||
PARA VARCHAR2(60) default ' '
|
||
)
|
||
/
|
||
|
||
create table PUBSCHAPP
|
||
(
|
||
REG_ID VARCHAR2(20) not null,
|
||
NOD_ID VARCHAR2(20) not null,
|
||
TASK_ID VARCHAR2(16) not null,
|
||
STS VARCHAR2(1) default '0' not null,
|
||
TM_SMP VARCHAR2(26),
|
||
constraint SYS_C0011441
|
||
primary key (REG_ID, NOD_ID, TASK_ID)
|
||
)
|
||
/
|
||
|
||
comment on table PUBSCHAPP is '公共定时任务应用信息表'
|
||
/
|
||
|
||
comment on column PUBSCHAPP.REG_ID is '域名'
|
||
/
|
||
|
||
comment on column PUBSCHAPP.NOD_ID is '结点名'
|
||
/
|
||
|
||
comment on column PUBSCHAPP.TASK_ID is '任务ID'
|
||
/
|
||
|
||
comment on column PUBSCHAPP.STS is '生效状态默认为0不生效'
|
||
/
|
||
|
||
comment on column PUBSCHAPP.TM_SMP is '时间戳'
|
||
/
|
||
|
||
create table PUBSCHCND
|
||
(
|
||
TASK_ID VARCHAR2(16) not null
|
||
constraint PUBSCHCND_PK
|
||
primary key,
|
||
SQN NUMBER,
|
||
MINUTE VARCHAR2(180),
|
||
HOUR VARCHAR2(36),
|
||
MON_DAY VARCHAR2(93),
|
||
WEEK_DAY VARCHAR2(21),
|
||
MON_WEEK VARCHAR2(18),
|
||
MONTH VARCHAR2(36)
|
||
)
|
||
/
|
||
|
||
comment on table PUBSCHCND is '公共定时任务条件定义表'
|
||
/
|
||
|
||
comment on column PUBSCHCND.TASK_ID is '任务ID'
|
||
/
|
||
|
||
comment on column PUBSCHCND.SQN is '任务序号'
|
||
/
|
||
|
||
comment on column PUBSCHCND.MINUTE is '分钟'
|
||
/
|
||
|
||
comment on column PUBSCHCND.HOUR is '小时'
|
||
/
|
||
|
||
comment on column PUBSCHCND.MON_DAY is '天'
|
||
/
|
||
|
||
comment on column PUBSCHCND.WEEK_DAY is '在本周第几天'
|
||
/
|
||
|
||
comment on column PUBSCHCND.MON_WEEK is '在本月第几周'
|
||
/
|
||
|
||
comment on column PUBSCHCND.MONTH is '月'
|
||
/
|
||
|
||
create table PUBSCHTSK
|
||
(
|
||
TASK_ID VARCHAR2(16) not null
|
||
constraint PUBSCHTSK_PK
|
||
primary key,
|
||
TASK_NM VARCHAR2(60),
|
||
MAX_SQN NUMBER,
|
||
IS_TXN VARCHAR2(1),
|
||
STATUS VARCHAR2(1),
|
||
COMMAND VARCHAR2(30),
|
||
PATH VARCHAR2(128),
|
||
OBJ_SVR VARCHAR2(8),
|
||
TXN_CD VARCHAR2(20),
|
||
DATA_TYP VARCHAR2(20),
|
||
TRACE VARCHAR2(1),
|
||
DATA VARCHAR2(1024)
|
||
)
|
||
/
|
||
|
||
comment on table PUBSCHTSK is '公共定时服务任务信息表'
|
||
/
|
||
|
||
comment on column PUBSCHTSK.TASK_ID is '任务ID'
|
||
/
|
||
|
||
comment on column PUBSCHTSK.TASK_NM is '任务名称'
|
||
/
|
||
|
||
comment on column PUBSCHTSK.MAX_SQN is '最大序号'
|
||
/
|
||
|
||
comment on column PUBSCHTSK.IS_TXN is '是否交易'
|
||
/
|
||
|
||
comment on column PUBSCHTSK.STATUS is '状态'
|
||
/
|
||
|
||
comment on column PUBSCHTSK.COMMAND is '命令'
|
||
/
|
||
|
||
comment on column PUBSCHTSK.PATH is '路径'
|
||
/
|
||
|
||
comment on column PUBSCHTSK.OBJ_SVR is '服务名'
|
||
/
|
||
|
||
comment on column PUBSCHTSK.TXN_CD is '交易码'
|
||
/
|
||
|
||
comment on column PUBSCHTSK.DATA_TYP is '数据类型'
|
||
/
|
||
|
||
comment on column PUBSCHTSK.TRACE is '日志'
|
||
/
|
||
|
||
comment on column PUBSCHTSK.DATA is '数据'
|
||
/
|
||
|
||
create table PUBSEQREC
|
||
(
|
||
BR_NO VARCHAR2(6),
|
||
SEQ_NM VARCHAR2(30),
|
||
SEQ_CND VARCHAR2(30),
|
||
SEL_VAL NUMBER default 1,
|
||
TM_SMP VARCHAR2(26) default ' '
|
||
)
|
||
/
|
||
|
||
create table PUBSNDJNL
|
||
(
|
||
BR_NO VARCHAR2(6),
|
||
MSG_NO VARCHAR2(10),
|
||
RECEIVER VARCHAR2(20),
|
||
STS VARCHAR2(1) default '0',
|
||
FAL_TMS VARCHAR2(1) default '0',
|
||
SND_TM VARCHAR2(14) default ' '
|
||
)
|
||
/
|
||
|
||
create index NI1_PUBSNDJNL
|
||
on PUBSNDJNL (STS)
|
||
/
|
||
|
||
create table PUBSUBER
|
||
(
|
||
BR_NO VARCHAR2(6),
|
||
NAME VARCHAR2(20),
|
||
TYPE VARCHAR2(1),
|
||
ADDR VARCHAR2(60),
|
||
RCV_TYP VARCHAR2(2),
|
||
PARA VARCHAR2(80) default ' '
|
||
)
|
||
/
|
||
|
||
create table PUBSUBINF
|
||
(
|
||
BR_NO VARCHAR2(6),
|
||
MESSAGE VARCHAR2(30),
|
||
SUBSCRIBER VARCHAR2(20),
|
||
RULE VARCHAR2(1),
|
||
KEY VARCHAR2(30) default ' '
|
||
)
|
||
/
|
||
|
||
create table PUBTAPIF
|
||
(
|
||
AP_CD VARCHAR2(2),
|
||
AP_NM VARCHAR2(30) default ' ',
|
||
AP_MMO VARCHAR2(3),
|
||
AP_STS VARCHAR2(1),
|
||
STR_EXIT VARCHAR2(1) default ' ',
|
||
CLO_EXIT VARCHAR2(1) default ' ',
|
||
AP_REST_EXIT VARCHAR2(1) default ' ',
|
||
AP_CLD_NO VARCHAR2(9) default ' ',
|
||
RUN_MODE VARCHAR2(1),
|
||
HOL_RUN_FLG VARCHAR2(1)
|
||
)
|
||
/
|
||
|
||
create unique index PK_PUBTAPIF
|
||
on PUBTAPIF (AP_CD)
|
||
/
|
||
|
||
create index UI1_PUBTAPIF
|
||
on PUBTAPIF (AP_MMO)
|
||
/
|
||
|
||
create table PUBTAPTR
|
||
(
|
||
PTR_KEY VARCHAR2(15),
|
||
SEQ VARCHAR2(15),
|
||
ZERO_DT VARCHAR2(8) default ' ',
|
||
CHK_MTH VARCHAR2(1) default ' ',
|
||
CHK_ORG VARCHAR2(1) default ' ',
|
||
CHK_JJT VARCHAR2(1) default ' ',
|
||
INIT_ZERO VARCHAR2(1) default ' ',
|
||
WARN_SEQ VARCHAR2(15) default ' ',
|
||
UPD_DT VARCHAR2(8),
|
||
UPD_TLR VARCHAR2(10)
|
||
)
|
||
/
|
||
|
||
create unique index PK_PUBTAPTR
|
||
on PUBTAPTR (PTR_KEY)
|
||
/
|
||
|
||
create table PUBTBANK
|
||
(
|
||
BNK VARCHAR2(3),
|
||
CHN_NM VARCHAR2(60),
|
||
ENG_NM VARCHAR2(70) default ' ',
|
||
EFF_DT VARCHAR2(8),
|
||
EXP_DT VARCHAR2(8),
|
||
AC_CHK VARCHAR2(1) default ' ',
|
||
CI_CHK VARCHAR2(1) default ' ',
|
||
FX_RATE VARCHAR2(1),
|
||
MAX_LVL VARCHAR2(1),
|
||
AUH_LVL VARCHAR2(1),
|
||
BR_LEN VARCHAR2(2),
|
||
CI_LEN VARCHAR2(2),
|
||
AC_LEN VARCHAR2(2),
|
||
ITM_LEN VARCHAR2(2),
|
||
HEAD_BR VARCHAR2(15),
|
||
CLR_MTH VARCHAR2(1),
|
||
CLR_AC VARCHAR2(1),
|
||
CCY_FLG VARCHAR2(1),
|
||
LOC_CCY1 VARCHAR2(3) default ' ',
|
||
LOC_CCY2 VARCHAR2(3) default ' ',
|
||
EVA_CCY VARCHAR2(3) default ' ',
|
||
TOT_CCY VARCHAR2(3) default ' ',
|
||
TAI_FEN VARCHAR2(1) default ' ',
|
||
LANG_CD VARCHAR2(2) default ' ',
|
||
TLR_PMAX VARCHAR2(2) default '0',
|
||
TLR_PSW_PERD VARCHAR2(2) default '0',
|
||
CALD_CD VARCHAR2(9) default ' ',
|
||
ONL_PVCH VARCHAR2(1) default ' ',
|
||
EOY_MMDD VARCHAR2(4) default ' ',
|
||
INT_TAX VARCHAR2(1) default ' ',
|
||
COUN_CD VARCHAR2(3) default ' ',
|
||
TIM_ZON VARCHAR2(3) default ' ',
|
||
CLS VARCHAR2(1),
|
||
UPT_DT VARCHAR2(8),
|
||
UPT_TLR VARCHAR2(10)
|
||
)
|
||
/
|
||
|
||
create unique index PK_PUBTBANK
|
||
on PUBTBANK (BNK)
|
||
/
|
||
|
||
create table PUBTBATCH
|
||
(
|
||
BATCH_DATE VARCHAR2(8),
|
||
MONTH_END CHAR default 'N',
|
||
QUARTER_END CHAR default 'N',
|
||
HALF_YEAR_END CHAR default 'N',
|
||
YEAR_END CHAR default 'N',
|
||
WEEK_END CHAR default 'N',
|
||
MONTH_BEGIN CHAR default 'N',
|
||
QUARTER_BEGIN CHAR default 'N',
|
||
HALF_YEAR_BEGIN CHAR default 'N',
|
||
YEAR_BEGIN CHAR default 'N',
|
||
WEEK_BEGIN CHAR default 'N',
|
||
MONTH_HALF CHAR default 'N',
|
||
WORK_DAY CHAR default 'N',
|
||
MONTH_END_NAT CHAR default 'N',
|
||
QUARTER_END_NAT CHAR default 'N',
|
||
HALF_YEAR_END_NAT CHAR default 'N',
|
||
YEAR_END_NAT CHAR default 'N',
|
||
MONTH_BEGIN_NAT CHAR default 'N',
|
||
QUARTER_BEGIN_NAT CHAR default 'N',
|
||
HALF_YEAR_BEGIN_NAT CHAR default 'N',
|
||
YEAR_BEGIN_NAT CHAR default 'N',
|
||
TM_SMP VARCHAR2(14) default ' '
|
||
)
|
||
/
|
||
|
||
create table PUBTBLCND
|
||
(
|
||
TBL_NM VARCHAR2(20),
|
||
FLD_VAL VARCHAR2(10),
|
||
CTBL_NM VARCHAR2(20)
|
||
)
|
||
/
|
||
|
||
create table PUBTBLFLD
|
||
(
|
||
TBL_NM VARCHAR2(20),
|
||
CND_FLD VARCHAR2(20)
|
||
)
|
||
/
|
||
|
||
create table PUBTBSTS
|
||
(
|
||
AC_DT VARCHAR2(8),
|
||
BAT_STS VARCHAR2(1) default 'U',
|
||
BAT_BEG_TM VARCHAR2(19) default ' ',
|
||
BAT_END_TM VARCHAR2(19) default ' ',
|
||
WIN_DT1 VARCHAR2(8) default ' ',
|
||
WIN_DT2 VARCHAR2(8) default ' ',
|
||
WIN_BEG_TM VARCHAR2(6) default ' ',
|
||
WIN_END_TM VARCHAR2(6) default ' ',
|
||
LAST_AC_DT VARCHAR2(8) default ' ',
|
||
LAST_AC_DT_FLG VARCHAR2(1) default ' ',
|
||
LAST_AC_DT2 VARCHAR2(8) default ' ',
|
||
LAST_AC_DT2_FLG VARCHAR2(1) default ' ',
|
||
CUR_AC_DT VARCHAR2(8) default ' ',
|
||
CUR_AC_DT_FLG VARCHAR2(1) default ' ',
|
||
NEXT_AC_DT VARCHAR2(8) default ' ',
|
||
NEXT_AC_DT_FLG VARCHAR2(1) default ' ',
|
||
TM_SMP VARCHAR2(26) default ' '
|
||
)
|
||
/
|
||
|
||
create table PUBTEMAIL
|
||
(
|
||
EMAIL_HOST VARCHAR2(50),
|
||
EMAIL_PORT NUMBER,
|
||
EMAIL_USER VARCHAR2(50),
|
||
EMAIL_PASSWD VARCHAR2(20),
|
||
EMAIL_FROM VARCHAR2(50),
|
||
EMAIL_NM VARCHAR2(100)
|
||
)
|
||
/
|
||
|
||
create table PUBTEND
|
||
(
|
||
TLR VARCHAR2(10),
|
||
BUSS_TYP VARCHAR2(2),
|
||
TX_COUNT VARCHAR2(5) default ' ',
|
||
UPD_DT VARCHAR2(8)
|
||
)
|
||
/
|
||
|
||
create unique index PK_PUBTEND
|
||
on PUBTEND (TLR, BUSS_TYP)
|
||
/
|
||
|
||
create table PUBTGATH
|
||
(
|
||
ASS_TYP VARCHAR2(1),
|
||
ASS_ID VARCHAR2(15),
|
||
ATH_TYP VARCHAR2(1),
|
||
AP_MMO VARCHAR2(3),
|
||
TX_CLS VARCHAR2(256),
|
||
ATH_MOV_FLG VARCHAR2(1),
|
||
EFF_DT VARCHAR2(8),
|
||
EXP_DT VARCHAR2(8),
|
||
UPD_DT VARCHAR2(8),
|
||
UPD_TLR VARCHAR2(10)
|
||
)
|
||
/
|
||
|
||
create unique index PK_PUBTGATH
|
||
on PUBTGATH (ASS_TYP, ASS_ID, ATH_TYP, AP_MMO)
|
||
/
|
||
|
||
create table PUBTGRP
|
||
(
|
||
ROLE_TYP VARCHAR2(4),
|
||
ROLE_CNM VARCHAR2(60),
|
||
ROLE_ENM VARCHAR2(60) default ' ',
|
||
ATH_MOV_FLG VARCHAR2(1) default ' ',
|
||
STS VARCHAR2(1) default ' ',
|
||
UPD_DT VARCHAR2(8),
|
||
UPD_TLR VARCHAR2(10)
|
||
)
|
||
/
|
||
|
||
create unique index PK_PUBTGRP
|
||
on PUBTGRP (ROLE_TYP)
|
||
/
|
||
|
||
create table PUBTGRPL
|
||
(
|
||
ASS_TYP VARCHAR2(1),
|
||
ASS_ID VARCHAR2(15),
|
||
ROLE_TYP VARCHAR2(4),
|
||
STS VARCHAR2(1),
|
||
EFF_DT VARCHAR2(8),
|
||
EXP_DT VARCHAR2(8),
|
||
UPD_DT VARCHAR2(8),
|
||
UPD_TLR VARCHAR2(10)
|
||
)
|
||
/
|
||
|
||
create unique index PK_PUBTGRPL
|
||
on PUBTGRPL (ASS_TYP, ASS_ID, ROLE_TYP)
|
||
/
|
||
|
||
create table PUBTHLP
|
||
(
|
||
FLD_ORDER NUMBER(2) default 99,
|
||
FLD_NM VARCHAR2(32),
|
||
FLD_VAL VARCHAR2(100),
|
||
FLD_EXP VARCHAR2(100),
|
||
FLD_TYP CHAR,
|
||
FLD_EXP_DESC VARCHAR2(256),
|
||
TM_SMP VARCHAR2(26),
|
||
AC_ORG VARCHAR2(6)
|
||
)
|
||
/
|
||
|
||
create table PUBTMHDL
|
||
(
|
||
ACC_DT VARCHAR2(8),
|
||
JRN_NO VARCHAR2(9),
|
||
SEQ_NO VARCHAR2(4),
|
||
OPT_TYP VARCHAR2(1),
|
||
CLS_NM VARCHAR2(30),
|
||
CLS_KEY1 VARCHAR2(30) default ' ',
|
||
CLS_KEY2 VARCHAR2(30) default ' ',
|
||
CLS_KEY3 VARCHAR2(30) default ' ',
|
||
FLD_LST VARCHAR2(1000),
|
||
OLD_VAL VARCHAR2(3000) default ' ',
|
||
NEW_VAL VARCHAR2(3000) default ' '
|
||
)
|
||
/
|
||
|
||
create table PUBTMHIS
|
||
(
|
||
ACC_DT VARCHAR2(8),
|
||
JRN_NO VARCHAR2(9),
|
||
NVCH_NO VARCHAR2(14) default ' ',
|
||
BR VARCHAR2(15),
|
||
TLR VARCHAR2(10),
|
||
CHK_TLR VARCHAR2(10) default ' ',
|
||
ATH_TLR VARCHAR2(10) default ' ',
|
||
AP_MMO VARCHAR2(3),
|
||
AP_CD VARCHAR2(2),
|
||
TX_CD VARCHAR2(4),
|
||
TX_DT VARCHAR2(8),
|
||
TX_TM VARCHAR2(6)
|
||
)
|
||
/
|
||
|
||
create table PUBTMSG
|
||
(
|
||
MSG_CD VARCHAR2(20),
|
||
MSG_TYP VARCHAR2(1) default 'E',
|
||
ATH_LVL1 VARCHAR2(1) default '0',
|
||
ATH_LVL2 VARCHAR2(1) default '0',
|
||
MSG_INF VARCHAR2(256) default ' ',
|
||
MSG_DESC VARCHAR2(256) default ' ',
|
||
BMSG_INF VARCHAR2(256) default ' ',
|
||
MON_FLG VARCHAR2(1) default '0',
|
||
WARN_LVL VARCHAR2(1) default ' ',
|
||
UPD_DT VARCHAR2(8) default ' ',
|
||
LAST_UPD_OPR VARCHAR2(10) default ' ',
|
||
TM_SMP VARCHAR2(26) default ' '
|
||
)
|
||
/
|
||
|
||
create unique index PK_PUBTMSG
|
||
on PUBTMSG (MSG_CD)
|
||
/
|
||
|
||
create table PUBTMSGINF
|
||
(
|
||
MSG_CD VARCHAR2(60),
|
||
BUS_CNL VARCHAR2(5),
|
||
MSG_INF VARCHAR2(256),
|
||
MSG_DESC VARCHAR2(256),
|
||
RSP_CD VARCHAR2(20),
|
||
RSP_INF VARCHAR2(256),
|
||
LAST_UPD_OPR VARCHAR2(10),
|
||
UPD_DT VARCHAR2(8),
|
||
TM_SMP VARCHAR2(26) default SYSDATE
|
||
)
|
||
/
|
||
|
||
create unique index PUBTMSGINF_PK
|
||
on PUBTMSGINF (MSG_CD, BUS_CNL)
|
||
/
|
||
|
||
create table PUBTORGL
|
||
(
|
||
BNK VARCHAR2(3),
|
||
REL_CLS VARCHAR2(2),
|
||
BR VARCHAR2(15),
|
||
BR_CNM VARCHAR2(60),
|
||
REL_BR VARCHAR2(15),
|
||
REL_BR_CNM VARCHAR2(60),
|
||
EFF_DT VARCHAR2(8),
|
||
EXP_DT VARCHAR2(8),
|
||
UPD_DT VARCHAR2(8),
|
||
UPD_TLR VARCHAR2(10)
|
||
)
|
||
/
|
||
|
||
create unique index PK_PUBTORGL
|
||
on PUBTORGL (BNK, REL_CLS, BR, REL_BR)
|
||
/
|
||
|
||
create table PUBTORGM
|
||
(
|
||
BNK VARCHAR2(3),
|
||
BR VARCHAR2(15),
|
||
SUPR_BR VARCHAR2(15),
|
||
BR_ATTR VARCHAR2(1),
|
||
BR_LVL VARCHAR2(1),
|
||
BR_TYP VARCHAR2(2),
|
||
EFF_DT VARCHAR2(8),
|
||
EXP_DT VARCHAR2(8),
|
||
BR_CNM VARCHAR2(60),
|
||
BR_CN_AD VARCHAR2(70) default ' ',
|
||
BR_ENM VARCHAR2(70) default ' ',
|
||
BR_EN_AD VARCHAR2(120) default ' ',
|
||
BR_ABBR VARCHAR2(2) default ' ',
|
||
COMM_MAN VARCHAR2(60) default ' ',
|
||
TEL VARCHAR2(18) default ' ',
|
||
POST_NO VARCHAR2(6) default ' ',
|
||
MAX_TLR_LVL VARCHAR2(1),
|
||
MAX_ATH_LVL VARCHAR2(1),
|
||
FX_BUSI_NO VARCHAR2(2) default ' ',
|
||
BOP_CD VARCHAR2(12) default ' ',
|
||
ACCT_FLG VARCHAR2(1),
|
||
NOTE_PRT VARCHAR2(1) default ' ',
|
||
OPN_DT VARCHAR2(8),
|
||
RUN_HDAY VARCHAR2(1),
|
||
RUN_MODE VARCHAR2(1),
|
||
EOY_MMDD VARCHAR2(4),
|
||
UPD_DT VARCHAR2(8),
|
||
UPD_TLR VARCHAR2(10)
|
||
)
|
||
/
|
||
|
||
create unique index PK_PUBTORGM
|
||
on PUBTORGM (BNK, BR)
|
||
/
|
||
|
||
create table PUBTORGS
|
||
(
|
||
BNK VARCHAR2(3),
|
||
BR VARCHAR2(15),
|
||
AC_DATE VARCHAR2(8),
|
||
CLO_FLG VARCHAR2(1),
|
||
OPN_TM VARCHAR2(6),
|
||
CLO_TM VARCHAR2(6) default '000000',
|
||
CLO_TIMES VARCHAR2(2) default '0',
|
||
BR_OPN_EXIT VARCHAR2(1) default ' ',
|
||
BR_BAL_EXIT VARCHAR2(1) default ' '
|
||
)
|
||
/
|
||
|
||
create unique index PK_PUBTORGS
|
||
on PUBTORGS (BNK, BR)
|
||
/
|
||
|
||
create table PUBTRSTS
|
||
(
|
||
SYS_VER_NO VARCHAR2(8) default ' ',
|
||
SYS_STUS VARCHAR2(1) default ' ',
|
||
WIN_MODE VARCHAR2(1) default '1',
|
||
WIN_STS VARCHAR2(1) default 'N',
|
||
WIN_SW_TM VARCHAR2(6) default '000000',
|
||
WIN_DT1 VARCHAR2(8) default ' ',
|
||
WIN_DT2 VARCHAR2(8) default ' ',
|
||
WIN_BEG_TM VARCHAR2(6) default ' ',
|
||
WIN_END_TM VARCHAR2(6) default ' ',
|
||
LAST_AC_DT VARCHAR2(8) default ' ',
|
||
LAST_AC_DT_FLG VARCHAR2(1) default ' ',
|
||
LAST_AC_DT2 VARCHAR2(8) default ' ',
|
||
LAST_AC_DT2_FLG VARCHAR2(1) default ' ',
|
||
CUR_AC_DT VARCHAR2(8) default ' ',
|
||
CUR_AC_DT_FLG VARCHAR2(1) default ' ',
|
||
NEXT_AC_DT VARCHAR2(8) default ' ',
|
||
NEXT_AC_DT_FLG VARCHAR2(1) default ' ',
|
||
AC_DT_SW_FLG VARCHAR2(1) default ' ',
|
||
LAST_UPD_DT VARCHAR2(8) default ' ',
|
||
LAST_UPD_TM VARCHAR2(6) default ' ',
|
||
LAST_UPD_OPR VARCHAR2(20) default ' ',
|
||
TM_SMP VARCHAR2(26) default ' '
|
||
)
|
||
/
|
||
|
||
create table PUBTRSTSHIS
|
||
(
|
||
SYS_VER_NO VARCHAR2(8) default ' ' not null,
|
||
SYS_STUS VARCHAR2(1) default ' ' not null,
|
||
WIN_MODE VARCHAR2(1) default '1' not null,
|
||
WIN_STS VARCHAR2(1) default 'N' not null,
|
||
WIN_SW_TM VARCHAR2(6) default '000000' not null,
|
||
WIN_DT1 VARCHAR2(8) default ' ' not null,
|
||
WIN_DT2 VARCHAR2(8) default ' ' not null,
|
||
WIN_BEG_TM VARCHAR2(6) default ' ' not null,
|
||
WIN_END_TM VARCHAR2(6) default ' ' not null,
|
||
LAST_AC_DT VARCHAR2(8) default ' ' not null,
|
||
LAST_AC_DT_FLG VARCHAR2(1) default ' ' not null,
|
||
LAST_AC_DT2 VARCHAR2(8) default ' ' not null,
|
||
LAST_AC_DT2_FLG VARCHAR2(1) default ' ' not null,
|
||
CUR_AC_DT VARCHAR2(8) default ' ' not null,
|
||
CUR_AC_DT_FLG VARCHAR2(1) default ' ' not null,
|
||
NEXT_AC_DT VARCHAR2(8) default ' ' not null,
|
||
NEXT_AC_DT_FLG VARCHAR2(1) default ' ' not null,
|
||
AC_DT_SW_FLG VARCHAR2(1) default ' ' not null,
|
||
LAST_UPD_DT VARCHAR2(8) default ' ' not null,
|
||
LAST_UPD_TM VARCHAR2(6) default ' ' not null,
|
||
LAST_UPD_OPR VARCHAR2(20) default ' ' not null,
|
||
TM_SMP VARCHAR2(26) default ' ' not null
|
||
)
|
||
/
|
||
|
||
create table PUBTSCH
|
||
(
|
||
TASK_NM VARCHAR2(256),
|
||
REG_ID VARCHAR2(20),
|
||
NOD_ID VARCHAR2(20),
|
||
ID VARCHAR2(100),
|
||
IS_TXN VARCHAR2(1) default 0 not null,
|
||
OBJ_SVR VARCHAR2(20),
|
||
TXN_COD VARCHAR2(20),
|
||
MSG_TYP VARCHAR2(10),
|
||
INTERVAL NUMBER(10) default -1 not null,
|
||
TXN_DAT_TYP VARCHAR2(50) default 'text/etf',
|
||
TXN_DAT VARCHAR2(1024),
|
||
FUNC_PATH VARCHAR2(200),
|
||
FUNC_NAM VARCHAR2(200),
|
||
SND_FLG VARCHAR2(1) default 1 not null,
|
||
TM_OUT NUMBER(10) default -1 not null,
|
||
MINUTE VARCHAR2(100) default '0' not null,
|
||
HOURE VARCHAR2(100) default '*' not null,
|
||
MONTH_DAY VARCHAR2(100) default '*' not null,
|
||
WEEK_DAY VARCHAR2(100) default '*' not null,
|
||
MONTH_WEEK VARCHAR2(100) default '*' not null,
|
||
MONTH VARCHAR2(100) default '*' not null,
|
||
TRACE VARCHAR2(1) default 0 not null,
|
||
MONITOR VARCHAR2(1) default 0 not null,
|
||
REPEAT_SND NUMBER(2) default 0 not null,
|
||
DATA VARCHAR2(1024),
|
||
TM_SMP VARCHAR2(26)
|
||
)
|
||
/
|
||
|
||
comment on table PUBTSCH is '公共定时任务表'
|
||
/
|
||
|
||
comment on column PUBTSCH.TASK_NM is '定时任务名称'
|
||
/
|
||
|
||
comment on column PUBTSCH.REG_ID is 'ICS集群名'
|
||
/
|
||
|
||
comment on column PUBTSCH.NOD_ID is 'ICS实例名'
|
||
/
|
||
|
||
comment on column PUBTSCH.ID is '任务ID,为空时取"ObjSvr,strTxncod"'
|
||
/
|
||
|
||
comment on column PUBTSCH.IS_TXN is '是否是交易0 - 交易 1 - 函数'
|
||
/
|
||
|
||
comment on column PUBTSCH.OBJ_SVR is '交易所属服务名'
|
||
/
|
||
|
||
comment on column PUBTSCH.TXN_COD is '交易码'
|
||
/
|
||
|
||
comment on column PUBTSCH.MSG_TYP is '消息类型,默认PLTIN0和S.CYCSVR服务消息类型对应'
|
||
/
|
||
|
||
comment on column PUBTSCH.INTERVAL is '两次发起的间隔时间,默认-1,单位秒'
|
||
/
|
||
|
||
comment on column PUBTSCH.TXN_DAT_TYP is '交易数据包类型：text/plain、text/xml、text/etfapplication/octet-stream'
|
||
/
|
||
|
||
comment on column PUBTSCH.TXN_DAT is '交易数据包，txnDataType部位最大长度1024，isTxn为0时有效'
|
||
/
|
||
|
||
comment on column PUBTSCH.FUNC_PATH is '可执行函数路径（全路径）'
|
||
/
|
||
|
||
comment on column PUBTSCH.FUNC_NAM is '可执行函数名称，不带”/”'
|
||
/
|
||
|
||
comment on column PUBTSCH.SND_FLG is '是否发起标志0-发起1-不发起'
|
||
/
|
||
|
||
comment on column PUBTSCH.TM_OUT is '超时时间,默认-1,单位秒'
|
||
/
|
||
|
||
comment on column PUBTSCH.MINUTE is '分钟
|
||
配置方法，可以直接配数字，也可以配置以下表达式格式：
|
||
1.“*”（星号）表示此项无条件满足发起时机。如果没有配置该属性，系统默认为”*”；
|
||
2.“-“（减号）表示时间范围，如1-3表示1到3之间
|
||
3.“,”（逗号）表示项与项之间的隔离符号。如要表示 第1分钟，第2分钟，则表示为1，2；如要表示第1到4分钟，第6分钟则表示为1-4，6。有效的项有：合法数字（在有效范围内）、用”-“表示的范围；
|
||
4.“/”（反斜杠）表示每的意思，如每两分钟表示为/2;每分钟表示/0;
|
||
5.在以上的几种表示中，”*”和”/”都不能与”-“、”,”混合表示。即一个表达式要么是”*”，要么是”/”，要么是”-“或”,”及其混合。
|
||
'
|
||
/
|
||
|
||
comment on column PUBTSCH.HOURE is '小时，范围：1-24配置方法同minute（分钟）'
|
||
/
|
||
|
||
comment on column PUBTSCH.MONTH_DAY is '月天（在一个月中的第几天），范围：1-31配置方法同minute（分钟）'
|
||
/
|
||
|
||
comment on column PUBTSCH.WEEK_DAY is '星期，范围：0-6配置方法同minute（分钟）'
|
||
/
|
||
|
||
comment on column PUBTSCH.MONTH_WEEK is '月周（在一个月中的第几周），范围：1-6配置方法同minute（分钟）'
|
||
/
|
||
|
||
comment on column PUBTSCH.MONTH is '月份，范围：1-12配置方法同minute（分钟）'
|
||
/
|
||
|
||
comment on column PUBTSCH.TRACE is '是否记调试日志标志0-不记1-记调试日志'
|
||
/
|
||
|
||
comment on column PUBTSCH.MONITOR is '是否发送信息到监控服务器 0-不发送 1-发送'
|
||
/
|
||
|
||
comment on column PUBTSCH.REPEAT_SND is '一分钟之内是否可以发送多次的标志,默认0'
|
||
/
|
||
|
||
comment on column PUBTSCH.DATA is '该节点里面的节点用户可以根据实际需要来命名。当交易数据包为text/xml时存在'
|
||
/
|
||
|
||
comment on column PUBTSCH.TM_SMP is '时间戳'
|
||
/
|
||
|
||
create unique index PUBTSCH_IDX
|
||
on PUBTSCH (REG_ID, NOD_ID, OBJ_SVR, TXN_COD, FUNC_PATH, FUNC_NAM)
|
||
/
|
||
|
||
create table PUBTTATH
|
||
(
|
||
ASS_TYP VARCHAR2(1),
|
||
ASS_ID VARCHAR2(15),
|
||
ATH_TYP VARCHAR2(1),
|
||
AP_MMO VARCHAR2(3),
|
||
SERVICE_ID VARCHAR2(10),
|
||
ATH_MOV_FLG VARCHAR2(1) default ' ',
|
||
ATH_MOV_STS VARCHAR2(1) default ' ',
|
||
EFF_DT VARCHAR2(8),
|
||
EXP_DT VARCHAR2(8),
|
||
UPD_DT VARCHAR2(8),
|
||
UPD_TLR VARCHAR2(10)
|
||
)
|
||
/
|
||
|
||
create unique index PK_PUBTTATH
|
||
on PUBTTATH (ASS_TYP, ASS_ID, ATH_TYP, AP_MMO, SERVICE_ID)
|
||
/
|
||
|
||
create table PUBTTIMCTL
|
||
(
|
||
TRAN_ID VARCHAR2(20),
|
||
REG_ID VARCHAR2(20) not null,
|
||
NOD_ID VARCHAR2(20) not null,
|
||
OBJ_SVR VARCHAR2(20) not null,
|
||
SER_NM VARCHAR2(20) not null,
|
||
STS VARCHAR2(1),
|
||
RMK VARCHAR2(512),
|
||
TM_SMP VARCHAR2(26),
|
||
constraint PK_PUBTTIMCTL
|
||
primary key (REG_ID, NOD_ID, OBJ_SVR, SER_NM)
|
||
)
|
||
/
|
||
|
||
comment on table PUBTTIMCTL is '公共定时服务控制表'
|
||
/
|
||
|
||
comment on column PUBTTIMCTL.TRAN_ID is '事件编码'
|
||
/
|
||
|
||
comment on column PUBTTIMCTL.REG_ID is '域名'
|
||
/
|
||
|
||
comment on column PUBTTIMCTL.NOD_ID is '节点名'
|
||
/
|
||
|
||
comment on column PUBTTIMCTL.OBJ_SVR is '服务名'
|
||
/
|
||
|
||
comment on column PUBTTIMCTL.SER_NM is '交易码'
|
||
/
|
||
|
||
comment on column PUBTTIMCTL.STS is '状态(1启用0关闭)'
|
||
/
|
||
|
||
comment on column PUBTTIMCTL.RMK is '备注'
|
||
/
|
||
|
||
comment on column PUBTTIMCTL.TM_SMP is '时间戳'
|
||
/
|
||
|
||
create index IDX_PUBTTMERCTL_TRNID
|
||
on PUBTTIMCTL (OBJ_SVR, SER_NM)
|
||
/
|
||
|
||
create table PUBTTLT
|
||
(
|
||
TLR_BR VARCHAR2(15),
|
||
TLR_TKS VARCHAR2(3) default ' ',
|
||
TLR VARCHAR2(10),
|
||
STAF_NO VARCHAR2(10),
|
||
TLR_CN_NM VARCHAR2(60),
|
||
TLR_EN_NM VARCHAR2(60) default ' ',
|
||
EFF_DT VARCHAR2(8),
|
||
EXP_DT VARCHAR2(8),
|
||
UPD_DT VARCHAR2(8),
|
||
UPD_TLR VARCHAR2(10),
|
||
TLR_TYP VARCHAR2(1),
|
||
TLR_LVL VARCHAR2(1),
|
||
TX_LVL VARCHAR2(1),
|
||
ATH_LVL VARCHAR2(1) default ' ',
|
||
ATH_RGN VARCHAR2(1) default ' ',
|
||
TMP_TLR VARCHAR2(10) default ' ',
|
||
TMP_TX_LVL VARCHAR2(1) default ' ',
|
||
TMP_ATH_LVL VARCHAR2(1) default ' ',
|
||
TMP_EXP_DT VARCHAR2(8) default ' ',
|
||
TX_MODE VARCHAR2(1),
|
||
SIGN_STS VARCHAR2(1) default ' ',
|
||
TLR_STS VARCHAR2(1),
|
||
SIGN_DT VARCHAR2(8) default ' ',
|
||
CRO_BR_SIGN VARCHAR2(1),
|
||
SIGN_TIMES VARCHAR2(2) default '0',
|
||
PSW_RETRY VARCHAR2(2) default '0',
|
||
TRM_TYP VARCHAR2(1) default ' ',
|
||
SIGN_TRM VARCHAR2(15) default ' ',
|
||
PRT_IP VARCHAR2(15) default ' ',
|
||
TLR_STSW VARCHAR2(30) default ' ',
|
||
LAST_JRN VARCHAR2(9) default ' ',
|
||
ACC_VCH_NO VARCHAR2(14) default ' ',
|
||
NACC_VCH_NO VARCHAR2(14) default ' ',
|
||
WFF_TX_CNT VARCHAR2(5) default ' ',
|
||
FIN_TX_CNT VARCHAR2(5) default ' ',
|
||
CAN_TX_CNT VARCHAR2(5) default ' ',
|
||
TLR_CRD_NO VARCHAR2(6) default ' ',
|
||
TLR_CRD_PSW VARCHAR2(20) default ' ',
|
||
CRD_PSW_DT VARCHAR2(8) default ' ',
|
||
KB_PSW VARCHAR2(20),
|
||
KB_PSW_DT VARCHAR2(8) default ' ',
|
||
LAST_KB_PSW VARCHAR2(20)
|
||
)
|
||
/
|
||
|
||
create unique index PK_PUBTTLT
|
||
on PUBTTLT (TLR)
|
||
/
|
||
|
||
create index UI1_PUBTTLT
|
||
on PUBTTLT (TLR_BR, SIGN_STS, TLR)
|
||
/
|
||
|
||
create table PUBTTMS
|
||
(
|
||
MSG_CD VARCHAR2(8),
|
||
BUS_CNL VARCHAR2(5),
|
||
BUS_TYP VARCHAR2(4) default '*',
|
||
BUS_MSG_CD VARCHAR2(8) default ' ',
|
||
MSG_INF VARCHAR2(256) default ' ',
|
||
MSG_DESC VARCHAR2(256) default ' ',
|
||
UPD_DT VARCHAR2(8) default ' ',
|
||
LAST_UPD_OPR VARCHAR2(10) default ' ',
|
||
TM_SMP VARCHAR2(26) default ' '
|
||
)
|
||
/
|
||
|
||
create unique index PK_PUBTTMS
|
||
on PUBTTMS (MSG_CD, BUS_CNL, BUS_TYP)
|
||
/
|
||
|
||
create table PUBTTOT
|
||
(
|
||
TLR VARCHAR2(10),
|
||
CCY VARCHAR2(3),
|
||
ACCU_TYP VARCHAR2(2),
|
||
TX_COUNT VARCHAR2(5) default ' ',
|
||
AMT NUMBER(15,2) default '0',
|
||
LAST_DATE VARCHAR2(8)
|
||
)
|
||
/
|
||
|
||
create unique index PK_PUBTTOT
|
||
on PUBTTOT (TLR, CCY, ACCU_TYP)
|
||
/
|
||
|
||
create table PUBTTRHS
|
||
(
|
||
AC_DATE VARCHAR2(8),
|
||
TLR VARCHAR2(10),
|
||
JRN_NO VARCHAR2(20),
|
||
AP_CODE VARCHAR2(3),
|
||
TR_CODE VARCHAR2(10),
|
||
TR_NM VARCHAR2(30) default ' ',
|
||
PROD_CD VARCHAR2(8) default ' ',
|
||
CHNL_NO VARCHAR2(2) default ' ',
|
||
TR_DATE VARCHAR2(8),
|
||
TR_TIME VARCHAR2(6),
|
||
ACT_AC_DATE VARCHAR2(8) default '00000000',
|
||
TM_NO VARCHAR2(15) default ' ',
|
||
SUP1_ID VARCHAR2(10) default ' ',
|
||
SUP2_ID VARCHAR2(10) default ' ',
|
||
CONF_ID VARCHAR2(10) default ' ',
|
||
OATH_LVL VARCHAR2(2) default '00',
|
||
NATH_LVL VARCHAR2(2) default '00',
|
||
BR VARCHAR2(15) default '0',
|
||
WFF_FLG VARCHAR2(1),
|
||
MSG_CD VARCHAR2(7) default ' ',
|
||
ATH_DAT_LEN VARCHAR2(4) default ' ',
|
||
ATH_DAT VARCHAR2(270) default ' ',
|
||
INP_DAT_LEN VARCHAR2(4) default '0',
|
||
TM_SMP VARCHAR2(14),
|
||
INP_DAT CLOB,
|
||
KEY_INFO VARCHAR2(200)
|
||
)
|
||
/
|
||
|
||
create table PUBTTXIF
|
||
(
|
||
AP_MMO VARCHAR2(3),
|
||
TXN_CD VARCHAR2(6),
|
||
TXN_NM VARCHAR2(60),
|
||
TX_LVL VARCHAR2(1),
|
||
ATH_LVL1 VARCHAR2(1),
|
||
ATH_LVL2 VARCHAR2(1),
|
||
HOL_RUN_FLG VARCHAR2(1),
|
||
SELF_ATH_FLG VARCHAR2(1),
|
||
TX_CLS VARCHAR2(256),
|
||
COR_ALW_FLG VARCHAR2(1),
|
||
BAT_ATH_FLG VARCHAR2(1),
|
||
BAT_ATH_NUM VARCHAR2(1),
|
||
STSW VARCHAR2(30),
|
||
RUN_MODE VARCHAR2(1),
|
||
UPD_DT VARCHAR2(8),
|
||
UPD_TLR VARCHAR2(10)
|
||
)
|
||
/
|
||
|
||
create unique index PK_PUBTTXIF
|
||
on PUBTTXIF (AP_MMO, TXN_CD)
|
||
/
|
||
|
||
create table PUBUSRDAT
|
||
(
|
||
REC_KEY VARCHAR2(100),
|
||
USR_DAT VARCHAR2(3072) default ' ',
|
||
CUR_PAG VARCHAR2(4) default ' ',
|
||
END_PAG VARCHAR2(4) default ' '
|
||
)
|
||
/
|
||
|
||
create table PUBTBTPINF
|
||
(
|
||
NAME VARCHAR2(100) not null
|
||
constraint SYS_C0012933
|
||
primary key,
|
||
SQL_TEXT VARCHAR2(2000) not null,
|
||
OBJ_SVR VARCHAR2(10) not null,
|
||
OBJ_TXNCD VARCHAR2(20) not null,
|
||
INTERVAL NUMBER default 60 not null,
|
||
LAST_TIM NUMBER default 0 not null,
|
||
MAX_TMS NUMBER default 5 not null,
|
||
BEG_TM CHAR(6) default '000000' not null,
|
||
END_TM CHAR(6) default '235959' not null,
|
||
CONC_NUM NUMBER default 1 not null,
|
||
STS CHAR default '1' not null,
|
||
NOD_ID VARCHAR2(50) default ' ' not null,
|
||
UPD_OPR VARCHAR2(10) default ' ' not null,
|
||
RMK VARCHAR2(80) default ' ' not null,
|
||
TM_SMP CHAR(14) default ' ' not null
|
||
)
|
||
/
|
||
|
||
create index IDX1_PUBTBTPINF
|
||
on PUBTBTPINF (NOD_ID, STS)
|
||
/
|
||
|
||
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,
|
||
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)
|
||
)
|
||
/
|
||
|
||
create table PUBLCKREC
|
||
(
|
||
RECKEY VARCHAR2(80) not null
|
||
constraint PUBLCKREC_PK
|
||
primary key,
|
||
LCKTIM VARCHAR2(10),
|
||
TIMOUT VARCHAR2(6),
|
||
UPDFLG VARCHAR2(1)
|
||
)
|
||
/
|
||
|