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 |
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 |
id | FirstName | LastName | PhoneNumber | |
---|---|---|---|---|
1 | John | Doe | john@example.com | +1 234 567 890 |
2 | Jane | Smith | jane@example.com | +1 345 678 901 |
order_id | meal_id | customer_id | quantity |
---|---|---|---|
(→ Meals.id) | (→ Customers.id) | ||
1 | 1 | 1 | 2 |
2 | 2 | 2 | 1 |
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 |
review_id | meal_id | rating | comment |
---|---|---|---|
(→ Meals.id) | |||
1 | 1 | 5 | Delicious! |
2 | 2 | 4 | Nice pasta but not amazing. |