foodcourt
Tables (4)
Customers (Untitled)
- 고객ID (c_id) — varchar(20) — Primary key — NOT NULL
Menu (Untitled4)
- 메뉴 이름 (m_name) — varchar(20) — Primary key — NOT NULL
- 메뉴 가격 (m_price) — integer
- 고객ID (c_id) — varchar(20) — Foreign key → Customers.고객ID — NOT NULL
Orders (Untitled3)
- 주문 번호 (o_number) — integer — Primary key — NOT NULL
- 고객ID (c_id) — varchar(20) — Foreign key → Customers.고객ID — NOT NULL
Store (Untitled2)
- 가게이름 (s_name) — varchar(20) — Primary key — NOT NULL
- 메뉴 수 (s_menu) — integer