The file schema.py
defines the schema used for PyTables, and therefore should be run first.
We'll be creating three tables, according to the data already available in the PostgreSQL server:
-
SensorData - This table will have data from each MAC address, per day
-
minified_raw_data - This sub-table has raw data from the routers