| From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
|---|---|
| To: | "David Fetter" <david(at)fetter(dot)org> |
| Cc: | "Edward Stanley" <Edward(dot)Stanley(at)mcs(dot)vuw(dot)ac(dot)nz>, "Richard Huxton" <dev(at)archonet(dot)com>, "Sean Utt" <sean(at)strateja(dot)com>, "Andrew Hammond" <andrew(dot)george(dot)hammond(at)gmail(dot)com>, <josh(at)agliodbs(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: My honours project - databases using dynamically attached entity-properties |
| Date: | 2007-03-14 14:28:03 |
| Message-ID: | 87k5xjnbm4.fsf@stark.xeocode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"David Fetter" <david(at)fetter(dot)org> writes:
> CREATE TABLE symptom (
> symptom_id SERIAL PRIMARY KEY, /* See above. */
> ...
> );
>
> CREATE TABLE patient_presents_with (
> patient_id INTEGER NOT NULL REFERENCES patient(patient_id),
> symptom_id INTEGER NOT NULL REFERENCES symptom(symptom_id),
> UNIQUE(patient_id, symptom_id)
> );
I'm just glad I don't have your doctor. I hope mine doesn't think symptoms are
all boolean values.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zdenek Kotala | 2007-03-14 14:52:49 | Re: Daylight Saving Time question PostgreSQL 8.1.4 |
| Previous Message | David Fetter | 2007-03-14 14:24:43 | Re: My honours project - databases using dynamically attached entity-properties |