id | Name | Age |
---|---|---|
1 | Alice | 30 |
2 | Bob | 28 |
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 |
id | Name | Type | Location |
---|---|---|---|
(→ Locations.Name) | |||
1 | Farmers Market | Organic produce and handmade crafts. | Portobello |
2 | Shopping Centre | Clothing stores and electronics shops. | Kensington |
Name | Longitude | Latitude |
---|---|---|
Portobello | -0.1967 | 51.5164 |
Notting Hill | -0.1897 | 51.5172 |
Kensington | -0.1842 | 51.5149 |
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 |
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 |