Housekeeping

idhousekeeperhotelshift_startshift_end
1John DoeThe Grand Hotel2024-03-13 17:44:11None
2Jane SmithRitz Carlton2024-03-13 17:44:11None

LaundryService

idlaundry_attendanthotelshift_startshift_end
1Mary JohnsonThe Grand Hotel2024-03-13 17:44:11None
2Tom BrownFour Seasons2024-03-13 17:44:11None

GuestRooms

room_idhotel_nameroom_numbercapacityamenities
1The Grand Hotel1012TV, Mini Fridge, Air Conditioner
2Ritz Carlton3013TV, Mini Fridge, Air Conditioner, Balcony

Reservations

reservation_idguest_nameemailphone_numbercheckin_datecheckout_dateroom_id
(→ GuestRooms.room_id)
1Alice Jonesalice@example.com+1 98765432102023-01-012023-01-051
2Bob Smithbob@example.com+1 55566677772023-02-012023-02-052

MaintenanceRequests

request_iddescriptionrequested_atresolved_atstatus
1Leaky faucet in Room 1012024-03-13 17:44:11NonePending
2Broken air conditioner in Room 3012024-03-13 17:44:112023-01-02Resolved