COUPON_SYSTEM
ZNVHSTLTMXPA
Tables (9)
COUPON
- CPN_CD — varchar(6) — Primary key — NOT NULL
- EVENT_CD — VARCHAR — Foreign key → EVENT.EVENT_CD — NOT NULL
- CPNNM_CD — numeric(5,0) — Foreign key → COUPON_NAME.CPNNM_CD — NOT NULL
- COUPON_NAME (CPN_NM 의 값) (CPN_NM)
- USE_MK — varchar(1) — NOT NULL
- FM_NO — varchar(50) — NOT NULL
- TO_NO — varchar(50) — NOT NULL
- ARRG_TP — varchar(1) — NOT NULL
- CPN_TP — varchar(1) — NOT NULL
- CPNCOST — numeric(18,0) — NOT NULL
- LIMIT_CST — varchar(1) — NOT NULL
- FM_DT — datetime
- TO_DT — datetime
- RGST_USERID — varchar(50)
- RGST_DT — datetime
- FM_NO_PRV — varchar(50) — NOT NULL
- TO_NO_PRV — varchar(50) — NOT NULL
- CPN_IMG — varchar(50)
- VALIDITY_DT_START — datetime
- VALIDITY_DT_END — datetime
- CPN_PER — int
COUPON_ASND
- CPNA_CD — int — Primary key — NOT NULL
- STR_CD (STR_CD2) — varchar(6) — Foreign key → dbo.STORE.STR_CD — NOT NULL
- ASND_MK — varchar(1) — NOT NULL
- ASND_NO — varchar(50) — NOT NULL
- CPN_NO — varchar(50) — NOT NULL
- RGST_USERID — varchar(50)
- RGST_DT — datetime
COUPON_MAIN_IMG
- IMG_NO — numeric(18,0) — Primary key — NOT NULL
- IMG_PATH — varchar(MAX) — NOT NULL
- IS_MAIN — varchar(1) — NOT NULL
- RGST_DT — datetime — NOT NULL
COUPON_MANAGE
- MANAGE_CD — numeric(18,0) — Primary key — NOT NULL
- MANAGE_NM — varchar(100) — NOT NULL
- TEL_NO — varchar(50) — NOT NULL
- USE_MK — varchar(1) — NOT NULL
- RGST_DT — datetime
- MODIFY_DT — datetime
- DELETE_MK — varchar(1) — NOT NULL
- DELETE_DT — datetime
COUPON_NAME
- CPNNM_CD — numeric(5,0) — Primary key — NOT NULL
- CPN_NM — varchar(50)
- CPN_TP — varchar(1)
- RGST_DT — datetime
- MODIFY_DY — datetime
EVENT
- EVENT_CD — VARCHAR — Primary key — NOT NULL
- MANAGE_CD (MANAGE_CD2) — numeric(18,0) — Foreign key → COUPON_MANAGE.MANAGE_CD — NOT NULL
- IMG_NO — numeric(18,0) — Foreign key → COUPON_MAIN_IMG.IMG_NO — NOT NULL
- EVENT_NM — VARCHAR
- FM_DT — DATETIME
- TO_DT — DATETIME
- RGST_DT — DATETIME
- MANAGE_CD — numeric(18,0)
- RGST_USERID — VARCHAR(50)
EVENT_IN_STORE
- EVTSTR_CD (Field) — Primary key
- STR_CD — varchar(6) — Foreign key → dbo.STORE.STR_CD — NOT NULL
- EVENT_CD — VARCHAR — Foreign key → EVENT.EVENT_CD — NOT NULL
- MANAGE_CD (MANAGE_CD2) — numeric(18,0) — Foreign key → EVENT.MANAGE_CD — NOT NULL
- RGST_DT — datetime
- MODIFY_DT — datetime
SALE_DTL
- SDTL_CD — int — Primary key — NOT NULL
- CPNA_CD — int — Foreign key → COUPON_ASND.CPNA_CD — NOT NULL
- STR_CD — varchar(6) — Foreign key → dbo.STORE.STR_CD — NOT NULL
- SALE_TP — varchar(1) — NOT NULL
- ITEM_CD — varchar(6) — NOT NULL
- ITEM_NM — varchar(50) — NOT NULL
- DCNT_CD — varchar(6) — NOT NULL
- DCNT_DT — datetime
- RGST_DT — datetime
- ITEM_BRD — varchar(6) — NOT NULL
dbo.STORE
- STR_CD — varchar(6) — Primary key — NOT NULL
- STR_NM — varchar(50)
- RGST_NO — varchar(50)
- FRC_CD — varchar(6) — NOT NULL
- BRD_CD — varchar(6) — NOT NULL
- SVR_CD — varchar(6)
- STRGCD_NM — varchar(1)
- TRANS_MK — varchar(1) — NOT NULL
- AUTOUP_MK — varchar(1) — NOT NULL
- MEMSP_TP — varchar(1) — NOT NULL
- STTL_MK — varchar(1)
- EXC_DT — varchar(10)
- EXC_USD — numeric(18,2)
- EXC_EUR — numeric(18,2)
- EXC_JPY — numeric(18,2)
- EXC_CNH — numeric(18,2)
- RCPT_CMMT — varchar(3000)
- RGST_USERID — varchar(8)
- RGST_DT — datetime
- MODIFY_USERID — varchar(8)
- MODIFY_DT — datetime
- PCLTRS_FRTRM — numeric(18,0) — NOT NULL
- MEMCXL_TP — varchar(1) — NOT NULL
- MEMPOS_TP — varchar(1) — NOT NULL
- RTTRANS_YN — varchar(1) — NOT NULL
- MONEYTP_FMT — varchar(10) — NOT NULL
- INEX_TP — varchar(2) — NOT NULL
- VAT_RT — numeric(18,2) — NOT NULL
- GEOLOCATION_ADDR — varchar(50) — NOT NULL
- ADDR_ETC — varchar(200) — NOT NULL
- CALC_CMMT — varchar(3000)
- ORD_CMMT — varchar(3000)
- MMBSP_LIMIT — numeric(18,0) — NOT NULL