Food_Court
Tables (3)
Conor (Untitled5)
- conor_id (Field) — int — Primary key — NOT NULL
- name (Field2) — varchar(10) — NOT NULL
Orders (Untitled6)
- order_id (PK) — int — Primary key — NOT NULL
- menu_id (Field2) — int — Foreign key → menu.menu_id — NOT NULL
- conor_id (Field4) — int — Foreign key → menu.conor_id — NOT NULL
- Status (Field) — char(1) — NOT NULL
- menu_count (Field3) — int — NOT NULL
menu (Untitled7)
- menu_id (Field) — int — Primary key — NOT NULL
- conor_id (Field4) — int — Foreign key → Conor.conor_id — NOT NULL
- menu_name (Field2) — varchar(10) — NOT NULL
- price (Field3) — int — NOT NULL