create table CMMTBKIN
(
	LBNK_NO VARCHAR2(12),
	LBNK_NM VARCHAR2(60) default ' ',
	LBNK_CD VARCHAR2(3) default ' ',
	CORP_ORG VARCHAR2(12) default ' ',
	ADM_CITY VARCHAR2(20) default ' ',
	ADM_PROV VARCHAR2(20) default ' ',
	ADM_RGN VARCHAR2(20) default ' ',
	PROV_CD VARCHAR2(2) default ' ',
	CITY_CD VARCHAR2(4) default ' ',
	TM_SMP VARCHAR2(26) default ' '
)
/

create unique index CMMTBKIN_PK
	on CMMTBKIN (LBNK_NO)
/

create unique index CMMTBKIN_PK2
	on CMMTBKIN (LBNK_NM)
/

create table CMMTBKTR
(
	CORP_ORG VARCHAR2(12) not null,
	TX_CD VARCHAR2(10) default ' ' not null,
	SUB_TX_CD VARCHAR2(2) default ' ' not null,
	COMP_NM VARCHAR2(30) default ' ' not null,
	COMP_DESC VARCHAR2(200) default ' ' not null,
	TM_SMP VARCHAR2(26) default ' ' not null,
	constraint PK_CMMTBKTR
		primary key (CORP_ORG, TX_CD, SUB_TX_CD)
)
/

create table CMMTBKTYP
(
	BNK_TYP VARCHAR2(10),
	BNK_NM VARCHAR2(100) default ' ',
	TM_SMP VARCHAR2(26) default ' ',
	BNK_CD VARCHAR2(20) default ' ' not null
)
/


create table CMMTBUSI
(
	CORP_ORG VARCHAR2(12) not null,
	COP_BUS_TYP VARCHAR2(2) default ' ' not null,
	BUS_OPN_FLG VARCHAR2(1) default ' ' not null,
	SUB_BUS_STSW VARCHAR2(32) default ' ' not null,
	BUS_LNK_FLG VARCHAR2(1) default ' ' not null,
	DFT_FLG VARCHAR2(1) default ' ' not null,
	AGT_FLG VARCHAR2(1) default ' ' not null,
	CHK_TM_FLG VARCHAR2(1) default ' ' not null,
	CHK_MOD VARCHAR2(1) default ' ' not null,
	GEN_CFIL_MOD VARCHAR2(1) default ' ' not null,
	CHK_PERD VARCHAR2(2) default ' ' not null,
	RFD_TERM VARCHAR2(3) default ' ' not null,
	CUP_TXN_FLG VARCHAR2(1) default ' ' not null,
	MERC_COV_FLG VARCHAR2(1) default ' ' not null,
	CORG_SIG_FLG VARCHAR2(1) default ' ' not null,
	CORG_SIG_TYP VARCHAR2(1) default ' ' not null,
	REQ_SEQ_FLG VARCHAR2(1) default ' ' not null,
	RFD_FLG VARCHAR2(1) default ' ' not null,
	CORG_DT VARCHAR2(8) default ' ' not null,
	RTR_SVR VARCHAR2(10) default ' ' not null,
	TM_SMP VARCHAR2(26) default ' ' not null,
	SIG_FLG VARCHAR2(10),
	RFD_AUTO_FLG VARCHAR2(1) default ' ' not null,
	DISP_NO NUMBER(4) default 0 not null,
	CORG_TYP VARCHAR2(10) default ' ',
	TM_DORM VARCHAR2(20) default '30',
	FLOW_CONTROL VARCHAR2(10) default ' ',
	CORG_MA_NM VARCHAR2(10) default ' ',
	CORG_MA_NO VARCHAR2(10) default ' ',
	CORG_AC_NM VARCHAR2(10) default ' ',
	CHK_CORG VARCHAR2(10) default ' ',
	DISP_FLG VARCHAR2(10) default ' ',
	constraint PK_CMMTBUSI
		primary key (CORP_ORG, COP_BUS_TYP)
)
/

create index CMMTBUSI_NI1
	on CMMTBUSI (COP_BUS_TYP)
/

create table CMMTCAP
(
	CAP_CORG VARCHAR2(12) not null,
	COP_BUS_TYP VARCHAR2(2) default ' ' not null,
	CORP_ORG VARCHAR2(12) default ' ' not null,
	CAP_CORG_NM VARCHAR2(60) default ' ' not null,
	BNK_TYP VARCHAR2(4) default ' ' not null,
	CARD_TYP_STSW VARCHAR2(11) default ' ' not null,
	SIG_FLG VARCHAR2(1) default ' ' not null,
	SIT_TYP_STSW VARCHAR2(20) default ' ' not null,
	CHK_TYP VARCHAR2(1) default ' ' not null,
	CORP_GATE_ID VARCHAR2(12) default ' ' not null,
	LMT_AMT NUMBER(9,2) default 0 not null,
	DAY_LMT_AMT NUMBER(9,2) default 0 not null,
	ENB_FLG VARCHAR2(1) default '0' not null,
	SEQ_NO NUMBER(8) default 0 not null,
	URL VARCHAR2(200) default ' ' not null,
	RESERVE VARCHAR2(200) default ' ' not null,
	TM_SMP VARCHAR2(26) default ' ' not null,
	RESERVE1 VARCHAR2(200) default ' ' not null,
	CAP_1_TYPE VARCHAR2(10),
	RESERVE2 VARCHAR2(300),
	OPAY_FLG VARCHAR2(3) default '000' not null,
	constraint PK_CMMTCAP
		primary key (CAP_CORG, COP_BUS_TYP, CORP_ORG)
)
/

create table CMMTCCOP
(
	CITY_CD VARCHAR2(4),
	PROV_CD VARCHAR2(2) default ' ',
	CITY_LNM VARCHAR2(60) default ' ',
	CITY_NM VARCHAR2(16),
	BSS_CITY VARCHAR2(4) default ' ',
	VASP_CITY VARCHAR2(5) default ' ',
	UPD_OPR VARCHAR2(10) default ' ',
	UPD_DT VARCHAR2(8) default ' ',
	TM_SMP VARCHAR2(26) default SYSDATE
)
/

create index CMMTCCOP_NI1
	on CMMTCCOP (PROV_CD, CITY_CD)
/

create index CMMTCCOP_NI2
	on CMMTCCOP (BSS_CITY)
/

create index CMMTCCOP_NI3
	on CMMTCCOP (VASP_CITY)
/

create unique index CMMTCCOP_PK
	on CMMTCCOP (CITY_CD, CITY_NM)
/

create unique index CMMTCCOP_UI1
	on CMMTCCOP (CITY_NM)
/

create index IDX_CMMTCCOP_CITY_CD
	on CMMTCCOP (CITY_CD)
/

create table CMMTCONS
(
	CST_NM VARCHAR2(20),
	EFF_DT VARCHAR2(8),
	EXP_DT VARCHAR2(8),
	PARM_CLS VARCHAR2(3) default ' ',
	CST_DISP_NM VARCHAR2(60) default ' ',
	CST_TYP VARCHAR2(1) default ' ',
	CST_LEN NUMBER(3) default 0,
	TX_UPD_FLG VARCHAR2(1) default ' ',
	CST_VAL VARCHAR2(32) default ' ',
	RMK VARCHAR2(60) default ' ',
	EFF_MOD VARCHAR2(1) default ' ',
	UPD_OPR VARCHAR2(10) default ' ',
	TM_SMP VARCHAR2(26) default ' '
)
/

create table CMMTCORGRSPINF
(
	CORG_RSP_CD VARCHAR2(2),
	CORG_RSP_INF VARCHAR2(100),
	TM_SMP VARCHAR2(20)
)
/

create table CMMTDEPT
(
	PROV_CD VARCHAR2(2),
	CITY_CD VARCHAR2(4) default ' ',
	DEPT_CD VARCHAR2(4),
	PROV_LVL VARCHAR2(1) default ' ',
	ORG_CD VARCHAR2(10) default ' ',
	BSS_ORG VARCHAR2(32) default ' ',
	TM_SMP VARCHAR2(26) default SYSDATE,
	DEPT_NM VARCHAR2(60) default ' ',
	CITY_NM VARCHAR2(16) default ' ',
	UPD_OPR VARCHAR2(10) default ' ',
	UPD_DT VARCHAR2(8) default ' '
)
/

create unique index CMMTDEPT_KEY
	on CMMTDEPT (PROV_CD, CITY_CD, DEPT_CD, CITY_NM)
/

create index CMMTDEPT_NI1
	on CMMTDEPT (BSS_ORG)
/

create unique index CMMTDEPT_PK
	on CMMTDEPT (PROV_CD, CITY_CD, DEPT_CD)
/

create unique index CMMTDEPT_UI1
	on CMMTDEPT (ORG_CD)
/

create table CMMTFUNC
(
	FUNC_ID VARCHAR2(10),
	FUNC_NO VARCHAR2(10) default ' ',
	FUNC_NM VARCHAR2(60) default ' ',
	FUNC_TYP VARCHAR2(1) default ' ',
	FUNC_DESC VARCHAR2(120) default ' ',
	ICON_NM VARCHAR2(10) default ' ',
	URL VARCHAR2(50) default ' ',
	MODULE_TYP VARCHAR2(10) default ' ',
	PFUNC_NO VARCHAR2(10) default ' ',
	ORG_NO VARCHAR2(10) default ' ',
	STS VARCHAR2(1) default '0',
	UPD_OPR VARCHAR2(10) default ' ',
	TM_SMP VARCHAR2(26) default ' '
)
/

comment on table CMMTFUNC is '内部门户功能信息表'
/

comment on column CMMTFUNC.FUNC_ID is '功能ID'
/

comment on column CMMTFUNC.FUNC_NO is '功能编号'
/

comment on column CMMTFUNC.FUNC_NM is '功能名称'
/

comment on column CMMTFUNC.FUNC_TYP is '功能类别'
/

comment on column CMMTFUNC.FUNC_DESC is '功能描述'
/

comment on column CMMTFUNC.ICON_NM is '图标名称'
/

comment on column CMMTFUNC.URL is 'URL'
/

comment on column CMMTFUNC.MODULE_TYP is '模块类型'
/

comment on column CMMTFUNC.PFUNC_NO is '父级功能编号'
/

comment on column CMMTFUNC.ORG_NO is '归属机构'
/

comment on column CMMTFUNC.STS is '激活状态'
/

comment on column CMMTFUNC.UPD_OPR is '更新操作员'
/

comment on column CMMTFUNC.TM_SMP is '时间戳'
/

create unique index CMMTFUNC_PK
	on CMMTFUNC (FUNC_ID)
/

create table CMMTFUNCROLE
(
	FUNCROLE_ID NUMBER,
	FUNC_NO VARCHAR2(10),
	ROLE_ID NUMBER,
	STS CHAR default '1',
	TM_SMP CHAR(14),
	UPD_OPER VARCHAR2(10),
	ORG_CD VARCHAR2(10)
)
/

create table CMMTHOLIDAY
(
	HOL_ID VARCHAR2(8) not null
		constraint PK_CMMTHOLIDAY
			primary key,
	HOL_NM VARCHAR2(60) default ' ' not null,
	HOL_BEG_DT VARCHAR2(8) default TO_CHAR(SYSDATE,'YYYYMMDD') not null,
	HOL_END_DT VARCHAR2(8) default TO_CHAR(SYSDATE,'YYYYMMDD') not null,
	TM_SMP VARCHAR2(26) default TO_CHAR(SYSTIMESTAMP,'YYYYMMDDHH24MISSFF6') not null,
	RMK VARCHAR2(128) default ' ' not null
)
/

comment on table CMMTHOLIDAY is '节假日信息表'
/

comment on column CMMTHOLIDAY.HOL_ID is '节假日编号'
/

comment on column CMMTHOLIDAY.HOL_NM is '节假日名称'
/

comment on column CMMTHOLIDAY.HOL_BEG_DT is '节假日开始日期'
/

comment on column CMMTHOLIDAY.HOL_END_DT is '节假日截止日期'
/

comment on column CMMTHOLIDAY.TM_SMP is '时间戳'
/

comment on column CMMTHOLIDAY.RMK is '备注'
/

create table CMMTINORG
(
	ORG_NO VARCHAR2(10),
	ORG_NM VARCHAR2(40) default ' ',
	ORG_STS VARCHAR2(1) default '0',
	ORG_LVL VARCHAR2(1) default '0',
	SUP_ORG VARCHAR2(10) default ' ',
	ORG_CTY VARCHAR2(20) default ' ',
	ORG_AD VARCHAR2(80) default ' ',
	ORG_ZIP VARCHAR2(6) default ' ',
	COMM VARCHAR2(20) default ' ',
	TEL VARCHAR2(20) default ' ',
	EMAIL VARCHAR2(80) default ' ',
	UPD_DT NUMBER(8) default '0',
	UPD_TLR VARCHAR2(10) default ' ',
	TM_SMP VARCHAR2(26) default ' ',
	CITY_NM VARCHAR2(20) default ' '
)
/

create unique index CMMTINORG_PK
	on CMMTINORG (ORG_NO)
/

create table CMMTMCC
(
	MCC_CD VARCHAR2(4) not null,
	MERC_CLS_NM VARCHAR2(100) default ' ' not null,
	MERC_TRD_CLS VARCHAR2(2) not null,
	BUS_CLS VARCHAR2(100) default ' ' not null,
	IND_CLS VARCHAR2(100) default ' ' not null,
	BUS_DESC VARCHAR2(1024) default ' ' not null,
	TM_SMP VARCHAR2(26) default ' ' not null,
	constraint CMMTMCC_PK
		primary key (MCC_CD, MERC_TRD_CLS)
)
/

create table CMMTMSG
(
	MSG_CD VARCHAR2(10),
	MSG_TYP CHAR,
	AUTH_LVL1 CHAR,
	AUTH_LVL2 CHAR,
	MSG_INF VARCHAR2(60),
	BMSG_INF VARCHAR2(60),
	MON_FLG CHAR default '0',
	WARN_LVL CHAR,
	ORG_NO VARCHAR2(10),
	TM_SMP CHAR(14),
	UPD_OPER VARCHAR2(10)
)
/

create unique index P_KEY_1
	on CMMTMSG (MSG_CD)
/

create table CMMTOPER
(
	OPER_ID NUMBER,
	OPER_NO VARCHAR2(10),
	OPER_NM VARCHAR2(60),
	OPER_PWD VARCHAR2(32),
	OPER_EMAIL VARCHAR2(60),
	OPER_TYP VARCHAR2(1),
	OPER_DESC VARCHAR2(120),
	AUTH_LVL VARCHAR2(1),
	MBL_NO VARCHAR2(15),
	TEL_NO VARCHAR2(15),
	PWD_EXP_PERIOD NUMBER default 30,
	PWD_UPD_DT CHAR(8),
	VAL_DT CHAR(8),
	EXP_DT CHAR(8),
	STS CHAR default '1',
	LOGIN_TM CHAR(14),
	LAST_LOG_TM CHAR(14),
	LOGIN_TMS NUMBER default 0,
	LOG_MOD CHAR default '1',
	USB_KEY_ID VARCHAR2(60),
	PSW_FAIL_CNT NUMBER default 0,
	PSW_FAIL_MAX_CNT NUMBER default 3,
	TM_SMP CHAR(14),
	UPD_OPER VARCHAR2(10),
	LOG_CRED_NO VARCHAR2(32),
	OPR_STS VARCHAR2(1),
	OPR_LVL VARCHAR2(1),
	OPR_PROV VARCHAR2(2),
	PROV_NM VARCHAR2(60),
	OPR_CITY VARCHAR2(4),
	CITY_NM VARCHAR2(60),
	OPR_DEPT VARCHAR2(4),
	DEPT_NM VARCHAR2(60),
	CRED_EXP_TM_TYP CHAR,
	CRED_EXP_TM CHAR(6),
	LOG_STS CHAR,
	LOG_PSWD_STS CHAR default 2,
	QRY_DAT_SCP CHAR default 2,
	ORG_CD VARCHAR2(10),
	AC_ORG_CD VARCHAR2(60),
	OPR_LEVL VARCHAR2(2),
	VER_CODE VARCHAR2(6),
	VER_TM VARCHAR2(10)
)
/

create unique index P_CMTOPER_PK
	on CMMTOPER (OPER_ID)
/

create unique index P_CMTOPER_UN
	on CMMTOPER (OPER_NO)
/

create table CMMTOPERROLE
(
	OPERROLE_ID NUMBER,
	ROLE_ID NUMBER,
	OPER_NO VARCHAR2(10),
	STS CHAR default '1',
	TM_SMP CHAR(14),
	UPD_OPER VARCHAR2(10),
	ORG_CD VARCHAR2(10)
)
/

create unique index P_CMTOPERROLE_PK
	on CMMTOPERROLE (OPERROLE_ID)
/

create table CMMTOPLG
(
	SYS_DT VARCHAR2(8),
	SYS_TM VARCHAR2(6),
	JRN_NO NUMBER(18),
	AC_DT VARCHAR2(8),
	OPR_PROV VARCHAR2(4),
	OPR_CITY VARCHAR2(4),
	OPR_DEPT VARCHAR2(10),
	OPR_ID VARCHAR2(10),
	TX_TYP VARCHAR2(4),
	TX_CD VARCHAR2(10),
	BUS_TYP VARCHAR2(4),
	BUS_ACP_CNL VARCHAR2(5),
	SYS_ACS_CNL VARCHAR2(5),
	IP_ADDR VARCHAR2(15),
	PHY_ADDR VARCHAR2(30),
	DAT_FMT VARCHAR2(7),
	DAT_INF VARCHAR2(2048),
	TM_SMP VARCHAR2(26)
)
/

create table CMMTORGN
(
	CORP_ORG VARCHAR2(12) not null
		constraint PK_CMMTORGN
			primary key,
	ENB_FLG VARCHAR2(1) default ' ' not null,
	CORG_NM VARCHAR2(60) default ' ' not null,
	CORG_TYP VARCHAR2(1) default ' ' not null,
	BNK_TYP VARCHAR2(4) default ' ' not null,
	LNK_FLG VARCHAR2(1) default '0' not null,
	IN_POS_AC VARCHAR2(19) default ' ' not null,
	SUB_ITM_NO VARCHAR2(20) default ' ' not null,
	STL_OPN_LBNK VARCHAR2(12) default ' ' not null,
	LBNK_CD VARCHAR2(3) default ' ' not null,
	STL_OPN_LBNK_NM VARCHAR2(60) default ' ' not null,
	STL_AC_NM VARCHAR2(60) default ' ' not null,
	STL_OAC VARCHAR2(32) default ' ' not null,
	POS_IAC VARCHAR2(19) default ' ' not null,
	RFD_EXC_NO VARCHAR2(12) default ' ' not null,
	RFD_BNK_NO VARCHAR2(8) default ' ' not null,
	RFD_BNK_NM VARCHAR2(80) default ' ' not null,
	RFD_AC_NM VARCHAR2(80) default ' ' not null,
	RFD_AC_NO VARCHAR2(28) default ' ' not null,
	CORG_AD VARCHAR2(80) default ' ' not null,
	CORG_ZIP VARCHAR2(6) default ' ' not null,
	CTT_PSN_CNM VARCHAR2(60) default ' ' not null,
	CTT_PSN_TEL VARCHAR2(18) default ' ' not null,
	CTT_PSN_EMAIL VARCHAR2(30) default ' ' not null,
	CUS_MGR VARCHAR2(7) default ' ' not null,
	CORP_SNM VARCHAR2(16) default ' ' not null,
	CORP_URL VARCHAR2(256) default ' ' not null,
	TM_SMP VARCHAR2(26) default ' ' not null,
	SIGN_FLG VARCHAR2(2) default ' ' not null,
	CANCEL_FLG VARCHAR2(2) default ' ' not null,
	RFD_FLG VARCHAR2(1) default ' ' not null,
	STL_MTH VARCHAR2(1) default '1' not null,
	DISP_NO VARCHAR2(64) default ' ',
	WORK_KEY VARCHAR2(64),
	OUT_TERM_ID VARCHAR2(64),
	OUT_MERC_ID VARCHAR2(64)
)
/

create table CMMTPBCD
(
	PUB_CD_TYP VARCHAR2(5),
	PUB_CD_VAL VARCHAR2(30),
	PUB_CD_LEN NUMBER(2) default 0,
	UP_CD_TYP VARCHAR2(5) default ' ',
	UP_CD_VAL VARCHAR2(30) default ' ',
	PUB_CD_ABBR VARCHAR2(30) default ' ',
	PUB_CD_DESC VARCHAR2(120) default ' ',
	AUX_CTL VARCHAR2(30) default ' ',
	TM_SMP VARCHAR2(26) default SYSDATE,
	UPD_OPR VARCHAR2(10) default ' '
)
/

create index CMMTPBCD_NI1
	on CMMTPBCD (PUB_CD_TYP, PUB_CD_ABBR)
/

create unique index CMMTPBCD_PK
	on CMMTPBCD (PUB_CD_TYP, PUB_CD_VAL)
/

create table CMMTPCOP
(
	PROV_CD VARCHAR2(2),
	PROV_LVL VARCHAR2(1) default ' ',
	PROV_ACS_STS VARCHAR2(1) default ' ',
	CNCT_BSS_STS VARCHAR2(1) default ' ',
	BSS_PROV VARCHAR2(2) default ' ',
	LPS_CD VARCHAR2(8) default ' ',
	VASP_PROV VARCHAR2(3) default ' ',
	UPD_DT VARCHAR2(8) default ' ',
	TM_SMP VARCHAR2(26) default SYSDATE,
	PROV_LNM VARCHAR2(60) default ' ',
	PROV_NM VARCHAR2(16) default ' ',
	UPD_OPR VARCHAR2(10) default ' ',
	CHK_FLG VARCHAR2(1) default '0'
)
/

create index CMMTPCOP_NI1
	on CMMTPCOP (BSS_PROV)
/

create index CMMTPCOP_NI2
	on CMMTPCOP (VASP_PROV)
/

create unique index CMMTPCOP_PK
	on CMMTPCOP (PROV_CD)
/

create table CMMTROLE
(
	ROLE_ID NUMBER,
	ROLE_NM VARCHAR2(60),
	ROLE_DESC VARCHAR2(120),
	STS CHAR default '1',
	TM_SMP CHAR(14),
	UPD_OPER VARCHAR2(10),
	ORG_CD VARCHAR2(10)
)
/

create unique index CMMTROLE_IDX1
	on CMMTROLE (ROLE_NM)
/

create unique index P_CMTROLE_PK
	on CMMTROLE (ROLE_ID)
/

create table CMMTROUT
(
	CORP_ORG VARCHAR2(12),
	COP_BUS_TYP VARCHAR2(2),
	PRI_LVL NUMBER(3),
	RUT_CORG VARCHAR2(12) default ' ',
	CORP_GATE_ID VARCHAR2(12) default ' ',
	TM_SMP VARCHAR2(26) default SYSDATE,
	RUT_EFF_FLG VARCHAR2(1) default '0' not null
)
/

create unique index CMMTROUT_PK
	on CMMTROUT (CORP_ORG, COP_BUS_TYP, PRI_LVL)
/

create table CMMTRTRULE
(
	BNK_TYP VARCHAR2(4),
	CORG_NO VARCHAR2(12),
	WEIGHT NUMBER(3) default 0,
	TM_SMP VARCHAR2(26) default ' ',
	TXN_CNL VARCHAR2(20) default 'CAP' not null,
	TXN_CNLNA VARCHAR2(64) default '易才批量代付' not null
)
/

create unique index HPSTRTRULE_PK
	on CMMTRTRULE (BNK_TYP, CORG_NO)
/

create table CMMTSEQ
(
	BR_NO VARCHAR2(6),
	SEQ_NM VARCHAR2(30),
	SEQ_VAL NUMBER(10) default 0,
	TM_SMP VARCHAR2(26) default SYSDATE
)
/

create unique index CMMTSEQ_PK
	on CMMTSEQ (BR_NO, SEQ_NM)
/

create table CMMTTXIF
(
	TXN_COD VARCHAR2(10),
	TXN_NM VARCHAR2(100),
	TXN_TYP CHAR(3),
	LOG_FLG CHAR,
	BUS_TYP CHAR(3),
	BUS_CNL_BIT CHAR(10) default '1111111111',
	SYS_CNL_BIT CHAR(10) default '1111111111',
	COR_ALW_FLG CHAR default 'N',
	CHKC_FLG CHAR default 'N',
	TXN_LVL CHAR(2) default '0',
	AUTH_LVL1 CHAR(2) default '00',
	AUTH_LVL2 CHAR(2) default '00',
	HOL_RUN_FLG CHAR default '0',
	SELF_ATH_FLG CHAR default 'N',
	TXN_CLS VARCHAR2(256) default '0000000000000000000000000000',
	BAT_ATH_FLG CHAR default 'N',
	BAT_ATH_NUM NUMBER default 0,
	STSW VARCHAR2(256) default '0000000000000000000000000000',
	RUN_MODE CHAR default 'D',
	ORG_NO VARCHAR2(10),
	TM_SMP VARCHAR2(14),
	UPD_OPER VARCHAR2(14)
)
/

create index CMMTTXIF_IDX2
	on CMMTTXIF (TXN_NM)
/

create table CMMTTXNIF
(
	TXN_COD VARCHAR2(10),
	TXN_DESC VARCHAR2(100),
	TM_SMP VARCHAR2(24)
)
/

create unique index PK_TXN_CD
	on CMMTTXNIF (TXN_COD)
/

create table CMMTUFIT
(
	FIT_TRK VARCHAR2(1),
	FIT_OFS VARCHAR2(2),
	FIT_CTT VARCHAR2(20),
	FIT_LEN VARCHAR2(2) default ' ',
	CRD_TRK VARCHAR2(1) default ' ',
	CRD_OFS VARCHAR2(2) default ' ',
	CRD_LEN VARCHAR2(2) default ' ',
	CRD_FLG VARCHAR2(2) default ' ',
	EXP_DT_FLG VARCHAR2(2) default ' ',
	CRD_NM VARCHAR2(200) default ' ',
	INT_MOD VARCHAR2(1) default ' ',
	BNK_TYP VARCHAR2(4) default ' ',
	TM_SMP VARCHAR2(26) default ' ',
	CODE VARCHAR2(20) default ' '
)
/

create unique index CMMTUFIT_PK
	on CMMTUFIT (FIT_TRK, FIT_OFS, FIT_CTT, CRD_LEN)
/

create table CMMTMFEE
(
	CORP_ORG VARCHAR2(12) not null,
	CAP_TYP VARCHAR2(1) not null,
	TX_MOD VARCHAR2(1) not null,
	FEE_TYP VARCHAR2(2) not null,
	EFF_DT VARCHAR2(8) not null,
	EXP_DT VARCHAR2(8) default ' ' not null,
	FEE_DRT_FLG VARCHAR2(1) default ' ' not null,
	FEE_IAC_TYP VARCHAR2(3) default ' ' not null,
	FEE_IN_AC VARCHAR2(19) default ' ' not null,
	FEE_PERD_UNIT VARCHAR2(1) default ' ' not null,
	FEE_PERD_NUM NUMBER(2) default 0 not null,
	NEXT_FEE_DT VARCHAR2(8) default ' ' not null,
	ORG_FEE_MOD VARCHAR2(1) default '0' not null,
	FEE_CAL_MTH VARCHAR2(1) default ' ' not null,
	FEE_CCY VARCHAR2(3) default ' ' not null,
	BEG_AMT NUMBER(13,2) default 0 not null,
	MIN_FEE_AMT NUMBER(11,2) default 0 not null,
	MAX_FEE_AMT NUMBER(11,2) default 0 not null,
	FEE_CAL_BAS_FLG VARCHAR2(1) default ' ' not null,
	FEE_LVL_FLG VARCHAR2(4) default ' ' not null,
	FEE_LVL_BAS_FLG VARCHAR2(4) default ' ' not null,
	UP_REF1 NUMBER(11,2) default 0 not null,
	FIX_FEE_AMT1 NUMBER(9,4) default 0 not null,
	FEE_RAT1 NUMBER(5,2) default 0 not null,
	UP_REF2 NUMBER(11,2) default 0 not null,
	FIX_FEE_AMT2 NUMBER(9,4) default 0 not null,
	FEE_RAT2 NUMBER(5,2) default 0 not null,
	UP_REF3 NUMBER(11,2) default 0 not null,
	FIX_FEE_AMT3 NUMBER(9,4) default 0 not null,
	FEE_RAT3 NUMBER(5,2) default 0 not null,
	UP_REF4 NUMBER(11,2) default 0 not null,
	FIX_FEE_AMT4 NUMBER(9,4) default 0 not null,
	FEE_RAT4 NUMBER(5,2) default 0 not null,
	UP_REF5 NUMBER(11,2) default 0 not null,
	FIX_FEE_AMT5 NUMBER(9,4) default 0 not null,
	FEE_RAT5 NUMBER(5,2) default 0 not null,
	TM_SMP VARCHAR2(26) default SYSDATE not null,
	UPD_JRN NUMBER(18) default 0 not null,
	FEE_AC_CAP VARCHAR2(1) default ' ' not null,
	CTT_PSN_NO NUMBER(2),
	STL_TXN_TYP VARCHAR2(1) default '0' not null,
	STL_ACC_TYP VARCHAR2(1) default '0' not null,
	STL_FEE_TYP VARCHAR2(1) default '0' not null,
	constraint CMMTMFEE_PK
		primary key (CORP_ORG, CAP_TYP, TX_MOD, FEE_TYP, EFF_DT, STL_TXN_TYP, STL_ACC_TYP, STL_FEE_TYP)
)
/

create unique index UI1_CMMTMFEE
	on CMMTMFEE (CORP_ORG)
/

create table CMMTRPTREG
(
	RPT_DAT VARCHAR2(8) not null,
	RPT_TYP VARCHAR2(1) not null,
	RPT_KND VARCHAR2(32),
	RPT_FIL VARCHAR2(60) not null,
	RPT_FIL_NM VARCHAR2(120),
	TM_SMP VARCHAR2(26),
	RPT_FIL_URL VARCHAR2(512) DEFAULT ' ', 
	constraint CMMTRPTREG_PK
		primary key (RPT_DAT, RPT_TYP, RPT_FIL)
)
/

create index CMMTRPTREG_NI1
	on CMMTRPTREG (RPT_DAT)
/

create table ORGACTINF
(
	CORG_NO VARCHAR2(30) not null,
	CAP_TYP VARCHAR2(30) not null,
	ACT_NO VARCHAR2(80),
	ACT_NAM VARCHAR2(200),
	BNK_NAM VARCHAR2(200),
	LBNK_NO VARCHAR2(80),
	LBNK_NAM VARCHAR2(200),
	ACT_BLC VARCHAR2(50),
	ACT_STS VARCHAR2(4),
	UPD_TIM VARCHAR2(28),
	RLR_STS VARCHAR2(40) default '0',
	TM_SMP VARCHAR2(26) default SYSDATE not null,
	constraint ORGACTINF_PK
		primary key (CORG_NO, CAP_TYP)
)
/

create table ORGLMTRLR
(
	CORG_NO VARCHAR2(30) not null,
	CAP_TYP VARCHAR2(30) not null,
	SUB_TYP VARCHAR2(30),
	ST_TIM VARCHAR2(28) default '000000',
	ED_TIM VARCHAR2(28) default '235959',
	HOD_FLG VARCHAR2(2) default 'Y',
	LMT_MAX_PL_AMT VARCHAR2(40) default '0',
	LMT_MIN_PL_AMT VARCHAR2(40) default '0',
	LMT_MAX_CD_AMT VARCHAR2(40) default '0',
	LMT_MIN_CD_AMT VARCHAR2(40) default '0',
	LMT_MAX_BAT_AMT VARCHAR2(40) default '0',
	LMT_MIN_BAT_AMT VARCHAR2(40) default '0',
	LMT_MAX_DAY_AMT VARCHAR2(40) default '0',
	LMT_MIN_DAY_AMT VARCHAR2(40) default '0',
	LMT_MAX_MTH_AMT VARCHAR2(40) default '0',
	LMT_MIN_MTH_AMT VARCHAR2(40) default '0',
	LMT_MAX_YAR_AMT VARCHAR2(40) default '0',
	LMT_MIN_YAR_AMT VARCHAR2(40) default '0',
	LMT_MAX_BAT_CNT VARCHAR2(40) default '0',
	LMT_MAX_DAY_CNT VARCHAR2(40) default '0',
	LMT_MAX_MTH_CNT VARCHAR2(40) default '0',
	LMT_MAX_YAR_CNT VARCHAR2(40) default '0',
	RLR_STS VARCHAR2(40) default '0',
	TM_SMP VARCHAR2(26) default SYSDATE not null,
	constraint ORGLMTRLR_PK
		primary key (CORG_NO, CAP_TYP)
)
/

create table CMMTRTRULE_BATCH
(
	RUL_NO CHAR(4) default '0001' not null,
	RUL_LVL NUMBER default 0 not null,
	TRA_CD CHAR(7) default '',
	YMCC_CD VARCHAR2(6) default '',
	RARD_CD CHAR(4) default '',
	CRD_FLG CHAR(2) default '',
	BNK_TYP VARCHAR2(4) default '',
	BNK_NM VARCHAR2(40) default '',
	ATM_LOW VARCHAR2(11),
	ATM_UP VARCHAR2(11),
	DAT_LOW CHAR(8) default '',
	DAT_UP CHAR(8) default '',
	TIM_LOW CHAR(6) default '',
	TIM_UP CHAR(6) default '',
	CORG_NO VARCHAR2(12) default '',
	CORG_NM VARCHAR2(100) default '',
	RUL_STS CHAR default '0' not null,
	TM_SMP CHAR(26) default '' not null,
	WEIGHT NUMBER(3) default 0,
	TXN_CNL VARCHAR2(20) default 'HRO' not null,
	TXN_CNLNA VARCHAR2(64) default '易才批量代付' not null,
	ROUT_FLG VARCHAR2(5) default 'SUPER',
	GRP_NM VARCHAR2(20) default ' ' not null,
    SKIP_HLD CHAR(1) default 'N' not null,
	constraint CMMTRTRULE_BATCH_FK
		primary key (RUL_NO)
)
/

comment on column CMMTRTRULE_BATCH.RUL_NO is ''
/

comment on column CMMTRTRULE_BATCH.ROUT_FLG is '汇路  SUPER:超网  LARGE:大额 SMALL:小额'
/

create table CMMTEMRULE_BATCH
(
	RUL_NO CHAR(4) default '0001' not null,
	RUL_LVL NUMBER default 0 not null,
	TRA_CD CHAR(7) default '',
	YMCC_CD VARCHAR2(6) default '',
	RARD_CD CHAR(4) default '',
	CRD_FLG CHAR(2) default '',
	BNK_TYP VARCHAR2(4) default '',
	BNK_NM VARCHAR2(40) default '',
	ATM_LOW VARCHAR2(11),
	ATM_UP VARCHAR2(11),
	DAT_LOW CHAR(8) default '',
	DAT_UP CHAR(8) default '',
	TIM_LOW CHAR(6) default '',
	TIM_UP CHAR(6) default '',
	CORG_NO VARCHAR2(12) default '',
	CORG_NM VARCHAR2(100) default '',
	RUL_STS CHAR default '0' not null,
	TM_SMP CHAR(26) default '' not null,
	WEIGHT NUMBER(3) default 0,
	TXN_CNL VARCHAR2(20) default 'CAP' not null,
	TXN_CNLNA VARCHAR2(64) default '易才批量代付' not null,
	ROUT_FLG VARCHAR2(5) default 'SUPER',
	GRP_NM VARCHAR2(20) default ' ' not null,
    SKIP_HLD CHAR(1) default 'N' not null,   
	constraint CMMTEMRULE_BATCH_FK
		primary key (RUL_NO)
)
/

create table CMMTMSTL
(
	CORG_NO VARCHAR2(12) not null,
	EFF_DT VARCHAR2(8) not null,
	EXP_DT VARCHAR2(8) default ' ' not null,
	USR_NO NUMBER(12) default '0' not null,
	STL_SELF_FLG VARCHAR2(1) default ' ' not null,
	CORG_STL_FLG VARCHAR2(1) default ' ' not null,
	STL_MOD VARCHAR2(1) default ' ' not null,
	PAS_STL_FLG VARCHAR2(1) default ' ' not null,
	STL_PERD VARCHAR2(1) default ' ' not null,
	STL_DAY NUMBER(3) default '0' not null,
	STL_DAY_BIT VARCHAR2(31) default ' ' not null,
	STL_TRF_DAYS NUMBER(3) default '0' not null,
	STL_END_TM VARCHAR2(2) default ' ' not null,
	STL_BEG_AMT NUMBER(13,2) default '0' not null,
	MIN_RTN_AMT NUMBER(11,2) default '0' not null,
	DEP_TM_FLG VARCHAR2(1) default ' ' not null,
	WC_BNK VARCHAR2(12) default ' ' not null,
	WC_LBNK_NO VARCHAR2(12) default ' ' not null,
	OPN_BNK_PROV VARCHAR2(2) default ' ' not null,
	OPN_BNK_CITY VARCHAR2(4) default ' ' not null,
	OPN_BNK_DESC VARCHAR2(120) default ' ' not null,
	BNK_ACNM VARCHAR2(60) default ' ' not null,
	STL_OAC VARCHAR2(128) default ' ' not null,
	STL_OAC_CLS VARCHAR2(1) default ' ' not null,
	BUS_PSN_FLG VARCHAR2(1) default ' ' not null,
	LAST_STL_DT VARCHAR2(8) default ' ' not null,
	LAST_STL_TM VARCHAR2(6) default ' ' not null,
	NEXT_STL_DT VARCHAR2(8) default ' ' not null,
	NEXT_STL_TM VARCHAR2(6) default ' ' not null,
	AGR_SIGN_DT VARCHAR2(8) default ' ' not null,
	AGR_SIGN_TM VARCHAR2(6) default ' ' not null,
	AGR_CAN_DT VARCHAR2(8) default ' ' not null,
	AGR_CAN_TM VARCHAR2(6) default ' ' not null,
	AGR_TYP VARCHAR2(5) default ' ' not null,
	AGR_NO VARCHAR2(40) default ' ' not null,
	UPD_DT VARCHAR2(8) default ' ' not null,
	UPD_TM VARCHAR2(6) default ' ' not null,
	TM_SMP VARCHAR2(26) default ' ' not null,
	STL_ID_NO VARCHAR2(30),
	AMT_TYP VARCHAR2(1) default ' ' not null,
	constraint CMMTMSTL_PK
		primary key (CORG_NO, EFF_DT)
)
/

create index CMMTMSTL_NI1
	on CMMTMSTL (NEXT_STL_DT)
/

create table CMM_STUDENT
(
	CMM_ID VARCHAR2(20) not null
		constraint CMM_ID
			primary key,
	CMM_NAME VARCHAR2(20) not null,
	SEX VARCHAR2(20) not null,
	BRITHAY DATE not null,
	SPECIALITY VARCHAR2(20) not null
)
/

create table CMMTRTRGRP
(
	GRP_NM VARCHAR2(48) default ' ' not null
		constraint SYS_C0014673
			primary key,
	GRP_DSC VARCHAR2(200) default ' ' not null
)
/

create table CUSLMTRLR
(
	CAP_TYP VARCHAR2(30) not null,
	SUB_TYP VARCHAR2(30),
	ST_TIM VARCHAR2(28),
	ED_TIM VARCHAR2(28),
	HOD_FLG VARCHAR2(2),
	LMT_MAX_PL_AMT VARCHAR2(40),
	LMT_MIN_PL_AMT VARCHAR2(40),
	LMT_MAX_CD_AMT VARCHAR2(40),
	LMT_MIN_CD_AMT VARCHAR2(40),
	LMT_MAX_BAT_AMT VARCHAR2(40),
	LMT_MIN_BAT_AMT VARCHAR2(40),
	LMT_MAX_DAY_AMT VARCHAR2(40),
	LMT_MIN_DAY_AMT VARCHAR2(40),
	LMT_MAX_MTH_AMT VARCHAR2(40),
	LMT_MIN_MTH_AMT VARCHAR2(40),
	LMT_MAX_YAR_AMT VARCHAR2(40),
	LMT_MIN_YAR_AMT VARCHAR2(40),
	LMT_MAX_BAT_CNT VARCHAR2(40),
	LMT_MAX_DAY_CNT VARCHAR2(40),
	LMT_MAX_MTH_CNT VARCHAR2(40),
	LMT_MAX_YAR_CNT VARCHAR2(40),
	RLR_STS VARCHAR2(40),
	TM_SMP VARCHAR2(26) not null,
	LMT_NM VARCHAR2(20) not null,
	LMT_DESC VARCHAR2(100) default ' ' not null,
	constraint CUSLMTRLR_PK
		primary key (LMT_NM)
)
/



create table URMTMINF
(
	MERC_ID VARCHAR2(15) not null,
	USR_NO NUMBER(12) default 0 not null,
	MERC_PROV VARCHAR2(2) default ' ' not null,
	MERC_CITY VARCHAR2(4) default ' ' not null,
	MERC_CITY_NM VARCHAR2(60) default ' ' not null,
	REG_PROV VARCHAR2(4) default ' ' not null,
	MERC_STS VARCHAR2(1) default '0' not null,
	MERC_STSW VARCHAR2(15) default '0' not null,
	MERC_CNM VARCHAR2(128) default ' ' not null,
	MERC_ABBR VARCHAR2(128) default ' ' not null,
	MERC_PY_ABBR VARCHAR2(30) default ' ' not null,
	SPC_PAY_ALIAS VARCHAR2(60) default ' ' not null,
	UP_MERC_ID VARCHAR2(15) default ' ' not null,
	UP_USR_NO NUMBER(12) default 0 not null,
	CHN_REL_FLG VARCHAR2(1) default ' ' not null,
	MERC_TYP VARCHAR2(2) default ' ' not null,
	MERC_CLS VARCHAR2(1) default ' ' not null,
	THD_CD VARCHAR2(60) default ' ' not null,
	PSN_CRP_FLG VARCHAR2(1) default '1' not null,
	MERC_TRD_CLS VARCHAR2(4) default ' ' not null,
	MERC_TRD_DESC VARCHAR2(60) default ' ' not null,
	MERC_ATTR VARCHAR2(1) default ' ' not null,
	CRP_NM VARCHAR2(60) default ' ' not null,
	CRP_ID_TYP VARCHAR2(3) default ' ' not null,
	CRP_ID_NO VARCHAR2(30) default ' ' not null,
	PRIN_NM VARCHAR2(60) default ' ' not null,
	MGT_SCP VARCHAR2(60) default ' ' not null,
	CUS_MGR VARCHAR2(7) default ' ' not null,
	CUS_MGR_NM VARCHAR2(60) default ' ' not null,
	MERC_LVL VARCHAR2(8) default ' ' not null,
	CRED_LVL VARCHAR2(5) default ' ' not null,
	RCV_MAG_AMT NUMBER(18,2) default 0 not null,
	REG_CAP_AMT NUMBER(18,2) default 0 not null,
	STAF_NUM NUMBER(6) default 0 not null,
	OPN_BUS_DT VARCHAR2(8) default ' ' not null,
	MERC_POP VARCHAR2(8) default ' ' not null,
	POS_NUM NUMBER(5) default 0 not null,
	PSAM_NUM NUMBER(5) default 0 not null,
	BUS_ULD_ATTR VARCHAR2(1) default ' ' not null,
	MGT_SECT VARCHAR2(1) default ' ' not null,
	MGT_RGN VARCHAR2(1) default ' ' not null,
	ORG_RGN_SCP VARCHAR2(30) default ' ' not null,
	ORG_NUM NUMBER(6) default 0 not null,
	NEED_INV_FLG VARCHAR2(1) default ' ' not null,
	INV_MOD VARCHAR2(1) default ' ' not null,
	INV_TIT VARCHAR2(60) default ' ' not null,
	INV_MAIL_ADDR VARCHAR2(120) default ' ' not null,
	INV_MAIL_ZIP VARCHAR2(6) default ' ' not null,
	INV_MERC VARCHAR2(15) default ' ' not null,
	MERC_HOT_LIN VARCHAR2(18) default ' ' not null,
	REG_ID VARCHAR2(60) default ' ' not null,
	WEB_NM VARCHAR2(60) default ' ' not null,
	WEB_URL VARCHAR2(256) default ' ' not null,
	TAX_CERT_ID VARCHAR2(60) default ' ' not null,
	ICP_ID VARCHAR2(60) default ' ' not null,
	AIC_MEM_FLG VARCHAR2(1) default ' ' not null,
	MERC_SRC VARCHAR2(1) default ' ' not null,
	MERC_SRC_DESC VARCHAR2(60) default ' ' not null,
	RCMD_UNIT_CD VARCHAR2(3) default ' ' not null,
	RCMD_UNIT_NM VARCHAR2(60) default ' ' not null,
	CLR_FLG VARCHAR2(1) default ' ' not null,
	CLR_MERC VARCHAR2(15) default ' ' not null,
	MIN_RTN_AMT NUMBER(18,2) default 0 not null,
	REG_ADDR VARCHAR2(120) default ' ' not null,
	BUS_ADDR VARCHAR2(120) default ' ' not null,
	CLR_AC VARCHAR2(19) default ' ' not null,
	CLR_AC_TYP VARCHAR2(3) default ' ' not null,
	FAX VARCHAR2(18) default ' ' not null,
	DPNM_TMS_FLG VARCHAR2(1) default ' ' not null,
	CRE_REF_NO VARCHAR2(18) default ' ' not null,
	UPD_REF_NO VARCHAR2(18) default ' ' not null,
	CI_NO NUMBER(20) default 0 not null,
	APPR_RMK VARCHAR2(60) default ' ' not null,
	RFD_MOD VARCHAR2(1) default ' ' not null,
	RFD_FEE_PRC_MOD VARCHAR2(1) default ' ' not null,
	EFF_DT VARCHAR2(8) default ' ' not null,
	EXP_DT VARCHAR2(8) default ' ' not null,
	AGR_RMK VARCHAR2(60) default ' ' not null,
	CRE_ORG VARCHAR2(10) default '0' not null,
	CRE_DT VARCHAR2(8) default ' ' not null,
	CRE_TM VARCHAR2(6) default ' ' not null,
	OA_CRE_OPR VARCHAR2(8) default ' ' not null,
	OA_RVW_OPR VARCHAR2(8) default ' ' not null,
	UI_CRE_OPR VARCHAR2(8) default ' ' not null,
	UI_RVW_OPR VARCHAR2(8) default ' ' not null,
	UPD_DT VARCHAR2(8) default ' ' not null,
	UPD_TM VARCHAR2(6) default ' ' not null,
	UPD_OPR VARCHAR2(8) default ' ' not null,
	UPD_EFF_DT VARCHAR2(8) default ' ' not null,
	SPEC_RSC VARCHAR2(120) default ' ' not null,
	TM_SMP VARCHAR2(26) default ' ' not null,
	MKM_REB_RAT NUMBER(3) default 100,
	MERC_EFF_DT VARCHAR2(8) default ' ',
	MERC_AGR_TYP VARCHAR2(1) default '0',
	ORG_CD VARCHAR2(10),
	ORGANIZATION_CODE VARCHAR2(40),
	BUSINESS_LICENSE VARCHAR2(40),
	MERC_SUB_CLS VARCHAR2(4) default ' ' not null,
	IS_SP_PHC CHAR,
	IS_LEG_PERSON CHAR default '0'
)
/

create table PWMTCKER
(
	RUT_CORG VARCHAR2(12) not null,
	COP_BUS_TYP VARCHAR2(2) not null,
	ERR_KEY_ID VARCHAR2(100) not null,
	TX_TYP VARCHAR2(2) default ' ' not null,
	BUS_TYP VARCHAR2(4) default ' ' not null,
	CHK_ERR_DT VARCHAR2(8) default ' ' not null,
	CHK_ERR_TM VARCHAR2(6) default ' ' not null,
	CHK_BAT_NO NUMBER(18) default 0 not null,
	TX_CD VARCHAR2(20) default ' ' not null,
	CHK_TYP VARCHAR2(1) default ' ' not null,
	SPL_ABLE_FLG VARCHAR2(1) default ' ' not null,
	CAN_ABLE_FLG VARCHAR2(1) default ' ' not null,
	CHK_ERR_TYP VARCHAR2(1) default ' ' not null,
	ERR_STS VARCHAR2(1) default ' ' not null,
	FIL_TX_AMT NUMBER(18,2) default 0 not null,
	PAY_TX_AMT NUMBER(18,2) default 0 not null,
	PSN_CRP_FLG VARCHAR2(1) default ' ' not null,
	USR_ID VARCHAR2(64) default ' ' not null,
	OLD_TX_DT VARCHAR2(8) default ' ' not null,
	OLD_JRN_NO NUMBER(18) default 0 not null,
	OLD_ORD_NO VARCHAR2(20) default ' ' not null,
	OLD_CORG_KEY VARCHAR2(70) default ' ' not null,
	OPR_ID VARCHAR2(7) default ' ' not null,
	UPD_DT VARCHAR2(8) default ' ' not null,
	UPD_TM VARCHAR2(6) default ' ' not null,
	TM_SMP VARCHAR2(26) default ' ' not null,
	SUPPLY_DT VARCHAR2(8) default ' ' not null,
	SYS_DEAL VARCHAR2(2) default ' ' not null,
	constraint PWMTCKER_PK
		primary key (RUT_CORG, COP_BUS_TYP, ERR_KEY_ID, CHK_ERR_DT)
)
/

create table URMACTINF
(
	MERC_ID VARCHAR2(30) not null,
	CAP_TYP VARCHAR2(30) not null,
	ACT_NO VARCHAR2(80),
	ACT_NAM VARCHAR2(200),
	ACT_PTY VARCHAR2(80),
	PTY_NAM VARCHAR2(200),
	LOW_BLC_WRN_AMT VARCHAR2(40) default '0',
	RLR_STS VARCHAR2(40) default '0',
	TM_SMP VARCHAR2(26) default SYSDATE not null,
	constraint URMACTINF_PK
		primary key (MERC_ID, CAP_TYP)
)
/

create table URMTPINF
(
	USR_NO NUMBER(12) not null,
	USR_PROV VARCHAR2(2) default ' ' not null,
	USR_CITY VARCHAR2(4) default ' ' not null,
	USR_CITY_NM VARCHAR2(60) default ' ' not null,
	USR_STS VARCHAR2(1) default ' ' not null,
	REAL_NM_FLG VARCHAR2(2) default ' ' not null,
	REAL_NM_ATH_MOD VARCHAR2(1) default ' ' not null,
	USR_STSW VARCHAR2(15) default ' ' not null,
	PSN_CRP_FLG VARCHAR2(1) default ' ' not null,
	REG_TYP VARCHAR2(2) default ' ' not null,
	REG_MBL VARCHAR2(64) default ' ' not null,
	REG_EMAIL VARCHAR2(128) default ' ' not null,
	CRED_LVL VARCHAR2(5) default ' ' not null,
	CUS_NM VARCHAR2(60) default ' ' not null,
	ID_TYP VARCHAR2(3) default ' ' not null,
	ID_NO VARCHAR2(64) default ' ' not null,
	CI_NO NUMBER(20) default 0 not null,
	USR_GRP VARCHAR2(20) default ' ' not null,
	REG_DT VARCHAR2(8) default ' ' not null,
	REG_TM VARCHAR2(6) default ' ' not null,
	REG_AGR_VER VARCHAR2(6) default ' ' not null,
	REG_SYS_CNL VARCHAR2(5) default ' ' not null,
	RCMD_NM VARCHAR2(60) default ' ' not null,
	OLD_MBL_NO NUMBER(11) default 0 not null,
	WAIT_CLO_DT VARCHAR2(8) default ' ' not null,
	CLO_DT VARCHAR2(8) default ' ' not null,
	CUS_MGR VARCHAR2(7) default ' ' not null,
	CTT_MBL NUMBER(11) default 0 not null,
	EMAIL VARCHAR2(128) default ' ' not null,
	MAIN_AC VARCHAR2(19) default ' ' not null,
	UPD_JRN NUMBER(18) default 0 not null,
	BOSS_STSW VARCHAR2(15) default ' ' not null,
	BOSS_CUS_LVL VARCHAR2(1) default ' ' not null,
	USR_BRD_CD VARCHAR2(2) default ' ' not null,
	USR_IMSI VARCHAR2(32) default ' ' not null,
	CUS_BOSS_NM VARCHAR2(60) default ' ' not null,
	TM_SMP VARCHAR2(26) default ' ' not null,
	REG_BUS_CNL VARCHAR2(5) default ' ' not null,
	NEW_REAL_NM_FLG VARCHAR2(2) default 'U' not null
)
/

create table URMLMTRLR
(
	MERC_ID VARCHAR2(48) not null,
	CAP_TYP VARCHAR2(30) not null,
	SUB_TYP VARCHAR2(30),
	ST_TIM VARCHAR2(28) default '0',
	ED_TIM VARCHAR2(28) default '0',
	HOD_FLG VARCHAR2(2) default 'Y',
	LMT_MAX_PL_AMT VARCHAR2(40) default '0',
	LMT_MIN_PL_AMT VARCHAR2(40) default '0',
	LMT_MAX_CD_AMT VARCHAR2(40) default '0',
	LMT_MIN_CD_AMT VARCHAR2(40) default '0',
	LMT_MAX_BAT_AMT VARCHAR2(40) default '0',
	LMT_MIN_BAT_AMT VARCHAR2(40) default '0',
	LMT_MAX_DAY_AMT VARCHAR2(40) default '0',
	LMT_MIN_DAY_AMT VARCHAR2(40) default '0',
	LMT_MAX_MTH_AMT VARCHAR2(40) default '0',
	LMT_MIN_MTH_AMT VARCHAR2(40) default '0',
	LMT_MAX_YAR_AMT VARCHAR2(40) default '0',
	LMT_MIN_YAR_AMT VARCHAR2(40) default '0',
	LMT_MAX_BAT_CNT VARCHAR2(40) default '0',
	LMT_MAX_DAY_CNT VARCHAR2(40) default '0',
	LMT_MAX_MTH_CNT VARCHAR2(40) default '0',
	LMT_MAX_YAR_CNT VARCHAR2(40) default '0',
	RLR_STS VARCHAR2(40) default '0',
	TM_SMP VARCHAR2(26) default SYSDATE not null,
	constraint URMLMTRLR_PK
		primary key (MERC_ID, CAP_TYP)
)
/

create table PWMTCKCT
(
	CHK_BAT_NO NUMBER(18) not null,
	RUT_CORG VARCHAR2(12) default ' ' not null,
	COP_BUS_TYP VARCHAR2(2) default ' ' not null,
	CHK_FIL_DT VARCHAR2(8) default ' ' not null,
	FIL_DT_SEQ NUMBER(2) default 1 not null,
	CHK_FIL_NM VARCHAR2(100) default ' ' not null,
	FILE_RCV_DT VARCHAR2(8) default ' ' not null,
	CHK_TYP VARCHAR2(1) default ' ' not null,
	CHK_BEG_TM VARCHAR2(6) default ' ' not null,
	CHK_END_TM VARCHAR2(6) default ' ' not null,
	RMK VARCHAR2(60) default ' ' not null,
	AC_DT VARCHAR2(8) default ' ' not null,
	CHK_DT VARCHAR2(8) default ' ' not null,
	FIL_TOT_AMT NUMBER(18,2) default 0 not null,
	FIL_TOT_CNT NUMBER(13) default 0 not null,
	TOT_MCH_AMT NUMBER(18,2) default 0 not null,
	TOT_MCH_CNT NUMBER(9) default 0 not null,
	ERR_TOT_CNT NUMBER(9) default 0 not null,
	ERR_TOT_AMT NUMBER(18,2) default 0 not null,
	LONG_AMT NUMBER(18,2) default 0 not null,
	LONG_CNT NUMBER(13) default 0 not null,
	SHORT_AMT NUMBER(18,2) default 0 not null,
	SHORT_CNT NUMBER(13) default 0 not null,
	DOUBT_AMT NUMBER(18,2) default 0 not null,
	DOUBT_CNT NUMBER(13) default 0 not null,
	DBT_ERR_AMT NUMBER(18,2) default 0 not null,
	DBT_ERR_CNT NUMBER(13) default 0 not null,
	TOT_DR_AMT NUMBER(18,2) default 0 not null,
	TOT_DR_NUM NUMBER(9) default 0 not null,
	TOT_CR_AMT NUMBER(18,2) default 0 not null,
	TOT_CR_NUM NUMBER(9) default 0 not null,
	PAY_TOT_AMT NUMBER(18,2) default 0 not null,
	RCV_TOT_AMT NUMBER(18,2) default 0 not null,
	OTHER_INF VARCHAR2(1024) default ' ' not null,
	CHK_FIL_STS VARCHAR2(1) default ' ' not null,
	CHK_SRV VARCHAR2(10) default ' ' not null,
	CHK_TX_CD VARCHAR2(20) default ' ' not null,
	TM_SMP VARCHAR2(26) default ' ' not null,
	CNL_DOUBT_AMT NUMBER(18,2) default 0 not null,
	CNL_DOUBT_CNT NUMBER(13) default 0 not null,
	GET_FILE_NUM VARCHAR2(10) default '0',
	FIL_TOT_FEE NUMBER(18,2) default 0
)
/

create table SMSTTMPS
(
	SMS_CD VARCHAR2(10) not null
		constraint SMSTTMPS_PK
			primary key,
	SM_TYP VARCHAR2(1) not null,
	SMS_MO VARCHAR2(3) not null,
	SMS_CLS VARCHAR2(3) default ' ' not null,
	SMS_TMP VARCHAR2(256) not null,
	REP_FLD VARCHAR2(100) not null,
	ID_KEY VARCHAR2(10) not null,
	PSW_FLG VARCHAR2(1) default '0' not null,
	EFF_FLG VARCHAR2(1) default '1' not null,
	UPD_DT VARCHAR2(8) default ' ' not null,
	UPD_TLR VARCHAR2(10) default ' ' not null,
	RMK VARCHAR2(100) default ' ' not null,
	MAL_FLG VARCHAR2(20) default 'N' not null
)
/

comment on column SMSTTMPS.MAL_FLG is '邮件模板标志 Y-邮件模板，N-短信模板'
/

create table URMTMFEE
(
	MERC_ID VARCHAR2(48) not null,
	CAP_TYP VARCHAR2(1) not null,
	TX_MOD VARCHAR2(1) not null,
	FEE_TYP VARCHAR2(2) not null,
	EFF_DT VARCHAR2(8) not null,
	EXP_DT VARCHAR2(8) default ' ' not null,
	FEE_DRT_FLG VARCHAR2(1) default ' ' not null,
	FEE_IAC_TYP VARCHAR2(3) default ' ' not null,
	FEE_IN_AC VARCHAR2(19) default ' ' not null,
	FEE_PERD_UNIT VARCHAR2(1) default ' ' not null,
	FEE_PERD_NUM NUMBER(2) default 0 not null,
	NEXT_FEE_DT VARCHAR2(8) default ' ' not null,
	MERC_FEE_MOD VARCHAR2(1) default '0' not null,
	FEE_CAL_MTH VARCHAR2(1) default ' ' not null,
	FEE_CCY VARCHAR2(3) default ' ' not null,
	BEG_AMT NUMBER(18,2) default 0 not null,
	MIN_FEE_AMT NUMBER(18,2) default 0 not null,
	MAX_FEE_AMT NUMBER(18,2) default 0 not null,
	FEE_CAL_BAS_FLG VARCHAR2(1) default ' ' not null,
	FEE_LVL_FLG VARCHAR2(4) default ' ' not null,
	FEE_LVL_BAS_FLG VARCHAR2(4) default ' ' not null,
	UP_REF1 NUMBER(18,2) default 0 not null,
	FIX_FEE_AMT1 NUMBER(18,4) default 0 not null,
	FEE_RAT1 NUMBER(9,5) default 0 not null,
	UP_REF2 NUMBER(18,2) default 0 not null,
	FIX_FEE_AMT2 NUMBER(18,4) default 0 not null,
	FEE_RAT2 NUMBER(9,5) default 0 not null,
	UP_REF3 NUMBER(18,2) default 0 not null,
	FIX_FEE_AMT3 NUMBER(18,4) default 0 not null,
	FEE_RAT3 NUMBER(9,5) default 0 not null,
	UP_REF4 NUMBER(18,2) default 0 not null,
	FIX_FEE_AMT4 NUMBER(18,4) default 0 not null,
	FEE_RAT4 NUMBER(9,5) default 0 not null,
	UP_REF5 NUMBER(18,2) default 0 not null,
	FIX_FEE_AMT5 NUMBER(18,4) default 0 not null,
	FEE_RAT5 NUMBER(9,5) default 0 not null,
	TM_SMP VARCHAR2(26) default SYSDATE not null,
	UPD_JRN NUMBER(18) default 0 not null,
	FEE_AC_CAP VARCHAR2(1) default ' ' not null,
	CTT_PSN_NO NUMBER(2),
	SHARE_FEE_TYP VARCHAR2(1) default ' ' not null,
	EFF_TM VARCHAR2(6) default ' ' not null,
	EXP_TM VARCHAR2(6) default ' ' not null,
	STL_CTL VARCHAR2(1) default ' ' not null,
	RFD_MOD VARCHAR2(1) default ' ' not null,
	RFD_FEE_PRC_MOD VARCHAR2(1) default '1' not null,
	FEE_AC_TYP VARCHAR2(3) default ' ' not null,
	RATE_TYP VARCHAR2(2) not null,
	MERC_TYP VARCHAR2(2) default '',
	constraint URMTMFEE_PK
		primary key (MERC_ID, CAP_TYP, TX_MOD, FEE_TYP, EFF_DT, EFF_TM, RATE_TYP)
)
/

create table TITRTRGRP
(
	TITLE_ID VARCHAR2(48) default ' ' not null,
	RTR_GRP VARCHAR2(20) default ' ' not null
)
/

create unique index UNI_IDX_TITRTRGR1
	on TITRTRGRP (TITLE_ID)
/

create table SUMLMTRLR
(
	ID VARCHAR2(48) not null
		constraint PK_SUMLMTRLR
			primary key,
	DAY_AMT NUMBER(13,2) default '0',
	MTH_AMT NUMBER(13,2) default '0',
	YAR_AMT NUMBER(13,2) default '0',
	DAY_CNT VARCHAR2(40) default '0',
	MTH_CNT VARCHAR2(40) default '0',
	YAR_CNT VARCHAR2(40) default '0',
	TM_SMP VARCHAR2(26) default SYSDATE not null
)
/

create table CIMHLDTBL
(
  year   CHAR(4) not null,
  arecod CHAR(3) not null,
  hldflg VARCHAR2(1116) not null,
  constraint CIMHLDTBL_PK
        primary key (ARECOD, YEAR)
)
/