MrTech/ctg-app-cap
5
0
Fork 0
Code Releases Activity
Files
dev
ctg-app-cap/cap/sql/cre_cmm.sql
T
Alawn 94306e3db2 报表增加文件url字段
2021-07-15 14:40:50 +08:00

1391 lines
39 KiB
SQL
Raw Permalink Blame History

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)
)
/
View Git Blame Copy Permalink