The purify db serial_number table the table used for Steven Hiner to know which devices (pairings) are ours and where serial-number / serial (uid) mappings are stored.
Adding group_id to purifydb.serial_numbers will tie together Christi's views. A table called sensor_group is where groups are defined.
So far we have yet to merge DDL scripts that reside in $(gg dbpr) using just the name of the table as the script name into the create-tables.sql script.
AGAIN, the most important table among these is the serial_number table which is what tracks what informs Steve Hiner which serial numbers are ours. Using our API he reads this information and then he sends us the UID mappings for the pairings (hubs) that he will be sending us information on. The serial_number table is then update with the HUB UID values (stored in the serial column.)
The purify db serial_number table the table used for Steven Hiner to know which devices (pairings) are ours and where serial-number / serial (uid) mappings are stored.
Adding group_id to purifydb.serial_numbers will tie together Christi's views. A table called sensor_group is where groups are defined.
So far we have yet to merge DDL scripts that reside in $(gg dbpr) using just the name of the table as the script name into the create-tables.sql script.
AGAIN, the most important table among these is the serial_number table which is what tracks what informs Steve Hiner which serial numbers are ours. Using our API he reads this information and then he sends us the UID mappings for the pairings (hubs) that he will be sending us information on. The serial_number table is then update with the HUB UID values (stored in the serial column.)