Guests

idfirst_namelast_nameemail
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com
3MikeBrownmike.brown@example.com
4EmilyGreenemily.green@example.com
5DavidBlackdavid.black@example.com

Rooms

room_idguest_idbeach_id
(→ Guests.id)(→ Beaches.id)
111
223
331
442
551

Amenities

amenity_idamenity_typeroom_id
(→ Rooms.room_id)
1Beach Club1
2Beach Club2
3Watersports Rental1
4Watersports Rental3
5Swimming Pool4

Beaches

idnamedescription
1White Sands BeachThis beach has white sand and clear blue waters.
2Sunset BeachThis beach offers beautiful sunsets.
3Palm Tree BeachLined with palm trees, this beach provides shade and relaxation.
4Coral Reef BeachKnown for its coral reefs, this beach is perfect for snorkeling.
5Surfing BeachWith big waves, this beach is ideal for surfing enthusiasts.