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