76 lines
2.2 KiB
SQL
76 lines
2.2 KiB
SQL
create table PAYADM.CMMTEMRULE
|
|
(
|
|
RUL_NO CHAR(4) default '0001' not null,
|
|
RUL_LVL INTEGER 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(1) default '0' not null,
|
|
TM_SMP CHAR(26) default '' not null,
|
|
WEIGHT NUMBER(3) default 0
|
|
)
|
|
;
|
|
alter table PAYADM.CMMTEMRULE
|
|
add primary key (RUL_NO);
|
|
create index PAYADM.CMMTEMRULE_UN on PAYADM.CMMTEMRULE (TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP);
|
|
|
|
|
|
create table PAYADM.CMMTRTRULE
|
|
(
|
|
RUL_NO CHAR(4) default '0001' not null,
|
|
RUL_LVL INTEGER 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(1) default '0' not null,
|
|
TM_SMP CHAR(26) default '' not null,
|
|
WEIGHT NUMBER(3) default '0' not null
|
|
)
|
|
;
|
|
alter table PAYADM.CMMTRTRULE
|
|
add primary key (RUL_NO);
|
|
|
|
create table PAYADM.ATMFIT
|
|
(
|
|
FITTRK CHAR(1) not null,
|
|
FITOFS CHAR(2) not null,
|
|
FITCTT CHAR(20) not null,
|
|
FITLEN CHAR(2) not null,
|
|
CRDTRK CHAR(1) not null,
|
|
CRDOFS CHAR(2) not null,
|
|
CRDLEN CHAR(2) not null,
|
|
CRDFLG CHAR(2) not null,
|
|
CDCDOF CHAR(2) default ' ' not null,
|
|
VADTOF CHAR(2) default ' ' not null,
|
|
CRDNAM CHAR(40) not null,
|
|
INTMOD CHAR(1) default '0' not null,
|
|
BNKTYP CHAR(4) not null,
|
|
FITNO CHAR(4) default ' ' not null
|
|
)
|
|
;
|
|
alter table PAYADM.ATMFIT
|
|
add primary key (FITTRK, FITOFS, FITCTT);
|
|
create unique index PAYADM.NI1_ATMFIT on PAYADM.ATMFIT (FITNO);
|