## Customers

id | name | email | phoneNumber | Vacation_Option | Activities
--- | --- | --- | --- | --- | ---
1 | John Doe | john@example.com | 1234567890 | Cruise Ship | Dance Class
2 | Jane Smith | jane@example.com | 0987654321 | Cruise Ship | Yoga
3 | Michael Johnson | michael@example.com | 5555555555 | All-Inclusive Resort | Dance Class
4 | Emily Davis | emily@example.com | 4444444444 | All-Inclusive Resort | Hiking
5 | Alice Brown | alice@example.com | 3333333333 | Cruise Ship | Snorkeling
6 | Bob Wilson | bob@example.com | 2222222222 | All-Inclusive Resort | Golf

## Rooms

id | type | capacity | price
--- | --- | --- | ---
1 | Single Room | 1 | 100.0
2 | Double Room | 2 | 200.0
3 | Triple Room | 3 | 300.0
4 | Family Suite | 4 | 400.0
5 | Luxury Suite | 2 | 500.0

## Bookings

id | checkInDate | checkOutDate | totalPrice | roomId
--- | --- | --- | --- | ---
|  |  |  | (→ Rooms.id)
1 | 2022-01-01 | 2022-01-07 | 700.0 | 1
2 | 2022-01-15 | 2022-01-21 | 1000.0 | 2
3 | 2022-02-01 | 2022-02-07 | 400.0 | 3
4 | 2022-02-15 | 2022-02-21 | 600.0 | 4
5 | 2022-03-01 | 2022-03-07 | 800.0 | 5

## Customer_Bookings

id | customerId | bookingId
--- | --- | ---
| (→ Customers.id) | (→ Bookings.id)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3
4 | 4 | 4
5 | 5 | 5