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