Skip to content
database tables
Walk and Route Database
There are two tables in this database: route and walk. The two tables are shown below.
ROUTE
ROUTEID
STARTPOINT
FINISHPOINT
ESTIMATEDMINS
KMS
ROUTETYPE
RATING
1
Shiel Bridge
Glen More
480
23
Mountain
5
2
Aberdour
Anstruther
600
44
Coastal
4
3
Rackwick
Rackwick
180
12
Coastal
2
4
Kelty
Loch Glow
90
5
Forest
1
5
Fort William
Steall Falls
210
8
Hill
4
6
Pitlochry
Blair Atholl
175
11
Forest
2
There are no rows in this table
6
Count
WALK
WALKNUMBER
WALKDAY
DEPARTURE
NUMBERWALKERS
RAINED
MINUTESTAKEN
ROUTEID
1893
21-Mar-2017
30-Dec-1899
9
Yes
213
3
2002
30-Apr-2017
30-Dec-1899
15
No
167
3
19
27-Nov-2014
30-Dec-1899
30
No
606
2
218
01-Feb-2016
30-Dec-1899
3
No
102
4
723
16-Oct-2015
30-Dec-1899
12
Yes
713
2
86
01-Jan-2015
30-Dec-1899
24
Yes
180
6
1992
05-Apr-2017
30-Dec-1899
2
No
512
1
499
19-Nov-2015
30-Dec-1899
9
No
190
5
There are no rows in this table
8
Count
Scripts
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.