Changes between Version 6 and Version 7 of statusdatabase

Timestamp:

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

Author:

tec

Comment:

--

statusdatabase

@@ +1 @@
+[[TracGuideToc]]
+
 == Structure of new ARSF Database ==
 
@@ -75 +77 @@
 ||  || progress || Text (variable length) ||  Required  || Value must be in the progress table. ||
 ||  || notes || Text (variable length) ||    ||  ||
+
+The priorities table contains the priority name, the numeric value of the priority and the friendly description of the priority.
+||||||||||||= priorities Table =||
+||= Key =||= Field Name =||= Value Type =||= Constraints =||= Notes =||
+|| Primary Key || priority_name || Text (variable length) ||  Required  || Value for priority. (There should be a valid CSS class to match this) ||
+||  || value || Integer(2 Bytes) ||  Required  || Integer value for the priority. Not sure what this is used for. ||
+||  || description || Text (variable length) ||  Required  || Friendly description of the priority. ||
+
+The progress table contains the progress name, the numeric value of the progress and the friendly description of the progress.
+||||||||||||= progress Table =||
+||= Key =||= Field Name =||= Value Type =||= Constraints =||= Notes =||
+|| Primary Key || progress_name || Text (variable length) ||  Required  || Value for progress. (There should be a valid CSS class to match this) ||
+||  || value || Integer(2 Bytes) ||  Required  || Integer value for the progress. Not sure what this is used for. ||
+||  || description || Text (variable length) ||  Required  || Friendly description of the progress. ||
+
+The sensors table contains the sensor and the type of sensor it is. E.g the sensor name would be "Fenix" and type would be "Hyperspectral".
+||||||||||||= sensors Table =||
+||= Key =||= Field Name =||= Value Type =||= Constraints =||= Notes =||
+|| Primary Key || sensor_name || Text (variable length) ||  Required  ||  ||
+||  || sensor_type || Text (variable length) ||  Required  ||  ||
+
+
+
+
+
+
+
+
+