Food Court
Tables (3)
FoodMenu (Untitled)
- foodNumber — varchar(10) — Primary key — NOT NULL
- foodName — varchar(40)
- foodPrice — int — NOT NULL
- cornerNumber (cornerNumber2) — varchar(10) — Foreign key → foodCorner.cornerNumber — NOT NULL
foodCorner (Untitled2)
- cornerNumber — varchar(10) — Primary key — NOT NULL
- cornerName — varchar(40)
orderHistory (Untitled3)
- cornerNumber (cornerNumber2) — varchar(10) — Foreign key → foodCorner.cornerNumber — NOT NULL
- foodNumber (foodNumber2) — varchar(10) — Foreign key → FoodMenu.foodNumber — NOT NULL