## Tourists

id | Name | Age
--- | --- | ---
1 | Alice | 30
2 | Bob | 28

## Attractions

id | Name | Description | Location
--- | --- | --- | ---
|  |  | (→ Locations.Name)
1 | Museum of Natural History | A museum showcasing natural history. | Portobello
2 | Art Gallery | An art gallery featuring local artists. | Notting Hill

## Markets

id | Name | Type | Location
--- | --- | --- | ---
|  |  | (→ Locations.Name)
1 | Farmers Market | Organic produce and handmade crafts. | Portobello
2 | Shopping Centre | Clothing stores and electronics shops. | Kensington

## Locations

Name | Longitude | Latitude
--- | --- | ---
Portobello | -0.1967 | 51.5164
Notting Hill | -0.1897 | 51.5172
Kensington | -0.1842 | 51.5149

## Visits

id | touristId | attractionId | marketId | VisitDate
--- | --- | --- | --- | ---
| (→ Tourists.id) | (→ Attractions.id) | (→ Markets.id) |
1 | 1 | 1 | None | 2022-01-01
2 | None | 2 | 2 | 2022-01-02

## Reviews

id | visitorId | attractionId | reviewText | rating
--- | --- | --- | --- | ---
| (→ Tourists.id) | (→ Attractions.id) |  |
1 | 1 | 1 | Great experience! Loved it. | 5
2 | None | 2 | Could have been better. | 3