| 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_id | location_name |
|---|---|
| 1 | Portobello |
| 2 | Notting Hill |
| 3 | Covent Garden |
| 4 | Camden Town |
| 5 | Piccadilly Circus |
| 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_id | first_name | last_name | |
|---|---|---|---|
| 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_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_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 |