## Customers

CustomerID | FirstName | LastName | EmailAddress | PhoneNumber
--- | --- | --- | --- | ---
1 | John | Smith | johnsmith@example.com | +123456789
2 | Jane | Doe | janedoe@example.com | +098765432

## FoodTypes

FoodTypeID | TypeName
--- | ---
1 | Prepared Meal
2 | Takeaway

## Products

ProductID | Name | Dining | Best_Before
--- | --- | --- | ---
|  | (→ FoodTypes.FoodTypeID) |
1 | Pizza | 1 | 10.11.2018
2 | Burger | 1 | 11.11.2018
3 | Salad | 2 | 10.11.2018
4 | Coffee | 2 | 12.11.2018

## Orders

OrderID | CustomerID | TotalAmount | OrderDate
--- | --- | --- | ---
(→ Products.ProductID) | (→ Customers.CustomerID) |  |
1 | 1 | 100 | 2024-03-13 11:03:54
2 | 2 | 150 | 2024-03-13 11:03:54