id | name | address | phone_number |
---|---|---|---|
1 | Pizza Palace | 123 Main St | 555-0100 |
2 | Burger Joint | 456 Elm St | 555-0101 |
3 | Taco Town | 789 Oak St | 555-0102 |
4 | Seafood Shack | 123 Pine St | 555-0103 |
5 | French Bistro | 456 Maple St | 555-0104 |
role_id | role_name |
---|---|
1 | Chef |
2 | Line Cook |
3 | Prep Cook |
4 | Dishwasher |
5 | Host/Hostess |
restaurant_id | kitchen_role_id |
---|---|
(→ Restaurants.id) | (→ Kitchen_Roles.role_id) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
5 | 5 |