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