amenity_id | amenity | beach |
---|---|---|
1 | Beach Club | White Sands Beach |
2 | Beach Club | Palm Tree Beach |
3 | Watersports Rental | White Sands Beach |
4 | Watersports Rental | Sunset Beach |
guest_id | first_name | last_name | check_in | check_out |
---|---|---|---|---|
1 | John Doe | Jane Smith | 2023-06-01 18:00:00 | 2023-06-07 10:00:00 |
2 | Emily Jones | Michael Brown | 2023-06-10 19:00:00 | 2023-06-16 11:00:00 |
review_id | guest_id | rating | comment |
---|---|---|---|
(→ Guests.guest_id) | |||
1 | 1 | 5 | Great experience! Highly recommended. |
2 | 2 | 4 | Nice place but could use some improvements. |