Re: My honours project - databases using dynamically attached entity-properties - Mailing list pgsql-hackers

"David Fetter" <david@fetter.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