## Activity

activity_id | activity_name | activity_type
--- | --- | ---
1 | Tourist Attraction | Attraction
2 | Tourist Attraction | Museum
3 | Local Market | Market
4 | Local Market | Farmers Market
5 | Restaurant | Italian

## Location

location_id | location_name
--- | ---
1 | Portobello
2 | Notting Hill
3 | Covent Garden
4 | Camden Town
5 | Piccadilly Circus

## Activity_Location

activity_location_id | activity_id | location_id
--- | --- | ---
| (→ Activity.activity_id) | (→ Location.location_id)
1 | 1 | 1
2 | 1 | 2
3 | 3 | 1
4 | 4 | 2
5 | 5 | 3

## Customer

customer_id | first_name | last_name | email
--- | --- | --- | ---
1 | John | Doe | john.doe@example.com
2 | Jane | Smith | jane.smith@example.com
3 | Alice | Brown | alice.brown@example.com
4 | Bob | White | bob.white@example.com
5 | Charlie | Black | charlie.black@example.com

## Booking

booking_id | customer_id | checkin_date | checkout_date
--- | --- | --- | ---
| (→ Customer.customer_id) |  |
1 | 1 | 2023-01-01 | 2023-01-07
2 | 2 | 2023-01-15 | 2023-01-22
3 | 3 | 2023-02-01 | 2023-02-08
4 | 4 | 2023-02-16 | 2023-02-23
5 | 5 | 2023-03-01 | 2023-03-09

## Reservation

reservation_id | booking_id | activity_location_id | num_people
--- | --- | --- | ---
| (→ Booking.booking_id) | (→ Activity_Location.activity_location_id) |
1 | 1 | 1 | 4
2 | 1 | 2 | 3
3 | 2 | 3 | 2
4 | 2 | 4 | 5
5 | 3 | 5 | 4