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 |