Product

테이블 (3)

카테고리

  • Key (category_id) — int — 기본 키 — NOT NULL
  • Field (category_name) — varchar

판매

  • Key (order_id) — int — 기본 키 — NOT NULL
  • Key (item_id) — int — 외래 키 → 품목.Key — NOT NULL
  • Field (user_name) — varchar
  • Field (order_date) — varchar
  • Field (total_price) — int
  • Field (order_count) — int

품목

  • Key (item_id) — int — 기본 키 — NOT NULL
  • Key (category_id) — int — 외래 키 → 카테고리.Key — NOT NULL
  • Field (item_name) — varchar
  • Field (item_price) — int
  • Field (item_life) — varchar
  • Field (item_on_event) — tinyint
  • Field (item_on_sale) — tinyint