REAL_CJ
Tables (8)
INM_BENF_GOODS (CopyOfUntitled3)
- PROMOTION_CD — VARCHAR2(5) — Primary key — NOT NULL
- PROMOTION_CONDITION_CD — VARCHAR(2) — Primary key — NOT NULL
- GOODS_CD — VARCHAR(10) — Primary key — NOT NULL
- CROSS_GROUP — VARCHAR2(2) — Primary key — NOT NULL
- CREATE_DTIME — VARCHAR2(14)
- CREATE_ID — VARCHAR2(20)
- UPDATE_DTIME — VARCHAR2(14)
- UPDATE_ID — VARCHAR2(20)
INM_PROMOTIONS (Untitled7)
- PROMOTION_CD — VARCHAR2(5) — Primary key — NOT NULL
- PROMOTION_POLICY_CD — VARCHAR2()
- NAME_LOCAL — VARCHAR2(45)
- NAME_KR — VARCHAR2(45)
- CORP_CD — VARCHAR2(2)
- BRAND_CD — VARCHAR2(3)
- CREATE_DTIME — VARCHAR2(14)
- CREATE_ID — VARCHAR2(20)
- UPDATE_DTIME — VARCHAR2(14)
- UPDATE_ID — VARCHAR2(20)
- USE_YN — VARCHAR2(1)
INM_PROMOTION_POLICY (REASON)
- PROMOTION_POLICY_CD — VARCHAR2(5) — Primary key — NOT NULL
- NAME_POLICY_LOCAL — VARCHAR2(45)
- NAME_POLICY_KR — VARCHAR2(45)
- MON_YN — VARCHAR2(1)
- TUS_YN — VARCHAR2(1)
- WEN_YN — VARCHAR2(1)
- THU_YN — VARCHAR2(1)
- FRI_YN — VARCHAR2(1)
- SAT_YN — VARCHAR2(1)
- SUN_YN — VARCHAR2(1)
- SPECIAL_DAY — VARCHAR2(2)
- SPECIAL_MONTH — VARCHAR2(2)
- SPECIAL_YEAR — VARCHAR2(4)
- ODD_DAY_YN — VARCHAR2(1)
- EVEN_DAY_YN — VARCHAR2(1)
- CREATE_DTIME — VARCHAR2(14)
- CREATE_ID — VARCHAR2(20)
- UPDATE_DTIME — VARCHAR2(14)
- UPDATE_ID — VARCHAR2(20)
- USE_YN — VARCHAR2(1)
INM_PROM_CONDITIONS (Untitled2)
- PROMOTION_CONDITION_CD — VARCHAR2(2) — Primary key — NOT NULL
- PROMOTION_CD — VARCHAR2(5) — Primary key — NOT NULL
- PROM_GP_CD — VARCHAR2(3)
- DUP_APPLY_YN — VARCHAR2(1)
- DUP_METHOD_TYPE — VARCHAR2(1)
- NDUP_METHOD_TYPE — VARCHAR2(1)
- COND_ITEM_NUM — VARCHAR2(3)
- BENF_ITEM_NUM — VARCHAR(3)
- DISCOUNT_RATE — NUMBER(2) — NOT NULL
- DISCOUNT_ITEM_NUBER — VARCHAR2(3)
- DISCOUNT_PRICE — NUMBER(22)
- SETTING_PRICE — NUMBER(22)
- MIN_PAY_PRICE — NUMBER(22)
- MAX_DISCOUNT_PRICE — NUMBER(22)
- COND_GOODS_TYPE — VARCHAR2(1) — A->ALL P
- BENF_GOODS_TYPE — VARCHAR2(1)
- EX_GOODS_TYPE — VARCHAR2(1)
- CROSS_COND_GOODS_TYPE — VARCHAR2(1) — Y=> 조건 물품들 중 교차 가능 N=> 조건 물품들 중 교차 불가능
- PAYMENT_METHOD — VARCHAR2(1) — ALL CARD=>카드 CASH=>현금
- CARD_CORP_CD — VARCHAR2(4)
- USE_YN — varchar2(1)
INM_PROM_COND_GOODS (Untitled)
- PROMOTION_CD — VARCHAR2(5) — Primary key — NOT NULL
- PROMOTION_CONDITION_CD — VARCHAR(2) — Primary key — NOT NULL
- GOODS_CD — VARCHAR(10) — Primary key — NOT NULL
- CROSS_GROUP — VARCHAR2(2) — 교차가 가능하면 같은 번호 아니면 번호 업업
- CREATE_DTIME — VARCHAR2(14)
- CREATE_ID — VARCHAR2(20)
- UPDATE_DTIME — VARCHAR2(14)
- UPDATE_ID — VARCHAR2(20)
INM_PROM_EX_GOODS (CopyOfUntitled)
- PROMOTION_CD — VARCHAR2(5) — Primary key — NOT NULL
- PROMOTION_CONDITION_CD — VARCHAR(2) — Primary key — NOT NULL
- GOODS_CD — VARCHAR(10) — Primary key — NOT NULL
- CREATE_DTIME — VARCHAR2(14)
- CREATE_ID — VARCHAR2(20)
- UPDATE_DTIME — VARCHAR2(14)
- UPDATE_ID — VARCHAR2(20)
INM_PROM_GP (Untitled5)
- PROM_GP_CD — VARCHAR2(3) — Primary key — NOT NULL
- PROMO_GP — VARCHAR2(2)
- NAME_LOCAL — VARCHAR2(20)
- NAME_KR — VARCHAR2(20)
- CREATE_DTIME — VARCHAR2(14)
- CREATE_ID — VARCHAR2(20)
- UPDATE_DTIME — VARCHAR2(14)
- UPDATE_ID — VARCHAR2(20)
- USE_YN — VARCHAR2(1)
INM_PROM_TERM (Untitled6)
- PROM_PERIOD_CD — VARCHAR2(10) — Primary key — NOT NULL
- PROMOTION_CD — VARCHAR2(5)
- START_DATE — VARCHAR2(8)
- END_DATE — VARCHAR2(8)
- START_TIME — VARCHAR2(6)
- END_TIME — VARCHAR2(6)
- CREATE_DTIME — VARCHAR2(14)
- CREATE_ID — VARCHAR2(20)
- UPDATE_DTIME — VARCHAR2(14)
- UPDATE_ID — VARCHAR2(20)
- USE_YN — VARCHAR2(1)