chef_id | first_name | last_name |
---|---|---|
1 | John | Doe |
2 | Jane | Smith |
3 | Michael | Johnson |
sous_id | first_name | last_name | executive_chef_id |
---|---|---|---|
(→ Executive_chef.chef_id) | |||
1 | Alice | Brown | 1 |
2 | Bob | White | 2 |
3 | Charlie | Green | 3 |
restaurant_id | name | address | executive_chef_id | SOUS_CHEF_ID |
---|---|---|---|---|
(→ Executive_chef.chef_id) | (→ Sous_chef.sous_id) | |||
1 | The Ritz | Main Street | 1 | 1 |
2 | Le Grande | East Side | 2 | 2 |
3 | Ocean View | Beach Road | 3 | 3 |
menu_item_id | item_name | description | price |
---|---|---|---|
1 | Steak | Grilled Steak with Veggies | 30.99 |
2 | Salmon | Grilled Salmon with Rice | 25.8 |
3 | Pasta | Spaghetti Bolognese | 15.6 |
4 | Pizza | Margherita Pizza | 12.5 |
5 | Burger | Cheeseburger and Fries | 10.8 |
order_id | customer_name | date | total_amount | restaurant_id |
---|---|---|---|---|
(→ Restaurant.restaurant_id) | ||||
1 | Customer A | 2021-08-10 | 60.2 | 1 |
2 | Customer B | 2021-08-11 | 45.5 | 2 |
3 | Customer C | 2021-08-12 | 75.3 | 3 |
4 | Customer D | 2021-08-13 | 80.5 | 1 |
5 | Customer E | 2021-08-14 | 55.2 | 2 |
detail_id | quantity | menu_item_id | order_id |
---|---|---|---|
(→ Menu_items.menu_item_id) | (→ Orders.order_id) | ||
1 | 2 | 1 | 1 |
2 | 1 | 2 | 2 |
3 | 1 | 3 | 3 |
4 | 1 | 1 | 4 |
5 | 1 | 4 | 5 |