gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Gnumed-devel] re : clin_narrative integrity constraint


From: catmat
Subject: [Gnumed-devel] re : clin_narrative integrity constraint
Date: Sun, 20 Feb 2005 22:59:54 +1100
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20041231

"clin_narrative_fk_encounter_key" unique, btree (fk_encounter, narrative, soap_cat)

this constraint would block someone entering a health issue with an identically autogenerated narrative,
or say  dealing with
hypertension and diabetes in one encounter with "script; routine checkup" for both.

would it be better as (fk_encounter, fk_episode, narrative, soap_cat) ?






reply via email to

[Prev in Thread] Current Thread [Next in Thread]