Sommeliers
ID | First_Name | Last_Name | Birthdate | PhoneNumber |
1 | Alex | Smith | 2000-06-15 | +123456789 |
2 | John | Doe | 1995-07-20 | +987654321 |
Bartenders
ID | First_Name | Last_Name | Birthdate | PhoneNumber |
1 | Alex | Miller | 2000-06-15 | +123456789 |
2 | Jane | White | 1995-07-20 | +987654321 |
Customers
ID | First_Name | Last_Name | Email | RegistrationDate |
1 | Alice | Zhang | alice@example.com | 2024-03-13 17:35:22 |
2 | Bob | Li | bob@example.com | 2024-03-13 17:35:22 |
Orders
OrderID | CustomerID | DateOfOrder | TotalAmount |
| (→ Customers.ID) | | |
1 | 1 | 2021-08-01 12:00:00 | 100 |
2 | 2 | 2021-08-01 12:30:00 | 150 |
WineList
WineID | Name | Origin | Price |
1 | Merlot | France | 50 |
2 | Chardonnay | Australia | 60 |
BeverageList
BeverageID | Name | Type | Price |
1 | Coke | Soft Drink | 2 |
2 | Beer | Alcoholic Beverage | 4 |