RdsDiagram
User
rowId: VARCHAR(255)
uName: VARCHAR(255)
uEmail: VARCHAR(255)
uAge: INTEGER
uWeight: DOUBLE
uLastModified: DATE
Bike
rowId: VARCHAR(255)
sUserId: VARCHAR(255)
sTitle: VARCHAR(255)
sBikeType: VARCHAR(255)
sWheelSize: INTEGER
sWeight: DOUBLE
sActive: BOOLEAN
sLastModified: DATE
Ride
rowId: VARCHAR(255)
rBikeType: VARCHAR(255)
rTitle: VARCHAR(255)
stravaId: INTEGER
ghostRideId: INTEGER
rStartTime: DATE
rDuration: DATE
rEndTime: DATE
rAverageSpeed: REAL
rDistance: REAL
rFinal: INTEGER
rActualStartTime: DATE
rMaxSpeed: REAL
rMaxPower: REAL
rAveragePower: REAL
rMaxCadence: REAL
rAverageCadence: REAL
rMaxAltitudeDif: REAL
rAverageHR: INTEGER
rMaxHR: INTEGER
rCalories: INTEGER
rGainedAltitude: REAL
rComment: VARCHAR(255)
rActivity: INTEGER
riderId: INTEGER
rTargetAverageCadence: INTEGER
rTargetAverageHeartRate: INTEGER
rTargetAveragePower: INTEGER
rTargetAverageSpeed: REAL
rTargetAverageSpeedMetric: INTEGER
rLastModified: DATE
Lap
rowId: VARCHAR(255)
lRideId: VARCHAR(255)
lStartTime: INTEGER
lDuration: INTEGER
lEndTime: INTEGER
lAverageSpeed: REAL
lMaxSpeed: REAL
lMaxPower: REAL
lAveragePower: REAL
lMaxCadence: REAL
lAverageCadence: REAL
lMaxAltitudeDif: REAL
lAverageHR: INTEGER
lMaxHR: INTEGER
lTrigger: VARCHAR(255)
lDistance: REAL
lFinal: INTEGER
lCalories: INTEGER
lGainedAltitude: REAL
lLastModified: DATE
Record
rowId: VARCHAR(255)
recLapId: VARCHAR(255)
recTimeStamp: INTEGER
recHeartRate: INTEGER
recCadence: REAL
recDistance: REAL
recPower: REAL
recSpeed: REAL
recAltitude: REAL
recLatitude: REAL
recLongitude: REAL
recIsBreak: INTEGER
lLastModified: DATE
Solos Database Schema