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 |