Beverages

idNameTypePrice
1Coca ColaSoft Drink2.99
2Red WineWine8.99
3Whiskey SourCocktail7.99
4BeerAlcoholic Beverage5.99
5ChampagneSparkling Wine15.99
6Pinot NoirWine10.99
7Old FashionedCocktail8.99

Professionals

idFirst_NameLast_NamePosition
1JohnDoeManager
2JaneSmithChef
3AliceWilliamsSommelier
4BobJohnsonBartender
5AlexMartinezSommelier
6AlexTurnerBartender

Employees

idProfessional_idDate_of_birthEmailPhone_number
(→ Professionals.id)
112000-01-01john.doe@example.com+1234567890
222001-02-02jane.smith@example.com+0987654321
331999-03-03alice.williams@example.com+1112223334
441998-04-04bob.johnson@example.com+44332211556
551997-05-05alex.martinez@example.com+7788990011
661996-06-06alex.turner@example.com+2233445566

Restaurants

idNameLocationOpening_hours
1The Fancy BistroNew York CityMonday - Sunday: 10 AM - 11 PM
2Le Jardin SecretParisMonday - Friday: 10 AM - 10 PM, Saturday - Sunday: 11 AM - 11 PM

Reservations

idCustomer_idTable_NumberReservation_dateParty_sizeTotal_cost
(→ Customers.id)
1112023-01-01 19:00:004200.0
2222023-01-02 20:00:002100.0
3332023-01-03 19:00:006300.0
4442023-01-04 20:00:005250.0

Orders

idOrdered_byItem_nameQuantityDate_orderedTotal_amount
(→ Reservations.id)
11Steak22023-01-01 19:30:0070.0
22Pizza Margherita32023-01-02 20:30:0045.0
33White Burgundy42023-01-03 19:30:0053.96
44Bloody Mary22023-01-04 20:30:0017.98