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