무인식당

테이블 (4)

Menu (menu)

  • Menu_id (menu_id) — int — 기본 키 — NOT NULL
  • Name (name) — char
  • Description (description) — char
  • Price (price) — int
  • Is_available (is_available) — boolean
  • Created_at (created_at) — date

OrderDetail (orderdetail)

  • Order_detail_id (order_detail_id) — int — 기본 키 — NOT NULL
  • Order_id (oder_id) — int — 외래 키 → Orders.Order_id — NOT NULL
  • Menu_id (menu_id) — int — 외래 키 → Menu.Menu_id — NOT NULL
  • Table_id (table_id) — int — 외래 키 → Orders.Table_id — NOT NULL
  • Cook_status (cook_status) — char

Orders (orders)

  • Order_id (oder_id) — int — 기본 키 — NOT NULL
  • Table_id (table_id) — int — 외래 키 → RestaurantTable.Table_id — NOT NULL
  • Total_price (total_price) — int
  • Order_status (order_status) — char
  • Created_at (created_at) — date
  • Completed_at (completed_at) — date

RestaurantTable (restauranttable)

  • Table_id (table_id) — int — 기본 키 — NOT NULL
  • Table_num (table_num) — int
  • Max_capacity (max_capacity) — int
  • Is_occupied (is_occupied) — boolean
  • Created_at (created_at) — date