무인식당
테이블 (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