CustomerID | FirstName | LastName | PhoneNumber | |
---|---|---|---|---|
1 | John | Doe | john.doe@example.com | +123456789 |
2 | Jane | Smith | jane.smith@example.com | +098765432 |
3 | Alice | Brown | alice.brown@example.com | +1123456789 |
4 | Charlie | White | charlie.white@example.com | +0098765432 |
5 | David | Black | david.black@example.com | +11123456789 |
RestaurantID | Name | Address | OpeningTime | ClosingTime |
---|---|---|---|---|
1 | The Gourmet Place | 123 Main St | 08:00:00 | 22:00:00 |
2 | Fast Bites | 456 Market St | 07:00:00 | 23:00:00 |
3 | Cozy Cafe | 789 High St | 09:00:00 | 21:00:00 |
4 | Deli Delight | 321 Ocean Blvd | 10:00:00 | 20:00:00 |
5 | Pizza Palace | 987 Second Ave | 11:00:00 | 23:59:59 |
MealID | MealType | BestBefore | Description | Price |
---|---|---|---|---|
1 | Prepared Meal | 10.11.2018 | A delicious steak dinner. | 29.99 |
2 | Prepared Meal | 11.12.2018 | Grilled salmon with asparagus. | 19.99 |
3 | Takeaway | 10.11.2018 | Fried chicken combo meal. | 9.99 |
4 | Takeaway | 11.12.2018 | Veggie burger and fries. | 8.99 |
5 | Breakfast | 12.13.2018 | Eggs Benedict with hollandaise sauce. | 14.99 |
OrderID | CustomerID | MealID | Quantity | OrderDate |
---|---|---|---|---|
(→ Customers.CustomerID) | (→ Meals.MealID) | |||
1 | 1 | 1 | 2 | 2024-03-07 21:09:43 |
2 | 2 | 2 | 1 | 2024-03-07 21:09:43 |
3 | 3 | 3 | 3 | 2024-03-07 21:09:43 |
4 | 4 | 4 | 1 | 2024-03-07 21:09:43 |
5 | 5 | 5 | 2 | 2024-03-07 21:09:43 |