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