Well to answer that I've found the database file held on your PC and taken a look with the help of the SQLiteManager extension for Firefox.
Makes for very interesting reading. There's fields for measuring oil levels, brake wear and even measurements held in the trip computer.
makes interesting reading for fellow geeks
Makes for very interesting reading. There's fields for measuring oil levels, brake wear and even measurements held in the trip computer.
Code:
CREATE TABLE [AccelerationBandData]
(
[JourneyId] integer NOT NULL,
LowerSpeed integer NOT NULL,
UpperSpeed integer NOT NULL,
Acceleration FLOAT NOT NULL,
Deceleration FLOAT NOT NULL,
PRIMARY KEY ([JourneyId],[LowerSpeed], [UpperSpeed])
/* Foreign keys */
FOREIGN KEY (JourneyId) REFERENCES Journey(Id)
);
CREATE TABLE DatabaseVersion (SequenceNumber INTEGER NOT NULL PRIMARY KEY, Description TEXT NOT NULL, Signature VARCHAR(64) NOT NULL, DateAdded FLOAT);
CREATE TABLE [DrivingCategoryScore] (
JourneyId integer NOT NULL,
JourneyCategoryId integer NOT NULL,
Score numeric(50) NOT NULL,
/* Foreign keys */
FOREIGN KEY (JourneyId) REFERENCES Journey(Id)
);
CREATE TABLE [GearData] (
[JourneyId] INTEGER NOT NULL,
[Gear] INTEGER NOT NULL,
[AverageAcceleration] FLOAT NOT NULL,
[AverageDownshiftRPM] FLOAT NOT NULL,
[AverageUpshiftRPM] FLOAT NOT NULL,
[PercentUsage] FLOAT NOT NULL, AverageDeceleration FLOAT NULL,
PRIMARY KEY ([JourneyId],[Gear])
/* Foreign keys */
FOREIGN KEY (JourneyId) REFERENCES Journey(Id)
);
CREATE TABLE [Journey] (
[Id] integer PRIMARY KEY NOT NULL,
[UserLocalId] varchar(36) NOT NULL,
[VehicleLocalId] varchar(36) NOT NULL,
[StartTime] float NOT NULL,
[StartDate] float NOT NULL,
[EndTime] float NULL,
[StartOdometer] float NULL,
[EndOdometer] float NULL,
[EcoIndex] int NULL,
[EcoIndexServerId] varchar(36) NULL,
[EcoIndexServerAlgorithmVersion] varchar(36) NULL,
[PricePerUnit] float NULL,
[FuelConsumed] float NULL,
[JourneyType] varchar(16) NULL,
[ComputedServerFuelConsumption] FLOAT NULL,
[ConsumptionUnit] VARCHAR(64) NULL,
[TripDataCount] INTEGER NOT NULL
, OilLevelStatus INTEGER NULL);
CREATE TABLE [KeyOffData] (
[JourneyId] INTEGER NOT NULL,
[DistanceUnit] INTEGER NULL,
[DistanceToService] INTEGER NULL,
[DistanceToServiceValidData] INTEGER NULL,
[FuelLevel] INTEGER NULL,
[FuelLevelFailSts] INTEGER NULL,
[CNGFillingTank] INTEGER NULL,
[AutonomyDistance] INTEGER NULL,
[AutonomyDistanceValidData] INTEGER NULL,
[OilLevelIndication] INTEGER NULL,
[OilLifeSts] INTEGER NULL,
[EngineWaterLevel] INTEGER NULL,
[BrakeFluidLevelSts] INTEGER NULL,
[BrakePadWearSts] INTEGER NULL,
[TyreInflationState] INTEGER NULL,
[TyrePressureSystemFailSts] INTEGER NULL,
[DPFStatus] INTEGER NULL,
/* Foreign keys */
FOREIGN KEY (JourneyId) REFERENCES Journey(Id)
);
CREATE TABLE [TripAComputerData] (
[JourneyId] integer NOT NULL,
[DateTime] float NOT NULL,
[PartialOdometer] float NULL,
[AverageSpeed] float NULL,
[AverageFuelConsumption] float NULL,
[EventType] INTEGER NOT NULL,
[DistanceUnit] VARCHAR(10) NOT NULL
);
CREATE TABLE TripData (
JourneyId integer NOT NULL,
"DateTime" float NOT NULL,
EngineSpeed float NOT NULL,
VehicleSpeed float NOT NULL,
InstantaneousFuelConsumption float NOT NULL,
AverageFuelConsumption float NOT NULL,
/* Foreign keys */
FOREIGN KEY (JourneyId) REFERENCES Journey(Id)
);
CREATE TABLE TripStatusData (
JourneyId integer NOT NULL,
"DateTime" float NOT NULL,
ExternalTemperature float,
CompressorSts smallint,
/* Foreign keys */
FOREIGN KEY (JourneyId) REFERENCES Journey(Id)
);
makes interesting reading for fellow geeks