MOS
Tables (11)
ASP_COUPON_INFO (ASP 쿠폰 정보)
- Key (GROUP_NUM) — VARCHAR(50) — Primary key — NOT NULL
- Field (EVENT_NUM) — VARCHAR(50)
- Field (ORDER_NO) — VARCHAR(50)
- Field (COMPANY_CD) — INT
- Field (COUPON_PIN) — VARCHAR(20)
- Field (SETAMT) — VARCHAR(10)
- Field (COUPON_EXPDATE) — VARCHAR(8)
- Field (COUPON_EXCDATE) — VARCHAR(8)
- Field (COUPON_EXCTIME) — VARCHAR(8)
- Field (STATUS_CD) — VARCHAR(4)
- Field (COUPON_TYPE) — VARCHAR(20)
- Field (PROD_SEQNO) — INT
- Field (PROD_CD) — VARCHAR(20)
- Field (CI_CD) — INT
- Field (EXPDAY) — VARCHAR(4)
- Field (DIVIDE) — VARCHAR(10)
- Field (TAKERTEL) — VARCHAR(50)
- Field (SENDERTEL) — VARCHAR(50)
- Field (MESSAGE_TYPE) — VARCHAR(1)
- Field (MSG_TITLE) — VARCHAR(50)
- Field (MSG_BODY) — VARCHAR(2000)
- Field (SEND_STATUS) — CHAR
- Field (BRANCH_CD) — VARCHAR(50)
- Field (BRANCH_NAME) — VARCHAR(50)
- Field (RESERVE_YMD) — VARCHAR(12)
- Field (COUPON_UPDATE_DT) — DATETIME
- Field (COUPON_ISSUE_DT) — TIMESTAMP
- Field (ISSUE_REQ_CNT) — INT
- Field (LNK_URL) — VARCHAR(500)
- Field (LNK_SHT_URL) — VARCHAR(100)
- Field (BALANCE) — VARCHAR(10)
- Field (AUTH_NO) — VARCHAR(20)
- Field (PROD_DVN) — VARCHAR(3)
- Field (PROD_GBN) — VARCHAR(3)
- Field (ETC1) — VARCHAR(45)
- Field (ETC2) — VARCHAR(45)
- Field (CST_INFO_DEL) — VARCHAR(1)
- Field (CST_INFO_DEL_DT) — VARCHAR(14)
CIS_B2C_PROD_INFO (B2C 상품 코드 정보)
- Key (MPROD_CD) — VARCHAR(20) — Primary key — NOT NULL
- Field (POST_CD) — VARCHAR(30)
- Field (GROUP_CD) — INT
- Field (COUPON_TYPE) — VARCHAR(20)
- Field (PROD_CD) — VARCHAR(20)
- Field (PROD_NAME) — VARCHAR(50)
- Field (PROD_NAME2) — VARCHAR(20)
- Field (SETAMT) — varchar(10)
- Field (EXPDATE) — VARCHAR(4)
- Field (EXC_POINT) — VARCHAR(20)
- Field (REG_DT) — TIMESTAMP
- Field (REG_USER_ID) — VARCHAR(30)
- Field (MOD_DT) — TIMESTAMP
- Field (MOD_USER_ID) — VARCHAR(30)
- Field (USE_YN) — VARCHAR(1)
- Field (SAIL_RATO_IDX) — VARCHAR(10)
- Field (MSG_TYPE) — VARCHAR(1)
- Field (PROD_DVN) — VARCHAR(2)
- Field (PROD_GBN) — VARCHAR(2)
- Field (ETC1) — VARCHAR(45)
- Field (ETC2) — VARCHAR(45)
- Field (ETC3) — VARCHAR(45)
- Field (ETC4) — VARCHAR(45)
- Field (ETC5) — VARCHAR(45)
- Field (PRE_FIX) — VARCHAR(20)
- Field (DESCRIPTION) — VARCHAR(2000)
- Field (COMB_PAYMENT_YN) — VARCHAR(1)
- Field (COMB_ISSUE_TYPE) — VARCHAR(5)
- Field (CUST_TEL_TRANS_YN) — CHAR
- Field (LOC_YN) — VARCHAR(1)
CIS_CARD_COMP (카드사 정보)
- Key (comp_cd) — int — Primary key — NOT NULL
- Field (comp_nm) — varchar(30)
- Field (comp_skey) — varchar(30)
- Field (comp_skey_enc) — varchar(50)
- Field (comp_cno) — varchar(20)
- Field (comp_use_yn) — varchar(2)
- Field (comp_exp_date) — int
- Field (comp_enc_type) — varchar(20)
- Field (reg_id) — varchar(20)
- Field (comp_reg_dt) — datetime
CIS_CARD_COMP_COUPON_CATEGORY (카드사 교환권)
- Key (seq) — int — Primary key — NOT NULL
- Field (coupon_no) — varchar(20)
- Field (category_amt) — int
- Field (ea) — int
CIS_CARD_COMP_COUPON_INFO (카드사 쿠폰)
- Key (seq) — int — Primary key — NOT NULL
- Field (comp_ord_no) — varchar(30)
- Field (cst_mngt_no) — varchar(11)
- Field (coupon_no) — varchar(11)
- Field (coupon_amt) — int
- Field (coupon_exp_date) — int
- Field (comp_cd) — varchar(30)
- Field (comp_nm) — varchar(20)
- Field (jumin_no) — varchar(30)
- Field (user_nm) — varchar(100)
- Field (phone_no) — varchar(30)
- Field (hp) — varhcar(20)
- Field (publish_date) — datetime
- Field (store_cd) — varchar(20)
- Field (store_nm) — varchar(30)
- Field (lms_message) — varchar(2000)
- Field (reg_date) — datetime
- Field (resend_date) — datetime
- Field (CST_INFO_DEL) — varchar(1)
- Field (CST_INFO_DEL_DT) — varchar(14)
CIS_COUPON_PROD_INFO (연동 상품 코드 정보)
- Key (MPROD_CD) — VARCHAR(20) — Primary key — NOT NULL
- Field (POST_CD) — VARCHAR( 30)
- Field (GROUP_CD) — INT
- Field (COUPON_TYPE) — VARCHAR(20)
- Field (PROD_CD) — VARCHAR(20)
- Field (PROD_NAME) — VARCHAR(50)
- Field (PROD_NAME2) — VARCHAR(20)
- Field (SETAMT) — VARCHAR(10)
- Field (EXPDATE) — VARCHAR(4)
- Field (EXC_POINT) — VARCHAR(20)
- Field (REG_DT) — TIMESTAMP
- Field (REG_USER_ID) — VARCHAR(30)
- Field (MOD_DT) — TIMESTAMP
- Field (MOD_USER_ID) — VARCHAR(30)
- Field (USE_YN) — VARCHAR(1)
- Field (SAIL_RATO_IDX) — VARCHAR(10)
- Field (MSG_TYPE) — VARCHAR(1)
- Field (PROD_DVN) — VARCHAR(2)
- Field (PROD_GBN) — VARCHAR(2)
- Field (ETC1) — VARCHAR(45)
- Field (ETC2) — VARCHAR(45)
- Field (ETC3) — VARCHAR(45)
- Field (ETC4) — VARCHAR(45)
- Field (ETC5) — VARCHAR(45)
- Field (PRE_FIX) — VARCHAR(20)
- Field (DESCRIPTION) — VARCHAR(2000)
- Field (COMB_PAYMENT_YN) — VARCHAR(1)
- Field (COMB_ISSUE_TYPE) — VARCHAR(5)
- Field (CUST_TEL_TRANS_YN) — CHAR
- Field (LOC_YN) — VARCHAR(1)
CIS_ELECTRO_COUPON_INFO (일렉트로 쿠폰 정보 테이블)
- Key (GROUP_NUM) — VARCHAR(50) — Primary key — NOT NULL
- Field (ORDER_NO) — VARCHAR(50)
- Field (EVENT_NUM) — VARCHAR(20)
- Field (POS_NO) — VARCHAR(10)
- Field (TR_NO) — VARCHAR(20)
- Field (TR_AMT) — BIGINT
- Field (TR_DD) — VARCHAR(8)
- Field (COMPANY_CD) — VARCHAR(10)
- Field (SHOP_CD) — VARCHAR(10)
- Field (MANAGER_CD) — VARCHAR(20)
- Field (CNCL_YN) — VARCHAR(1)
- Field (CNCL_DTTM) — VARCHAR(14)
- Field (COUPON_PIN) — VARCHAR(50)
- Field (SETAMT) — VARCHAR(10)
- Field (COUPON_EXPDATE) — VARCHAR(8)
- Field (STATUS_CD) — VARCHAR(4)
- Field (COUPON_TYPE) — VARCHAR(20)
- Field (PROD_CD) — VARCHAR(20)
- Field (CI_CD) — INT
- Field (EXPDAY) — VARCHAR(4)
- Field (DIVIDE) — VARCHAR(10)
- Field (TAKERTEL) — VARCHAR(50)
- Field (SENDERTEL) — VARCHAR(12)
- Field (MESSAGE_TYPE) — VARCHAR(1)
- Field (MSG_TITLE) — VARCHAR(50)
- Field (MSG_BODY) — VARCHAR(2000)
- Field (ISSUE_REQ_CNT) — INT
- Field (COUPON_ISSUE_DT) — TIMESTAMP
- Field (SEND_STATUS) — VARCHAR(1)
- Field (SEND_CNT) — INT
- Field (COUPON_SEND_DT) — DATETIME
- Field (BRANCH_CD) — VARCHAR(50)
- Field (BRANCH_NAME) — VARCHAR(50)
- Field (COUPON_EXCDATE) — VARCHAR(8)
- Field (COUPON_EXCTIME) — VARCHAR(8)
- Field (COUPON_UPDATE_DT) — DATETIME
- Field (LNK_URL) — VARCHAR(500)
- Field (LNK_SHT_URL) — VARCHAR(100)
- Field (BALANCE) — VARCHAR(10)
- Field (AUTH_NO) — VARCHAR(20)
- Field (PROD_GBN) — VARCHAR(3)
- Field (PROD_DVN) — VARCHAR(3)
- Field (APPL_NO) — INT
- Field (DEL_YN) — VARCHAR(3)
- Field (CPN_DUSE_DTTM) — TIMESTAMP
- Field (CPN_DUSE_RESN) — TIMESATMP
- Field (CST_INFO_DEL) — VARCHAR(1)
- Field (CST_INFO_DEL_DT) — VARCHAR(14)
CIS_EMART_STORE_INFO (전국 이마트 점포 정보 테이블)
- Key (store_cd) — VARCHAR(5) — Primary key — NOT NULL
- Field (store_nm) — varchar(20)
- Field (uplus_enc_cd) — varchar(20)
- Field (wincube_enc_cd) — varchar(20)
- Field (samsung_enc_cd) — varchar(20)
- Field (samsung_cd) — varchar(20)
- Field (mocah_direct_enc_cd) — varchar(20)
CIS_OFFLINE_COUPON_INFO (모바일 쿠폰 정보 테이블)
- Key (GROUP_NUIM) — varchar(50) — Primary key — NOT NULL
- Field (EVENT_NUM) — varchar(20)
- Field (ISSUEMG_CD) — INT
- Field (ORDER_NO) — VARCHAR(50)
- Field (COMPANY_CD) — int
- Field (MANAGER_CD) — INT
- Field (COUPON_PIN) — varchar(50)
- Field (SETAMT) — varchar(10)
- Field (COUPON_EXPDATE) — varchar(8)
- Field (COUPON_EXCDATE) — VARCHAR(8)
- Field (COUPON_EXCTIME) — VARCHAR(8)
- Field (STATUS_CD) — VARCHAR(4)
- Field (PIN_TYPE) — VARCHAR(1)
- Field (COUPON_TYPE) — VARCHAR(20)
- Field (PROD_CD) — VARCHAR(20)
- Field (CI_CD) — INT
- Field (EXPDAY) — VARCHAR(4)
- Field (DIVIDE) — VARCHAR(10)
- Field (TEAKERTEL) — VARCHAR(50)
- Field (SENDERTEL) — VARCHAR(12)
- Field (MESSAGE_TYPE) — VARCHAR(1)
- Field. (MSG_TITLE) — VARCHAR(1)
- Field (MSG_BODY) — VARCHAR(2000)
- Field (SEND_STATUS) — CHAR
- Field (BRANCH_CD) — VARCHAR(50)
- Field (BRANCH_NAME) — VARCHAR(50)
- Field (RESERVE_YMD) — VARCHAR(12)
- Field (COUPON_UPDATE_DT) — DATETIME
- Field (COUPON_SEND_DT) — DATETIME
- Field (COUPON_ISSUE_DT) — TIMESTAMP
- Field (SEND_CNT) — INT
- Field (ISSUE_REQ_CNT) — INT
- Field (LNK_URL) — VARCHAR(500)
- Field (LNK_SHT_URL) — VARCHAR(100)
- Field (BALANCE) — VARCHAR(10)
- Field (AUTH_NO) — VARCHAR(20)
- Field (PROD_DVN) — VARCHAR(3)
- Field (ETC1) — VARCHAR(45)
- Field (ETC2) — VARCHAR(45)
- Field (CANCEL_DTTM) — TIMESTAMP
- Field (PROD_GBN) — VARCHAR(3)
- Field (CST_AGREE) — VARCHAR(1)
- Field (CST_AGREE_DTTM) — TIMESTAMP
- Field (OPT1) — VARCHAR(100)
- Field (CST_INFO_DEL) — VARCHAR(1)
- Field (CST_INFO_DEL_DT) — VARCHAR(14)
- Field (COMB_PAYMENT_DT) — VARCHAR(1)
- Field (COMB_ISSUE_TYPE) — VARCHAR(5)
- Field (PARENT_GROUP_NUM) — VARCHAR(60)
CIS_ONLINE_COUPON_INFO (실시간 연동 쿠폰 정보)
- Key (SEQ) — INT — Primary key — NOT NULL
- Field (INTERLOCK_CD) — VARCHAR(10)
- Field (COMPANY_CD) — INT
- Field (CKEY) — VARCHAR(50)
- Field (SERIAL_NUM) — VARCHAR(55)
- Field (ORDER_NO) — VARCHAR(50)
- Field (COUPON_PIN) — VARCHAR(50)
- Field (IDNO) — VARCHAR(20)
- Field (EVENTPNUM) — INT
- Field (SETAMT) — varchar(10)
- Field (COUPON_EXPDATE) — VARCHAR(8)
- Field (COUPON_EXCDATE) — VARCHAR(8)
- Field (COUPON_EXCTIME) — VARCHAR(8)
- Field (STATUS_CD) — VARCHAR(4)
- Field (PROD_CD) — VARCHAR(20)
- Field (CI_CD) — INT
- Field (EXPDAY) — VARCHAR(4)
- Field (TAKERTEL) — VARCHAR(50)
- Field (TAKERNAME) — VARCHAR(50)
- Field (SENDERTEL) — VARHCAR(60)
- Field (MESSAGE_TYPE) — VARCHAR(1)
- Field (MSG_TITLE) — VARCHAR(30)
- Field (MSG_BODY) — VARCHAR(2000)
- Field (SEND_STATUS) — CHAR
- Field (BRANCH_CD) — VARCHAR(50)
- Field (BRANCH_NAME) — VARCHAR(50)
- Field (COUPON_UPDATE_DT) — DATETIME
- Field (COUPON_SEND_DT) — DATETIME
- Field (COUPON_ISSUE_DT) — TIMESTAMP
- Field (LNK_URL) — VARCHAR(500)
- Field (LNK_SHT_URL) — VARCHAR(500)
- Field (ORD_NO) — VARCHAR(50)
- Field (ORD_DT) — VARCHAR(16)
- Field (BALANCE) — VARCHAR(10)
- Field (COUPON_TYPE) — VARCHAR(20)
- Field (DC_RTO) — VARCHAR(10)
- Field (EXCA_FRML) — VARCHAR(1)
- Field (PROD_DVN) — VARCHAR(3)
- Field (ORGN_CO_CD) — INT
- Field (ETC1) — VARCHAR(45)
- Field (ETC2) — VARCHAR(45)
- Field (CANCEL_DTTM) — TIMESTAMP
- Field (PROD_GBN) — VARCHAR(3)
- Field (DVN) — VARCHAR(3)
- Field (CST_INFO_DEL) — VARCHAR(1)
- Field (CST_INFO_DEL_DT) — VARCHAR(14)
- Field (ISSUE_REG_CNT) — INT
- Field (COUPON_FIRST_EXPDATE) — VARCHAR(8)
- Field (DIVIDE) — VARCHAR(10)
TB_OUT_COMP_CPN_CHNG_SEND (외부 업체 쿠폰 상태 전송)
- Key (SEQNO) — INT — Primary key — NOT NULL
- Field (GRP_NO) — VARCHAR(60)
- Field (CPN_NO) — VARCHAR(50)
- Field (CPN_STAT) — VARCHAR(4)
- Field (BAL) — VARCHAR(10)
- Field (EXCH_PLC_CD) — VARCHAR(10)
- Field (EXCH_PLC_NM) — VARCHAR(50)
- Field (REG_DTTM) — TIMESTAMP
- Field (SEND_YN) — VARCHAR(1)
- Field (SEND_DTTN) — VARCHAR(16)
- Field (SEND_DT) — VARCHAR(1)
- Field (ERR_CNTN) — VARCHAR(2000)
- Field (SEND_RT_CD) — VARCHAR(20)
- Field (MOCAH_DEAL_RT_CD) — VARCHAR(4)
- Field (SEND_TRY_CNT) — INT