id | Name | Description | PreparationTime | Price |
---|---|---|---|---|
1 | Cheese Burger | A juicy burger made of beef patty. | 30 | 9.99 |
2 | Veggie Sandwich | Healthy sandwich filled with fresh vegetables. | 20 | 7.99 |
id | MenuId | Quantity |
---|---|---|
(→ Menu.id) | ||
1 | 1 | 1 |
2 | 2 | 2 |
OrderID | CustomerName | TotalPrice | OrderDate | BestBefore |
---|---|---|---|---|
1 | John Doe | 16.98 | 2024-03-13 19:14:59 | 10.11.2018 |
2 | Jane Smith | 20.0 | 2024-03-13 19:14:59 | 11.11.2018 |
ItemId | OrderId | MealId | Quantity |
---|---|---|---|
(→ Orders.OrderID) | (→ Meals.id) | ||
1 | 1 | 1 | 1 |
2 | 1 | 2 | 2 |
id | OrderId | PickupDateTime |
---|---|---|
(→ Orders.OrderID) | ||
1 | 1 | 2018-11-10 10:00:00 |
2 | 2 | 2018-11-11 10:00:00 |