park_id | name | location |
---|---|---|
1 | Yellowstone | Wyoming |
2 | Grand Canyon | Arizona |
3 | Rocky Mountain | Colorado |
4 | Everglades | Florida |
5 | Great Smoky Mountains | Tennessee |
trail_id | difficulty | length |
---|---|---|
1 | Beginner_Trail | 1.0 |
2 | Moderate_Trail | 3.0 |
3 | Difficult_Trail | 6.0 |
4 | Expert_Trail | 9.0 |
5 | Family_Friendly_Trail | 2.0 |
national_park_id | trail_id |
---|---|
(→ National_Parks.park_id) | (→ Trails.trail_id) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
5 | 2 |