Restaurants
id | name | address | phoneNumber |
1 | Le Jardin | 123 Main St | 555-1234 |
2 | The Rooftop Lounge | 456 Elm St | 555-5678 |
3 | Café des Amis | 789 Oak St | 555-9012 |
4 | La Maison du Fromage | 135 Pine St | 555-1357 |
5 | Gourmet Bistro | 321 Maple Ave | 555-2345 |
Sommeliers
id | firstName | lastName | restaurantId |
| | | (→ Restaurants.id) |
1 | Alex | Dupont | 1 |
2 | Michael | Johnson | 1 |
3 | Nina | Smith | 2 |
4 | Peter | Jones | 2 |
5 | Emily | Williams | 3 |
Bartenders
id | firstName | lastName | restaurantId |
| | | (→ Restaurants.id) |
1 | Alex | Martin | 1 |
2 | David | Lee | 1 |
3 | Amanda | Green | 2 |
4 | Chris | Wright | 2 |
5 | Karen | Hall | 3 |
Customers
id | firstName | lastName | phoneNumber |
1 | Tom | Brown | 555-0001 |
2 | Lucy | White | 555-0002 |
3 | Jack | Black | 555-0003 |
4 | Anna | Blue | 555-0004 |
5 | Samantha | Red | 555-0005 |