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

[Luke Kenneth Casson Leighton]

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")....

l.