## CleaningProfessionals

id | name | type | hotel_id
--- | --- | --- | ---
|  |  | (→ Hotels.id)
1 | Alice Johnson | Housekeeper | 1
2 | Bob Brown | Housekeeper | 2
3 | Charlie White | Laundry Attendant | 1
4 | David Green | Laundry Attendant | 2
5 | Eva Blue | Housekeeper | 1
6 | Frank Red | Laundry Attendant | 2

## Hotels

id | name
--- | ---
1 | The Grand Hotel
2 | Park View Inn

## Rooms

id | room_number | hotel_id
--- | --- | ---
|  | (→ Hotels.id)
1 | 101 | 1
2 | 201 | 1
3 | 301 | 2
4 | 401 | 2
5 | 501 | 2

## Reservations

id | checkin | checkout | room_id | customer_name
--- | --- | --- | --- | ---
|  |  | (→ Rooms.id) |
1 | 2023-01-01 | 2023-01-07 | 101 | John Doe
2 | 2023-01-14 | 2023-01-21 | 201 | Jane Smith

## Customers

id | full_name | email | phone
--- | --- | --- | ---
1 | John Doe | john@example.com | 123-456-7890
2 | Jane Smith | jane@example.com | 098-765-4321