상품

테이블 (3)

PRODUCT (상품)

  • PRODUCT_ID (상품ID) — 기본 키 — NOT NULL
  • SECTN_ID (Field)
  • USE_YN (Field2)
  • PRICE (Field3)
  • STOCK_QUANTITY (Field4)
  • TYPE (Field5)

TB_PRODUCT_DISCOUNT (Untitled)

  • DISCOUNT_PRODUCT_ID (Key) — 기본 키 — NOT NULL
  • START_DTTM (Field5)
  • END_DTTM (Field6)
  • USE_MINUTE (Field7)
  • EXPIRE_PERIOD (Field8)

TB_PRODUCT_PERIOD (Untitled2)

  • PRIOD_PRODUCT_ID (Key) — 기본 키 — NOT NULL
  • BEFORE_START_DTTM (Field5)
  • BEFORE_END_DTTM (Field7)
  • AFTER_START_DTTM (Field6)
  • AFTER_END_DTTM (Field8)