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)