## Menu

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

## Meals

id | MenuId | Quantity
--- | --- | ---
| (→ Menu.id) |
1 | 1 | 1
2 | 2 | 2

## Orders

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

## ItemsInOrder

ItemId | OrderId | MealId | Quantity
--- | --- | --- | ---
| (→ Orders.OrderID) | (→ Meals.id) |
1 | 1 | 1 | 1
2 | 1 | 2 | 2

## Takeaways

id | OrderId | PickupDateTime
--- | --- | ---
| (→ Orders.OrderID) |
1 | 1 | 2018-11-10 10:00:00
2 | 2 | 2018-11-11 10:00:00