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 |