| CustomerID | FirstName | LastName | EmailAddress | PhoneNumber |
|---|---|---|---|---|
| 1 | John | Smith | johnsmith@example.com | +123456789 |
| 2 | Jane | Doe | janedoe@example.com | +098765432 |
| FoodTypeID | TypeName |
|---|---|
| 1 | Prepared Meal |
| 2 | Takeaway |
| ProductID | Name | Dining | Best_Before |
|---|---|---|---|
| (→ FoodTypes.FoodTypeID) | |||
| 1 | Pizza | 1 | 10.11.2018 |
| 2 | Burger | 1 | Not 10.11.2018 |
| 3 | Salad | 2 | 10.11.2018 |
| 4 | Coffee | 2 | Not 10.11.2018 |
| 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 |