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)