| 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 |
| id | firstName | lastName | 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 |
| id | firstName | lastName | 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 |
| 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 |