## Guest

id | name | email
--- | --- | ---
1 | John Doe | johndoe@example.com
2 | Jane Smith | janesmith@example.com
3 | Alice Johnson | alicejohnson@example.com
4 | Bob Brown | bobbrown@example.com
5 | Charlie Davis | charliedavis@example.com

## Vacation

id | vacation_option | price
--- | --- | ---
| (→ VacationType.type) |
1 | Cruise Ship | 2000.0
2 | All-Inclusive Resort | 3000.0

## Activity

id | activities
--- | ---
1 | Dance Class
2 | Hiking Tour
3 | Beach Volleyball
4 | Snorkeling
5 | Wine Tasting

## Booking

id | guest_id | vacation_id | activity_id | checkin | checkout
--- | --- | --- | --- | --- | ---
| (→ Guest.id) | (→ Vacation.id) | (→ Activity.id) |  |
1 | 1 | 1 | 1 | 2023-01-01 10:00:00 | 2023-01-07 10:00:00
2 | 2 | 1 | 2 | 2023-01-10 10:00:00 | 2023-01-16 10:00:00
3 | 3 | 2 | 1 | 2023-02-01 10:00:00 | 2023-02-07 10:00:00
4 | 4 | 2 | 3 | 2023-02-10 10:00:00 | 2023-02-16 10:00:00
5 | 5 | 1 | 4 | 2023-03-01 10:00:00 | 2023-03-07 10:00:00

## VacationType

type | description
--- | ---
Cruise Ship | None
All-Inclusive Resort | None

## Hotel

id | hotel_name | address | phone_number | rating
--- | --- | --- | --- | ---
1 | Grand Ocean View | 123 Beach St. | +1234567890 | 4.5
2 | Coastal Paradise | 456 Coast Rd. | +987654321 | 4.0