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 |
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 |
id | Professional_id | Date_of_birth | 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 |
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 |
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 |
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 |