TABLES.md

CREATE TABLE EX_CORPCARD_ASK ( COM_CD VARCHAR(4) NOT NULL ,SEND_YMD VARCHAR(8) NOT NULL ,SEND_DIV VARCHAR(2) NOT NULL ,APV_DD VARCHAR(8) NOT NULL ,CARD_NO VARCHAR(50) NOT NULL ,APV_NO VARCHAR(10) NOT NULL ,IFKEY VARCHAR(13) NOT NULL ,APV_AMT DECIMAL(17, 3) ,APV_TM VARCHAR(6) ,TAX_AMT DECIMAL(13, 3) ,APV_SUM_AMT DECIMAL(17, 3) ,FC_CUST_NO VARCHAR(20) ,FC_NM VARCHAR(100) ,FC_ADDR1 VARCHAR(100) ,FC_ADDR2 VARCHAR(500) ,MCC_CD VARCHAR(4) ,MCC_NM VARCHAR(20) ,K_WORK_NM VARCHAR(100) ,K_CODE_NM VARCHAR(20) ,APP_USER_NO VARCHAR(50) ,IN_YMD VARCHAR(8) ,ACC_CD VARCHAR(10) ,CST_APPV_METH VARCHAR(2) ,ELEC_APPV_STAT_CD VARCHAR(20) ,ELEC_APPV_DOC_NO VARCHAR(32) ,ECAL_STAT_CD VARCHAR(2) ,ELEC_APPV_YMD VARCHAR(8) ,SLIP_HANDL_YN VARCHAR(1) ,SLIP_NO VARCHAR(10) ,RGSPE_ID VARCHAR(20) ,RGS_DH DATETIME ,SLIP_YY VARCHAR(4) ,AUTO_APPV_YN VARCHAR(1) );

ALTER TABLE EX_CORPCARD_ASK ADD CONSTRAINT PK_EX_CORPCARD_ASK PRIMARY KEY (COM_CD, SEND_YMD, SEND_DIV, APV_DD, CARD_NO, APV_NO, IFKEY);

CREATE TABLE EX_EXPN_ETC ( ECAL_NO VARCHAR(16) NOT NULL ,SEQ INT(4) NOT NULL ,OCCR_ACC_CD VARCHAR(10) ,REV_ACC_CD VARCHAR(10) ,BSS_YMD VARCHAR(8) ,END_YMD VARCHAR(8) ,OPEN_YMD VARCHAR(8) ,VAT_CD VARCHAR(5) ,CST_APPV_METH VARCHAR(2) ,OCCR_YMD VARCHAR(8) ,ECAL_AMT INT(20) ,SUPPLY_AMT INT(20) ,TAX_AMT INT(20) ,DTLS VARCHAR(100) ,CUST_NM VARCHAR(100) ,CUST_NO VARCHAR(11) ,CUST_CD VARCHAR(10) ,CHRPE_NM VARCHAR(50) ,PRAMT_SLIP_NO VARCHAR(10) ,STTL_AMT INT(20) ,TOT_RTN_AMT INT(20) ,ELEC_APPV_STAT_CD VARCHAR(20) ,ELEC_APPV_DOC_NO VARCHAR(32) ,ECAL_STAT_CD VARCHAR(2) ,ELEC_APPV_YMD VARCHAR(8) ,SLIP_HANDL_YN VARCHAR(1) ,SLIP_NO VARCHAR(10) ,RGSPE_ID VARCHAR(20) ,RGS_DH DATETIME ,UTIL_YN VARCHAR(1) ,KNDNR_NM VARCHAR(100) ,KUNDE_PA VARCHAR(10) ,COM_CD VARCHAR(4) ,YY VARCHAR(4) );

ALTER TABLE EX_EXPN_ETC ADD CONSTRAINT PK_EX_EXPN_ETC PRIMARY KEY (ECAL_NO, SEQ);

ALTER TABLE EX_EXPN_ETC ADD LABEL_CATE_CD VARCHAR(5);

ALTER TABLE EX_CORPCARD_ASK ADD CST_CENTR_CD VARCHAR(10);

ALTER TABLE EX_EXPN_ETC ADD CST_CENTR_CD VARCHAR(10);

ALTER TABLE EX_CORPCARD_ASK ADD IF_DH DATETIME;

ALTER TABLE EX_EXPN_ETC ADD IF_DH DATETIME;

CREATE TABLE EX_BS_CST_CNTR ( COM_CD VARCHAR(4) NOT NULL ,CST_CNTR_CD VARCHAR(10) NOT NULL ,CST_CNTR_NM VARCHAR(50) );

ALTER TABLE EX_BS_CST_CNTR ADD CONSTRAINT PK_EX_BS_CST_CNTR PRIMARY KEY (COM_CD, CST_CNTR_CD);

CREATE TABLE EX_BUDGET ( COM_CD VARCHAR(4) NOT NULL ,YY VARCHAR(4) NOT NULL ,ACT_BUD DECIMAL(17, 3) ,USE_BUD DECIMAL(17, 3) ,REM_BUD DECIMAL(17, 3) ,GOAL DECIMAL(17, 3) );

ALTER TABLE EX_BUDGET ADD CONSTRAINT PK_EX_BUDGET PRIMARY KEY (COM_CD, YY);

ALTER TABLE EX_CORPCARD_ASK ADD DISP_CATE_CD VARCHAR(50);

CREATE INDEX idx_01_common_code ON common_code(group_code, detail_code);

CREATE TABLE EX_EXPN_ETC_WORDS ( ECAL_NO VARCHAR(16) NOT NULL ,SEQ INT(4) NOT NULL ,W_SEQ INT(4) NOT NULL ,TEXT VARCHAR(100) ,RGS_DH DATETIME );

ALTER TABLE EX_EXPN_ETC_WORDS ADD CONSTRAINT PK_EX_EXPN_ETC_WORDS PRIMARY KEY (ECAL_NO, SEQ, W_SEQ);