## Beverages

id | Name | Type | Price
--- | --- | --- | ---
1 | Coca Cola | Soft Drink | 2.99
2 | Red Wine | Wine | 8.99
3 | Whiskey Sour | Cocktail | 7.99
4 | Beer | Alcoholic Beverage | 5.99
5 | Champagne | Sparkling Wine | 15.99
6 | Pinot Noir | Wine | 10.99
7 | Old Fashioned | Cocktail | 8.99

## Professionals

id | First_Name | Last_Name | Position
--- | --- | --- | ---
1 | John | Doe | Manager
2 | Jane | Smith | Chef
3 | Alice | Williams | Sommelier
4 | Bob | Johnson | Bartender
5 | Alex | Martinez | Sommelier
6 | Alex | Turner | Bartender

## Employees

id | Professional_id | Date_of_birth | Email | Phone_number
--- | --- | --- | --- | ---
| (→ Professionals.id) |  |  |
1 | 1 | 2000-01-01 | john.doe@example.com | +1234567890
2 | 2 | 2001-02-02 | jane.smith@example.com | +0987654321
3 | 3 | 1999-03-03 | alice.williams@example.com | +1112223334
4 | 4 | 1998-04-04 | bob.johnson@example.com | +44332211556
5 | 5 | 1997-05-05 | alex.martinez@example.com | +7788990011
6 | 6 | 1996-06-06 | alex.turner@example.com | +2233445566

## Restaurants

id | Name | Location | Opening_hours
--- | --- | --- | ---
1 | The Fancy Bistro | New York City | Monday - Sunday: 10 AM - 11 PM
2 | Le Jardin Secret | Paris | Monday - Friday: 10 AM - 10 PM, Saturday - Sunday: 11 AM - 11 PM

## Reservations

id | Customer_id | Table_Number | Reservation_date | Party_size | Total_cost
--- | --- | --- | --- | --- | ---
| (→ Customers.id) |  |  |  |
1 | 1 | 1 | 2023-01-01 19:00:00 | 4 | 200.0
2 | 2 | 2 | 2023-01-02 20:00:00 | 2 | 100.0
3 | 3 | 3 | 2023-01-03 19:00:00 | 6 | 300.0
4 | 4 | 4 | 2023-01-04 20:00:00 | 5 | 250.0

## Orders

id | Ordered_by | Item_name | Quantity | Date_ordered | Total_amount
--- | --- | --- | --- | --- | ---
| (→ Reservations.id) |  |  |  |
1 | 1 | Steak | 2 | 2023-01-01 19:30:00 | 70.0
2 | 2 | Pizza Margherita | 3 | 2023-01-02 20:30:00 | 45.0
3 | 3 | White Burgundy | 4 | 2023-01-03 19:30:00 | 53.96
4 | 4 | Bloody Mary | 2 | 2023-01-04 20:30:00 | 17.98