ID | Name | Lobby | Terrace |
---|---|---|---|
1 | Single | Yes | No |
2 | Double | No | Yes |
3 | Suite | Yes | Yes |
ID | TypeID | Size |
---|---|---|
(→ RoomTypes.ID) | ||
1 | 1 | 500.0 |
2 | 1 | 600.0 |
3 | 2 | 700.0 |
4 | 3 | 800.0 |
ID | FirstName | LastName | |
---|---|---|---|
1 | John | Doe | john@example.com |
2 | Jane | Smith | jane@example.com |
3 | Alice | Brown | alice@example.com |
4 | Bob | White | bob@example.com |
ID | RoomID | CheckInDate | CheckOutDate | GuestID |
---|---|---|---|---|
(→ Rooms.ID) | (→ Guests.ID) | |||
1 | 1 | 2022-01-01 | 2022-01-05 | 1 |
2 | 2 | 2022-01-06 | 2022-01-10 | 2 |
3 | 3 | 2022-01-11 | 2022-01-15 | 3 |
4 | 4 | 2022-01-16 | 2022-01-20 | 4 |