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 |