62 lines
3.2 KiB
SQL
62 lines
3.2 KiB
SQL
DROP TABLE PUBBSPCTL;
|
|
CREATE TABLE PUBBSPCTL (
|
|
INST_ID VARCHAR(20) NOT NULL,
|
|
BAT_NO VARCHAR(20) NOT NULL,
|
|
FIL_NM VARCHAR(60) DEFAULT ' ' NOT NULL,
|
|
M_BAT_NO VARCHAR(20) NOT NULL,
|
|
IS_PRIMARY VARCHAR(1) DEFAULT 'Y' NOT NULL,
|
|
EXT_KEY VARCHAR(60) NOT NULL,
|
|
EXT_BAT_NO VARCHAR(60) DEFAULT ' ' NOT NULL,
|
|
PHASE VARCHAR(1) DEFAULT '0' NOT NULL,
|
|
STATUS VARCHAR(1) DEFAULT 'U' NOT NULL,
|
|
PRE_STS VARCHAR(1) DEFAULT 'U' NOT NULL,
|
|
PROC_STS VARCHAR(1) DEFAULT 'U' NOT NULL,
|
|
AFTER_STS VARCHAR(1) DEFAULT 'U' NOT NULL,
|
|
SRV_ID VARCHAR(2) DEFAULT ' ' NOT NULL,
|
|
SND_CNT NUMBER DEFAULT 0 NOT NULL,
|
|
MAX_CNT NUMBER DEFAULT 1 NOT NULL,
|
|
TX_CD VARCHAR(30) DEFAULT ' ' NOT NULL,
|
|
BUS_TYP VARCHAR(5) DEFAULT ' ' NOT NULL,
|
|
AC_DT VARCHAR(8) NOT NULL,
|
|
DUE_DT_CTRL VARCHAR(1) DEFAULT '0' NOT NULL,
|
|
DUE_DT VARCHAR(8) DEFAULT '19000101' NOT NULL,
|
|
DUE_BGN_TM VARCHAR(6) DEFAULT '000000' NOT NULL,
|
|
DUE_END_TM VARCHAR(6) DEFAULT '235959' NOT NULL,
|
|
BAT_MOD VARCHAR(1) DEFAULT '1' NOT NULL,
|
|
SUM_FLG VARCHAR(1) DEFAULT 'N' NOT NULL,
|
|
START_TM VARCHAR(19) DEFAULT ' ' NOT NULL,
|
|
CONFIRM_TM VARCHAR(19) DEFAULT ' ' NOT NULL,
|
|
PRE_STR_TM VARCHAR(19) DEFAULT ' ' NOT NULL,
|
|
PRE_FIN_TM VARCHAR(19) DEFAULT ' ' NOT NULL,
|
|
PROC_STR_TM VARCHAR(19) DEFAULT ' ' NOT NULL,
|
|
PROC_FIN_TM VARCHAR(19) DEFAULT ' ' NOT NULL,
|
|
AFTER_STR_TM VARCHAR(19) DEFAULT ' ' NOT NULL,
|
|
AFTER_FIN_TM VARCHAR(19) DEFAULT ' ' NOT NULL,
|
|
FINISH_TM VARCHAR(19) DEFAULT ' ' NOT NULL,
|
|
CCY_CD VARCHAR(3) DEFAULT ' ' NOT NULL,
|
|
TOTAL_CNT NUMBER DEFAULT 0 NOT NULL,
|
|
TOTAL_AMT NUMBER DEFAULT 0 NOT NULL,
|
|
SUCC_CNT NUMBER DEFAULT 0 NOT NULL,
|
|
SUCC_AMT NUMBER DEFAULT 0 NOT NULL,
|
|
FAIL_CNT NUMBER DEFAULT 0 NOT NULL,
|
|
FAIL_AMT NUMBER DEFAULT 0 NOT NULL,
|
|
CALL_SRV VARCHAR(8) NOT NULL,
|
|
CALL_TX_CD VARCHAR(20) NOT NULL,
|
|
DO_PRE_PROC VARCHAR(1) DEFAULT 'N' NOT NULL,
|
|
PRE_SRV VARCHAR(8) DEFAULT ' ' NOT NULL,
|
|
PRE_TX_CD VARCHAR(20) DEFAULT ' ' NOT NULL,
|
|
DO_AFTER_PROC VARCHAR(1) DEFAULT 'N' NOT NULL,
|
|
AFTER_SRV VARCHAR(8) DEFAULT ' ' NOT NULL,
|
|
AFTER_TX_CD VARCHAR(20) DEFAULT ' ' NOT NULL,
|
|
DTL_TBL VARCHAR(20) NOT NULL,
|
|
UPD_FLG VARCHAR(1) DEFAULT 'N' NOT NULL,
|
|
UPD_FLDS VARCHAR(512) DEFAULT ' ' NOT NULL,
|
|
APPLY_JRN_FLG VARCHAR(1) DEFAULT 'N' NOT NULL,
|
|
REMARK VARCHAR(100) DEFAULT ' ' NOT NULL,
|
|
TM_SMP VARCHAR(14) DEFAULT ' ' NOT NULL,
|
|
PRIMARY KEY (BAT_NO)
|
|
);
|
|
CREATE UNIQUE INDEX UI1_PUBBSPCTL ON PUBBSPCTL (EXT_KEY);
|
|
|
|
|