id | firstName | lastName | emailAddress |
---|---|---|---|
1 | John | Doe | john.doe@example.com |
2 | Jane | Smith | jane.smith@example.com |
3 | Alice | Brown | alice.brown@example.com |
4 | Bob | Green | bob.green@example.com |
5 | Charlie | Black | charlie.black@example.com |
reservationId | guestID | checkInDate | checkOutDate | overnightStays | amenities |
---|---|---|---|---|---|
(→ Guests.id) | |||||
1 | 1 | 2023-01-01 | 2023-01-03 | Guestroom | Air Conditioning |
2 | 2 | 2023-01-06 | 2023-01-08 | Guestroom | No Air Conditioning |
3 | 3 | 2023-01-10 | 2023-01-12 | Suite | Air Conditioning |
4 | 4 | 2023-01-13 | 2023-01-15 | Suite | No Air Conditioning |
5 | 5 | 2023-01-17 | 2023-01-19 | Guestroom | No Air Conditioning |
roomNumber | typeOfRoom | pricePerNight |
---|---|---|
1 | Standard Room | 100 |
2 | Deluxe Suite | 200 |
3 | Premium Suite | 300 |
4 | Family Suite | 250 |
5 | Executive Suite | 400 |
bookingId | reservationId | roomNumber |
---|---|---|
(→ Reservations.reservationId) | (→ Rooms.roomNumber) | |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |
reviewId | bookingId | rating | comments |
---|---|---|---|
(→ Bookings.bookingId) | |||
1 | 1 | 5 | Great stay! Very clean. |
2 | 2 | 4 | The suite was nice but a bit expensive. |
3 | 3 | 5 | Loved it! Perfect location. |
4 | 4 | 4 | Good experience overall. |
5 | 5 | 3 | Not what I expected. |