| Id | TypeName |
|---|---|
| 1 | Single |
| 2 | Double |
| 3 | Twin |
| 4 | Triple |
| 5 | Suite |
| Id | RoomTypeId | FloorNumber |
|---|---|---|
| (→ RoomTypes.Id) | ||
| 1 | 1 | 1 |
| 2 | 2 | 1 |
| 3 | 3 | 2 |
| 4 | 4 | 3 |
| 5 | 5 | 3 |
| 6 | 6 | 4 |
| 7 | 7 | 4 |
| 8 | 8 | 5 |
| 9 | 9 | 5 |
| 10 | 10 | 6 |
| Id | FirstName | LastName | EmailAddress | PhoneNumber |
|---|---|---|---|---|
| 1 | John | Doe | john.doe@example.com | +1234567890 |
| 2 | Jane | Smith | jane.smith@example.com | +9876543210 |
| 3 | Michael | Brown | michael.brown@example.com | +1357924680 |
| 4 | Alice | Johnson | alice.johnson@example.com | +1357924680 |
| 5 | David | White | david.white@example.com | +1357924680 |
| Id | CheckInDate | CheckOutDate | RoomId | GuestId |
|---|---|---|---|---|
| (→ Rooms.Id) | (→ Guests.Id) | |||
| 1 | 2022-01-01 10:00:00 | 2022-01-05 10:00:00 | 1 | 1 |
| 2 | 2022-01-10 10:00:00 | 2022-01-14 10:00:00 | 2 | 2 |
| 3 | 2022-01-15 10:00:00 | 2022-01-19 10:00:00 | 3 | 3 |
| 4 | 2022-01-20 10:00:00 | 2022-01-24 10:00:00 | 4 | 4 |
| 5 | 2022-01-25 10:00:00 | 2022-01-29 10:00:00 | 5 | 5 |
| 6 | 2022-02-01 10:00:00 | 2022-02-05 10:00:00 | 6 | 6 |
| 7 | 2022-02-10 10:00:00 | 2022-02-14 10:00:00 | 7 | 7 |
| 8 | 2022-02-15 10:00:00 | 2022-02-19 10:00:00 | 8 | 8 |
| 9 | 2022-02-20 10:00:00 | 2022-02-24 10:00:00 | 9 | 9 |
| 10 | 2022-02-25 10:00:00 | 2022-02-29 10:00:00 | 10 | 10 |
| Id | Name | Role | Language | AdditionalColumn1 | AdditionalColumn2 | AdditionalColumn3 |
|---|---|---|---|---|---|---|
| 1 | Pedro | Chef | Spanish | None | None | None |
| 2 | Emma | Chef | English | None | None | None |
| 3 | Lucas | Server | Spanish | None | None | None |
| 4 | Ava | Server | English | None | None | None |
| 5 | Carlos | Manager | Spanish | None | None | None |
| 6 | Emily | Receptionist | English | None | None | None |
| 7 | Manuel | Maintenance | Spanish | None | None | None |
| 8 | Grace | Housekeeping | English | None | None | None |