Customers

CustomerIDFirstNameLastNameEmailAddressPhoneNumber
1JohnSmithjohnsmith@example.com+123456789
2JaneDoejanedoe@example.com+098765432

FoodTypes

FoodTypeIDTypeName
1Prepared Meal
2Takeaway

Products

ProductIDNameDiningBest_Before
(→ FoodTypes.FoodTypeID)
1Pizza110.11.2018
2Burger1Not 10.11.2018
3Salad210.11.2018
4Coffee2Not 10.11.2018

Orders

OrderIDCustomerIDTotalAmountOrderDate
(→ Products.ProductID)(→ Customers.CustomerID)
111002024-03-13 11:03:54
221502024-03-13 11:03:54