Employees

IDFirst_NameLast_NamePosition
1AlexSmithBeverage Professional
2JohnDoeManager
3JaneWhiteWaitress
4MikeBlackChef
5EmmaGreenHousekeeping

Beverages

IDNameType
1Wine ARed Wine
2Beer BBeer
3Cocktail CSpirits
4Mocktail DNon Alcoholic
5Tea EHot Drink

Orders

OrderIDDateTotalAmount
12023-01-01 18:00:0075.67
22023-01-02 19:00:0085.49
32023-01-03 20:00:00100.0
42023-01-04 21:00:00120.0
52023-01-05 22:00:00140.0

OrderItems

ItemIDOrderIDQuantity
(→ Orders.OrderID)
112
221
333
444
555

OrderItemDetails

DetailIDItemIDBeverageIDPrice
(→ OrderItems.ItemID)(→ Beverages.ID)
11145.0
21215.0
32330.0
43420.0
54510.0

EmployeeOrders

EmpIDOrderIDRole
(→ Employees.ID)(→ Orders.OrderID)
11Sommelier
22Sommelier
13Bartender
24Bartender