## Housekeeping

id | housekeeper | hotel | shift_start | shift_end
--- | --- | --- | --- | ---
1 | John Doe | The Grand Hotel | 2024-03-13 17:44:11 | None
2 | Jane Smith | Ritz Carlton | 2024-03-13 17:44:11 | None

## LaundryService

id | laundry_attendant | hotel | shift_start | shift_end
--- | --- | --- | --- | ---
1 | Mary Johnson | The Grand Hotel | 2024-03-13 17:44:11 | None
2 | Tom Brown | Four Seasons | 2024-03-13 17:44:11 | None

## GuestRooms

room_id | hotel_name | room_number | capacity | amenities
--- | --- | --- | --- | ---
1 | The Grand Hotel | 101 | 2 | TV, Mini Fridge, Air Conditioner
2 | Ritz Carlton | 301 | 3 | TV, Mini Fridge, Air Conditioner, Balcony

## Reservations

reservation_id | guest_name | email | phone_number | checkin_date | checkout_date | room_id
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ GuestRooms.room_id)
1 | Alice Jones | alice@example.com | +1 9876543210 | 2023-01-01 | 2023-01-05 | 1
2 | Bob Smith | bob@example.com | +1 5556667777 | 2023-02-01 | 2023-02-05 | 2

## MaintenanceRequests

request_id | description | requested_at | resolved_at | status
--- | --- | --- | --- | ---
1 | Leaky faucet in Room 101 | 2024-03-13 17:44:11 | None | Pending
2 | Broken air conditioner in Room 301 | 2024-03-13 17:44:11 | 2023-01-02 | Resolved