A

Tables (3)

Food

  • foodid — int — Primary key — NOT NULL
  • restaurantid — int — Foreign key → Restaurant.restaurantid — NOT NULL
  • foodname — varchar(20)
  • foodprice — int

Orders

  • foodid (foodid2) — int — Foreign key → Food.foodid — NOT NULL
  • restaurantid (restaurantid3) — int — Foreign key → Restaurant.restaurantid — NOT NULL
  • orderid — int
  • amount — int
  • total — int
  • orderdate — date

Restaurant

  • restaurantid — int — Primary key — NOT NULL
  • restaurantname — varchar(20)