Changes between Version 8 and Version 9 of statusdatabase

Timestamp:

Aug 11, 2014, 10:42:14 AM (10 years ago)

Author:

tec

Comment:

--

statusdatabase

@@ -96 +96 @@
 ||  || sensor_type || Text (variable length) ||  Required  ||  ||
 
-
+A 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.