Changes between Version 6 and Version 7 of statusdatabase


Ignore:
Timestamp:
Aug 11, 2014 10:36:32 AM (5 years ago)
Author:
tec
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • statusdatabase

    v6 v7  
     1[[TracGuideToc]]
     2
    13== Structure of new ARSF Database ==
    24
     
    7577||  || progress || Text (variable length) ||  Required  || Value must be in the progress table. ||
    7678||  || notes || Text (variable length) ||    ||  ||
     79
     80The priorities table contains the priority name, the numeric value of the priority and the friendly description of the priority.
     81||||||||||||= priorities Table =||
     82||= Key =||= Field Name =||= Value Type =||= Constraints =||= Notes =||
     83|| Primary Key || priority_name || Text (variable length) ||  Required  || Value for priority. (There should be a valid CSS class to match this) ||
     84||  || value || Integer(2 Bytes) ||  Required  || Integer value for the priority. Not sure what this is used for. ||
     85||  || description || Text (variable length) ||  Required  || Friendly description of the priority. ||
     86
     87The progress table contains the progress name, the numeric value of the progress and the friendly description of the progress.
     88||||||||||||= progress Table =||
     89||= Key =||= Field Name =||= Value Type =||= Constraints =||= Notes =||
     90|| Primary Key || progress_name || Text (variable length) ||  Required  || Value for progress. (There should be a valid CSS class to match this) ||
     91||  || value || Integer(2 Bytes) ||  Required  || Integer value for the progress. Not sure what this is used for. ||
     92||  || description || Text (variable length) ||  Required  || Friendly description of the progress. ||
     93
     94The 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".
     95||||||||||||= sensors Table =||
     96||= Key =||= Field Name =||= Value Type =||= Constraints =||= Notes =||
     97|| Primary Key || sensor_name || Text (variable length) ||  Required  ||  ||
     98||  || sensor_type || Text (variable length) ||  Required  ||  ||
     99
     100
     101
     102
     103
     104
     105
     106
     107
    77108
    78109