RoomTypes

IdTypeName
1Single
2Double
3Twin
4Triple
5Suite

Rooms

IdRoomTypeIdFloorNumber
(→ RoomTypes.Id)
111
221
332
443
553
664
774
885
995
10106

Guests

IdFirstNameLastNameEmailAddressPhoneNumber
1JohnDoejohn.doe@example.com+1234567890
2JaneSmithjane.smith@example.com+9876543210
3MichaelBrownmichael.brown@example.com+1357924680
4AliceJohnsonalice.johnson@example.com+1357924680
5DavidWhitedavid.white@example.com+1357924680

Bookings

IdCheckInDateCheckOutDateRoomIdGuestId
(→ Rooms.Id)(→ Guests.Id)
12022-01-01 10:00:002022-01-05 10:00:0011
22022-01-10 10:00:002022-01-14 10:00:0022
32022-01-15 10:00:002022-01-19 10:00:0033
42022-01-20 10:00:002022-01-24 10:00:0044
52022-01-25 10:00:002022-01-29 10:00:0055
62022-02-01 10:00:002022-02-05 10:00:0066
72022-02-10 10:00:002022-02-14 10:00:0077
82022-02-15 10:00:002022-02-19 10:00:0088
92022-02-20 10:00:002022-02-24 10:00:0099
102022-02-25 10:00:002022-02-29 10:00:001010

Staff

IdNameRoleLanguageAdditionalColumn1AdditionalColumn2AdditionalColumn3
1PedroChefSpanishNoneNoneNone
2EmmaChefEnglishNoneNoneNone
3LucasServerSpanishNoneNoneNone
4AvaServerEnglishNoneNoneNone
5CarlosManagerSpanishNoneNoneNone
6EmilyReceptionistEnglishNoneNoneNone
7ManuelMaintenanceSpanishNoneNoneNone
8GraceHousekeepingEnglishNoneNoneNone