foodcourt

Tables (4)

customer (Untitled3)

  • c_id (Key) — Primary key — NOT NULL
  • m_id (Key2) — Foreign key → menu.m_id — NOT NULL
  • menu_num (Field)

menu (Untitled2)

  • m_id (Key) — Primary key — NOT NULL
  • m_name (Field)
  • price (Field2)

order (Untitled4)

  • num (Key) — Primary key — NOT NULL
  • r_id (Key2) — Foreign key → restaurant.r_id — NOT NULL
  • c_id (Key4) — Foreign key → customer.c_id — NOT NULL

restaurant (Untitled)

  • r_id (Key) — Primary key — NOT NULL
  • r_name (Field)
  • m_id (Key2) — Foreign key → menu.m_id — NOT NULL