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 |
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 |
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 |
reservation_id | guest_name | 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 |
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 |