| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | David Fetter <david(at)fetter(dot)org> |
| Cc: | Gregory Stark <stark(at)enterprisedb(dot)com>, Edward Stanley <Edward(dot)Stanley(at)mcs(dot)vuw(dot)ac(dot)nz>, 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 16:00:36 |
| Message-ID: | 45F81C24.9010405@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
David Fetter wrote:
> On Wed, Mar 14, 2007 at 02:28:03PM +0000, Gregory Stark wrote:
>> "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.
>
> What's in the symptom table is up to the doctor.
Surely the point is that for "high temperature" I need a temperature
value, whereas for "tooth decay" I'll want a tooth number (or whatever
they use). Which brings us back to where we started...
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Csaba Nagy | 2007-03-14 16:01:49 | Re: My honours project - databases using dynamically attached entity-properties |
| Previous Message | David Fetter | 2007-03-14 15:50:50 | Re: My honours project - databases using dynamically attached entity-properties |