Menu

idNameDescriptionPreparationTimePrice
1Cheese BurgerA juicy burger made of beef patty.309.99
2Veggie SandwichHealthy sandwich filled with fresh vegetables.207.99

Meals

idMenuIdQuantity
(→ Menu.id)
111
222

Orders

OrderIDCustomerNameTotalPriceOrderDateBestBefore
1John Doe16.982024-03-13 19:14:5910.11.2018
2Jane Smith20.02024-03-13 19:14:5911.11.2018

ItemsInOrder

ItemIdOrderIdMealIdQuantity
(→ Orders.OrderID)(→ Meals.id)
1111
2122

Takeaways

idOrderIdPickupDateTime
(→ Orders.OrderID)
112018-11-10 10:00:00
222018-11-11 10:00:00