"David Fetter" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to