Sommeliers

IDFirst_NameLast_NameBirthdatePhoneNumber
1AlexSmith2000-06-15+123456789
2JohnDoe1995-07-20+987654321

Bartenders

IDFirst_NameLast_NameBirthdatePhoneNumber
1AlexMiller2000-06-15+123456789
2JaneWhite1995-07-20+987654321

Customers

IDFirst_NameLast_NameEmailRegistrationDate
1AliceZhangalice@example.com2024-03-13 17:35:22
2BobLibob@example.com2024-03-13 17:35:22

Orders

OrderIDCustomerIDDateOfOrderTotalAmount
(→ Customers.ID)
112021-08-01 12:00:00100
222021-08-01 12:30:00150

WineList

WineIDNameOriginPrice
1MerlotFrance50
2ChardonnayAustralia60

BeverageList

BeverageIDNameTypePrice
1CokeSoft Drink2
2BeerAlcoholic Beverage4