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