On Thu, 23 Jul 2015, David G. Johnston wrote:
Conditions <- (Permit + Location + Parameter + Frequency + Temporal (from,
until))
Monitoring <- (Condition + Event)
While you may require additional modelling tables to support your user
interface (i.e., picking valid combinations of PeLoPa when creating a new
condition) the fundamental concept is that each permit+location+parameter
combination needs to be monitored during a given period (temporal) at a
given frequency in that period. Every time that combination generates a
number you combine the "Condition" with the event (data + time) and add the
result to the monitoring table.
Active combinations of permits, locations, and parameters can be directly
derived from the conditions table. The temporal fields facilitate history
generation.
David,
This is what I was working to achieve, but did not have the details
straight. I'll ponder this and make sure I set the proper FKs on the
appropriate tables.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
