food_court
Tables (3)
menu (Untitled2)
- 메뉴ID (m_id) — integer — Primary key — NOT NULL
- 메뉴이름 (m_name) — varchar(40)
- 식당ID (r_id) — integer — Foreign key → restaurant.식당ID — NOT NULL
- 메뉴가격 (m_price) — varchar(30)
- 메뉴수량 (m_count) — integer
orders (Untitled3)
- 주문ID (o_id) — integer — Primary key — NOT NULL
- 식당ID (r_id) — integer — Foreign key → restaurant.식당ID — NOT NULL
- 메뉴ID (m_id) — integer — Foreign key → menu.메뉴ID — NOT NULL
restaurant (Untitled)
- 식당ID (r_id) — integer — Primary key — NOT NULL
- 식당이름 (r_name) — varchar(30)