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 | 11.11.2018 |
3 | Salad | 2 | 10.11.2018 |
4 | Coffee | 2 | 12.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 |