| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Schema Help Needed To Get Unstuck |
| Date: | 2015-07-24 01:49:33 |
| Message-ID: | alpine.LNX.2.11.1507231845530.13736@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 23 Jul 2015, Melvin Davidson wrote:
> Does this help?
Melvin,
Yep.
After pondering David's response I recognized my error: I had the permit
table as the center of the relationships when it should be the conditions
table. As you wrote, permits, parameters, and locations all feed the
conditions table (where additional attributes are added), then a row from
that table is added to the monitoring table where quantities and other
attributes are entered.
Sometimes we get so deep in a rut we can't see over the edge and find the
correct path.
Thanks very much,
Rich
| From | Date | Subject | |
|---|---|---|---|
| Next Message | 林士博 | 2015-07-24 03:20:49 | Re: Using the database to validate data |
| Previous Message | Melvin Davidson | 2015-07-24 01:21:17 | Re: Schema Help Needed To Get Unstuck |