id | Name | Address | PhoneNumber | |
---|---|---|---|---|
1 | White Sands Beach | 123 Main St | 555-555-5555 | whitesand@email.com |
2 | Sunset Shores | 456 Ocean Blvd | 555-555-6789 | sunsets@email.com |
id | Name | Location | OpeningHours | PriceRange | Beach_id |
---|---|---|---|---|---|
(→ Beaches.id) | |||||
1 | Paradise Club | White Sands Beach | 9am - 6pm | $$ | 1 |
2 | Ocean View Club | Sunset Shores | 10am - 7pm | $$$ | 2 |
id | Item | RentalRate | AvailableDays | Beach_id |
---|---|---|---|---|
(→ Beaches.id) | ||||
1 | Kayak | 20.0 | Mon - Fri | 1 |
2 | Paddleboard | 25.0 | All Days | 2 |
id | Name | Cuisine | Rating | Beach_id |
---|---|---|---|---|
(→ Beaches.id) | ||||
1 | Seaside Grill | Italian | 4.5 | 1 |
2 | Surfside Cafe | Mexican | 4.0 | 2 |
id | Name | Star_rating | PriceRange | Beach_id |
---|---|---|---|---|
(→ Beaches.id) | ||||
1 | Oceanfront Inn | 3 | Moderate | 1 |
2 | Shoreline Suites | 4 | High | 2 |
id | Type | Capacity | Amenities | Beach_id |
---|---|---|---|---|
(→ Beaches.id) | ||||
1 | Hotel | 50 | Pool, WiFi, Parking | 1 |
2 | Vacation Home | 8 | No Pets Allowed, Jacuzzi, BBQ | 2 |