[Top][All Lists]

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

Re: [Gnumed-devel] More lab test result considerations: groupings

From: Luke Kenneth Casson Leighton
Subject: Re: [Gnumed-devel] More lab test result considerations: groupings
Date: Wed, 11 Aug 2010 10:59:37 +0100

On Wed, Aug 11, 2010 at 1:48 AM, Jim Busser <address@hidden> wrote:
> On 2010-08-10, at 3:59 AM, lkcl wrote:
>> ... or, a *separate* double-fk table is created which preserves the
>> hierarchy (pk, fk_lab_request, fk_test_result).
> or
>> or, clin.test_result has a
>> fk_lab_request added to it.  both of these would be sufficient to preserve
>> the OBR-OBX hierarchy which at present is served by creating new encounters.
> maybe this second one would be better?

 it would certainly be easier to code.  the double-fk table trick is
only usually deployed in many-to-many relationship situations
(multi-selection drop-down lists for example).  i don't thiiink
there's a need for many-to-many OBR-OBX linking, here, but i cannot
speak for other importers.  given that the situation was expected to
merely drop the inter-relationship entirely (as you can see from the
LabImporters wiki page saying things like "add the data to
clin.test_result regardless")....


reply via email to

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