## Menus

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

## Customers

customer_id | name | phone
--- | --- | ---
1 | John Doe | 1234567890
2 | Jane Smith | 9876543210
3 | Bob Johnson | 1112223330
4 | Alice Brown | 2223334440

## Orders

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

## FoodItems

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