ERD
Tables (4)
menu
- menu_id — INT — Primary key
- restaurant_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- price — INT — NOT NULL
- restaurant_id (restaurant_id2) — INT — Foreign key → restaurant.restaurant_id
order_item
- order_item_id — INT — Primary key
- menu_id — INT — NOT NULL
- order_id — INT — NOT NULL
- quantity — INT — NOT NULL
- order_id (order_id2) — INT — Foreign key → orders.order_id
- menu_id (menu_id2) — INT — Foreign key → menu.menu_id
orders
- order_id — INT — Primary key
- restaurant_id — INT — NOT NULL
- member_id — VARCHAR(50) — NOT NULL
- order_address — VARCHAR(200) — NOT NULL
- request — VARCHAR(300)
- total_price — INT — NOT NULL
- order_type — VARCHAR(20) — NOT NULL
- is_paid — CHAR(1) — NOT NULL
- order_time — DATETIME
- restaurant_id (restaurant_id2) — INT — Foreign key → restaurant.restaurant_id
restaurant
- restaurant_id — INT — Primary key
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(200) — NOT NULL
- phone — VARCHAR(20) — NOT NULL