Changes between Version 5 and Version 6 of statusdatabase

Timestamp:

Aug 11, 2014, 10:17:36 AM (10 years ago)

Author:

tec

Comment:

--

statusdatabase

@@ -5 +5 @@
 * Move project_flights.priority to flights.priority ?
 * Remove sensor_status.id primary key and use the submit_time as primary key.
+* In sensors add a boolean to add the logic for "display on status page" therefore in theory we could store other sensor data and it would not be added to another column on the status page.
+* Rename sensor_status.sensor_id to Rename sensor_status.flight_id
+* Make primary ticket nullable?
+* Make sensor_status.username nullable? check data first
+* Go through and look for reasonable defaults for things.
 
 
@@ -49 +54 @@
 ||  || area || Text (variable length) ||  Required  ||  ||
 
+The flight_sensors table contains a row for every sensor that is used on the flight. Store information about how many flight-lines are flown for that sensor and contains the time it has taken to complete the latest delivery check, and time it has taken to complete the processing of the flight sensor data.
+||||||||||||= flight_sensors Table =||
+||= Key =||= Field Name =||= Value Type =||= Constraints =||= Notes =||
+|| Primary Key || id || Integer(4 Bytes) ||  Required  || Value is automatically generated. ||
+||  || flight_id || Integer(4 Bytes) ||  Required  || Value is the flight id from the flights table. ||
+||  || sensor_name ||  ||  Required  || Name of the sensor used, must be in the sensors table ||
+||  || priority ||  ||  Required  || Processing priority of the data, must be in the processing table. ||
+||  || priority_offset || Integer(2 Bytes) ||    || Not sure what this is used for ||
+||  || number_of_flightlines || Integer(2 Bytes) ||    ||  ||
+||  || completion_time || Real (variable precision 4 Bytes) ||    ||  ||
+||  || delivery_check_time || Real (variable precision 4 Bytes) ||    ||  ||
 
-
-
-
+The sensor_status page contains all the information about the processing status of the data. Essentially it is kind of an audit trail sort of showing who's done what with the data.
+||||||||||||= sensor_status Table =||
+||= Key =||= Field Name =||= Value Type =||= Constraints =||= Notes =||
+|| Primary Key || id || Integer(4 Bytes) ||  Required  || Value is automatically generated. ||
+||  || sensor_id || Integer(4 Bytes) ||  Required  || Value is the flight_id from the flight_sensors table. ||
+||  || username || Text (variable length) ||  Required  ||  ||
+||  || submit_time || Timestamp ||  Required  || Should be omitted from the insert query or explicitly told to use the DEFAULT value as this is the current time / insert time. ||
+||  || progress || Text (variable length) ||  Required  || Value must be in the progress table. ||
+||  || notes || Text (variable length) ||    ||  ||