id | firstName | lastName | position |
---|---|---|---|
1 | John | Doe | Manager |
2 | Jane | Smith | Assistant Manager |
id | staffId | experience |
---|---|---|
(→ Staff.id) | ||
1 | 1 | 5 years |
2 | 2 | 3 years |
id | chefId |
---|---|
(→ Chefs.id) | |
1 | 1 |
2 | 2 |
id | chefId |
---|---|
(→ Chefs.id) | |
1 | 1 |
2 | 2 |
id | itemName | preparationTime | price |
---|---|---|---|
1 | Burger | 10 | 9.99 |
2 | Pizza | 15 | 12.99 |
orderId | sousChefId | cookId | totalPrice |
---|---|---|---|
(→ Sous_Chef.id) | (→ Cooks.id) | ||
1 | 1 | 1 | 28.97 |
2 | 2 | 2 | 26.98 |