| 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. |