| id | name |
|---|---|
| 1 | White Sands Beach |
| 2 | Sunny Shores Beach |
| id | beach_id | club_name |
|---|---|---|
| (→ Beach.id) | ||
| 1 | 1 | Ocean Waves Club |
| 2 | 2 | Seashells Club |
| id | beach_club_id | rental_item | price |
|---|---|---|---|
| (→ Beach_Club.id) | |||
| 1 | 1 | Surfboard | 35.99 |
| 2 | 2 | Kayak | 29.99 |
| id | first_name | last_name | |
|---|---|---|---|
| 1 | John | Doe | john.doe@example.com |
| 2 | Jane | Smith | jane.smith@example.com |
| id | guest_id | rental_date | start_time | end_time | num_people |
|---|---|---|---|---|---|
| (→ Guest.id) | |||||
| 1 | 1 | 2023-06-01 | 10:00 | 17:00 | 8 |
| 2 | 2 | 2023-06-02 | 11:00 | 18:00 | 6 |
| id | reservation_id | rating | comments |
|---|---|---|---|
| (→ Reservation.id) | |||
| 1 | 1 | 5 | Great experience! |
| 2 | 2 | 4 | Good time but could have used a little more guidance. |