| 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 |