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 |