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)