## Meals

id | Prepared_Meal | Best_Before | Quantity | Price
--- | --- | --- | --- | ---
1 | Roast Chicken | 10.11.2018 | 30 | 19.99
2 | Pasta Carbonara | 17.11.2018 | 20 | 8.99

## Takeaways

id | Takeaway | Best_Before | Quantity | Price
--- | --- | --- | --- | ---
1 | Chinese Fried Rice | 10.11.2018 | 25 | 6.99
2 | Burger & Fries | 17.11.2018 | 15 | 5.99

## Customers

id | FirstName | LastName | Email | PhoneNumber
--- | --- | --- | --- | ---
1 | John | Doe | john@example.com | +1 234 567 890
2 | Jane | Smith | jane@example.com | +1 345 678 901

## Orders

order_id | meal_id | customer_id | quantity
--- | --- | --- | ---
| (→ Meals.id) | (→ Customers.id) |
1 | 1 | 1 | 2
2 | 2 | 2 | 1

## Reservations

reservation_id | takeaway_id | customer_id | date
--- | --- | --- | ---
| (→ Takeaways.id) | (→ Customers.id) |
1 | 1 | 1 | 2021-11-10 10:00:00
2 | 2 | 2 | 2021-11-17 10:00:00

## Reviews

review_id | meal_id | rating | comment
--- | --- | --- | ---
| (→ Meals.id) |  |
1 | 1 | 5 | Delicious!
2 | 2 | 4 | Nice pasta but not amazing.