Changes between Version 8 and Version 9 of statusdatabase


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

--

Legend:

Unmodified
Added
Removed
Modified
  • statusdatabase

    v8 v9  
    9696||  || sensor_type || Text (variable length) ||  Required  ||  ||
    9797
    98 
     98A some views have been created for commonly used queries. (A view is basically a "virtual" table based on an SQL query.) A view called status_page displays all the data for the status page. That view uses another view called flight_progress which is a query that joins a few table and then joins that to a pivot table (basically a query that converts rows to columns). The flight_progress pivot table had to be hard coded so whenever a new sensor is added the view will need to be updates, I intend to automate recreating the view but in case it can't be done it shall at least be documented.
    9999
    100100