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 |