Restaurants
id | name | location | cuisine |
1 | The Garden Bistro | Downtown | Italian |
2 | Le Jardin | Uptown | French |
3 | Green Oasis | Northside | Mediterranean |
4 | La Veggie Cucina | Eastside | Vegetarian |
5 | Pasta Palace | Westside | Italian |
Cafe
id | name | location | specialty |
6 | The Herb House | Downtown | Herbal Teas |
7 | Garden Delights | Uptown | Organic Coffee |
8 | Tea Time | Northside | Afternoon Tea |
9 | Vegan Treats | Eastside | Vegetarian Options |
10 | Brew Haven | Westside | Specialty Roasts |
Menu_Options
id | option_name |
1 | Spaghetti Carbonara |
2 | Margherita Pizza |
3 | Caprese Salad |
4 | Lasagna |
5 | Tiramisu |
6 | Ratatouille |
7 | Quiche Lorraine |
8 | Grilled Vegetable Panini |
9 | Minestrone Soup |
10 | Gelato |
Restaurant_Menus
restaurant_id | menu_option_id |
(→ Restaurants.id) | (→ Menu_Options.id) |
1 | 1 |
1 | 2 |
2 | 3 |
2 | 4 |
3 | 5 |
3 | 6 |
4 | 7 |
4 | 8 |
5 | 9 |
Cafe_Menus
cafe_id | menu_option_id |
(→ Cafe.id) | (→ Menu_Options.id) |
6 | 10 |
7 | 1 |
8 | 2 |
9 | 3 |
10 | 4 |