## 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