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)
)
/