70
SQLite Database Structure
The database used in WTP3 consists of the following tables
Logs
The logs table contains data that identies the individual data logging sessions:
ID unique identier for each logging session
Start start date and time of the session
Stop stop data and time of the session if stopped via duration or manual control. “Power o” stop
times are not recorded
Notes Records assistance text, identifying how the log session was started e.g. “Power On”
Datalog
The datalog table contains the variable data congured by the user in datalog.d
LogID unique identier for each logging session, from Logs table
Var variable number of the data, from bg_vars.d
Calibrated calibrated value of the variable at the time of logging
Raw raw, pre-calibrated, value of the variable at the time of logging
Time date and time of the sample
PositionID unique identier for each position log, from Tracks table
Tracks
The tracks table contains a record of positions recorded at 1Hz. Each data log record contains a positionID eld
to allow cross reference of each data log with a position.
PositionID unique identier for each position log
Latitude latitude value in seconds (Degrees * 360000)
Longitude current longitude value in seconds (Degrees * 360000)
Variables
The variables table contains a lookup of the name of each logged variable from bg_vars.d
Var variable number from bg_vars.d
Name name of variable from bg_vars.d (e.g. “TW_speed”)
Alarms
The alarms table contains a history of alarms raised.
AlarmID unique identier for each alarm raised
Var variable number from bg_vars.d
Raised DATETIME
Value real
