Kitchen_Personnel

idnamepositionexperience
(→ ExperienceTable.column1)
1John DoeSous Chef5 years
2Jane SmithSous Chef3 years
3Mike JohnsonCook5 years
4Emily DavisCook2 years

ExperienceTable

idcolumn1
15 years
23 years
32 years

Guests

idnameroomNumbercheckIncheckOut
(→ RoomsTable.id)
1Guest A1012022-06-01 14:00:002022-06-05 12:00:00
2Guest B1022022-06-10 10:00:002022-06-14 18:00:00

RoomsTable

idtypecapacity
1Single Room1
2Double Room2

Bookings

idguestIdbookingDatetotalCost
(→ Guests.id)
112022-06-01 10:00:00300.0
222022-06-10 14:00:00500.0

MenuItems

iditemNamepricecategorykitchenStaffId
(→ Kitchen_Personnel.id)
1Burger10.99Main Course1
2Salad7.99Appetizer2