Re: Schema Help Needed To Get Unstuck
От | Rich Shepard |
---|---|
Тема | Re: Schema Help Needed To Get Unstuck |
Дата | |
Msg-id | alpine.LNX.2.11.1507231733220.13736@localhost обсуждение исходный текст |
Ответ на | Re: Schema Help Needed To Get Unstuck ("David G. Johnston" <david.g.johnston@gmail.com>) |
Ответы |
Re: Schema Help Needed To Get Unstuck
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: