기말과제 1

테이블 (10)

Untitled (Customer)

  • Key (customer_id) — varchar(10) — 기본 키 — NOT NULL
  • Field (name) — varchar(50)
  • Field (phone_number) — varchar(11)
  • Field (join_date) — date

Untitled (store)

  • Key (store_id) — varchar(10) — 기본 키 — NOT NULL
  • Field (store_name) — varchar(50)
  • Field (location) — varchar(100)
  • Field (open_date) — date

Untitled (staff)

  • Key (staff_id) — varchar(10) — 기본 키 — NOT NULL
  • Field (staff_name) — varchar(50)
  • Field (role) — varchar(30
  • Field (hire_date) — date
  • Key (store_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (category)

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

Untitled (menu)

  • Key (menu_id) — varchar(10) — 기본 키 — NOT NULL
  • Field (menu_name) — varchar(50)
  • Field (price) — int
  • Key (category_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (ingredient)

  • Key (ingredient_id) — varchar(10) — 기본 키 — NOT NULL
  • Field (ingredient_name) — varchar(50)
  • Field (unit) — varchar(20)
  • Field (unit_price) — int

Untitled (orders)

  • Key (order_id) — varchar(10) — 기본 키 — NOT NULL
  • Field (order_datetime) — datetime
  • Key (customer_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (staff_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (store_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (order_item)

  • Key (order_item_id) — varchar(10) — 기본 키 — NOT NULL
  • Field (quantity) — int
  • Key (order_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (menu_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (payment)

  • Key (payment_id) — varchar(10) — 기본 키 — NOT NULL
  • Field (payment_amount) — int
  • Field (payment_method) — varchar(20)
  • Field (payment_datetime) — datetime
  • Key (order_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (menu_ingredient)

  • Key (menu_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ingredient_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (quantity_used) — int