Skip to content

Table:Sessions

Melvyn Harbour edited this page Nov 25, 2016 · 6 revisions

Contains details of Sessions that have been completed.

Column DataType Keys Comments
PK_SessionId INTEGER PRIMARY KEY
FK_DeviceinfoId INTEGER
Name VARCHAR(32)
SessionType INTEGER(1)
SystemOfUnits INTEGER(1)
SpeedInput INTEGER(1) 0 = GPS; 1 = Impellor
StartTime INTEGER(8) DateTime format
TotalElapsedTime INTEGER(4) Measured in ms
TotalDistance INTEGER(4) Measured in mm
AverageStrokeRate INTEGER(1) Double real value
AverageHeartRate INTEGER(1)
AverageSpeed REAL Measured in cm/s
StoreCompleted INTEGER(1)
ProfileAge INTEGER(1)
ProfileHeight INTEGER(1)
ProfileWeight INTEGER(2)
TotalCalories INTEGER(4)

Stroke rate appears to be doubled when stored in order to allow them to store fractional values in an integer field.

Clone this wiki locally