| 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 |