Beach

idname
1White Sands Beach
2Sunny Shores Beach

Beach_Club

idbeach_idclub_name
(→ Beach.id)
11Ocean Waves Club
22Seashells Club

Watersports_Rental

idbeach_club_idrental_itemprice
(→ Beach_Club.id)
11Surfboard35.99
22Kayak29.99

Guest

idfirst_namelast_nameemail
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com

Reservation

idguest_idrental_datestart_timeend_timenum_people
(→ Guest.id)
112023-06-0110:0017:008
222023-06-0211:0018:006

Review

idreservation_idratingcomments
(→ Reservation.id)
115Great experience!
224Good time but could have used a little more guidance.