## Hotels

id | name | address | phoneNumber
--- | --- | --- | ---
1 | The Grand Hotel | 123 Main St | +1234567890
2 | Park Plaza Inn | 456 Market St | +0987654321
3 | Riverview Suites | 789 River Rd | +1112223333
4 | Sunset Beach Resort | 321 Ocean Blvd | +4445556667
5 | Mountain Retreat Lodge | 654 Mountain Way | +7778889990

## HouseKeepers

id | firstName | lastName | email | hireDate | salary | hotelId
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ Hotels.id)
1 | John | Doe | john.doe@example.com | 2021-01-01 | 35000.0 | 1
2 | Jane | Smith | jane.smith@example.com | 2021-02-01 | 38000.0 | 2
3 | Alice | Brown | alice.brown@example.com | 2021-03-01 | 40000.0 | 3
4 | Mike | Johnson | mike.johnson@example.com | 2021-04-01 | 36000.0 | 4
5 | Emma | Williams | emma.williams@example.com | 2021-05-01 | 39000.0 | 5

## LaundryAttendants

id | firstName | lastName | email | hireDate | salary | hotelId
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ Hotels.id)
1 | David | Martin | david.martin@example.com | 2021-01-01 | 32000.0 | 1
2 | Lucy | Taylor | lucy.taylor@example.com | 2021-02-01 | 33000.0 | 2
3 | Charlie | Thompson | charlie.thompson@example.com | 2021-03-01 | 34000.0 | 3
4 | Grace | Miller | grace.miller@example.com | 2021-04-01 | 35000.0 | 4
5 | Samantha | Wright | samantha.wright@example.com | 2021-05-01 | 36000.0 | 5

## Rooms

id | number | hotelId | houseKeeperId | laundryAttendantId
--- | --- | --- | --- | ---
|  | (→ Hotels.id) | (→ HouseKeepers.id) | (→ LaundryAttendants.id)
1 | 101 | 1 | 1 | 1
2 | 201 | 2 | 2 | 2
3 | 301 | 3 | 3 | 3
4 | 401 | 4 | 4 | 4
5 | 501 | 5 | 5 | 5
6 | 102 | 1 | 1 | 1
7 | 202 | 2 | 2 | 2
8 | 302 | 3 | 3 | 3
9 | 402 | 4 | 4 | 4
10 | 502 | 5 | 5 | 5