편의점

테이블 (4)

Order (order)

  • Order Number (order_number) — INT(10) — 기본 키 — NOT NULL
  • Product Code (product_code) — INT(10) — 외래 키 → Products.Product Code — NOT NULL
  • SupplyCode (supply_code) — INT(10) — 외래 키 → Supply.SupplyCode — NOT NULL
  • Count (order_count) — INT(10)

Products (products)

  • Product Code (product_code) — INT(10) — 기본 키 — NOT NULL
  • Product Name (product_name) — VARCHAR2(100)
  • Product Group (product_group) — VARCHAR2(100)
  • Sale Place (sale_place) — VARCHAR2(100)
  • Expiration Date (ex_date) — DATE
  • Stock — INT(10)

Stores (stores)

  • Store Code (store code) — INT(10) — 기본 키 — NOT NULL
  • Product Code (product_code) — INT(10) — 외래 키 → Products.Product Code — NOT NULL
  • Name (name) — VARCHAR2(100)
  • Region (region) — VARCHAR2(100)
  • Manager (manager) — VARCHAR2(100)
  • Price (price) — INT(10)
  • Open Date (open_date) — DATE

Supply (supply)

  • SupplyCode (supply_code) — INT(10) — 기본 키 — NOT NULL
  • name — VARCHAR2(100)
  • manager — VARCHAR2(100)