menu_id | name | description | appetizers | buffet |
---|---|---|---|---|
1 | SomeMenu | Description for Some Menu. | Salad | Hilton |
2 | AnotherMenu | Description for Another Menu. | Salad | Not Hilton |
3 | YetAnotherMenu | Description for Yet Another Menu. | Soup | Hilton |
4 | FourthMenu | Description for Fourth Menu. | Soup | Not Hilton |
customer_id | name | phone |
---|---|---|
1 | John Doe | 1234567890 |
2 | Jane Smith | 9876543210 |
3 | Bob Johnson | 1112223330 |
4 | Alice Brown | 2223334440 |
order_id | customer_id | menu_id | total_price |
---|---|---|---|
(→ Customers.customer_id) | (→ Menus.menu_id) | ||
1 | 1 | 1 | 30.99 |
2 | 2 | 2 | 25.5 |
3 | 3 | 3 | 40.75 |
4 | 4 | 4 | 35.45 |
item_id | food_type | name | price | menu_id |
---|---|---|---|---|
(→ Menus.menu_id) | ||||
1 | Starter | Garden Salad | 7.99 | 1 |
2 | Main Course | Grilled Chicken | 15.99 | 2 |
3 | Dessert | Tiramisu | 6.99 | 2 |
4 | Starter | Tomato Soup | 4.99 | 3 |
5 | Main Course | Beef Steak | 20.99 | 3 |
6 | Side Dish | Mashed Potatoes | 3.99 | 4 |
7 | Dessert | Cheesecake | 5.99 | 4 |