Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams

[Jim Busser]

On 2011-01-04, at 12:04 AM, Karsten Hilbert wrote:

>> --> then create links between
>> 
>>      branded-drug
>>      consumable.substances
>> 
>>      where branded-drug keyed to source table links to
>>              consumable.substances keyed to source table
> 
> Sounds about right.

I am hoping:

1) that I can cleanly populate ref.branded-drug from my FreeDiams hybrid output 
table

2) that substances prescribed in GNUmed can keep a linkage (even if indirect) to

        ref.branded-drug.pk

**********
re #1

Canadian brand names are sometimes (but not always) specific to their drug 
strengths, for example the second manufacturer names all strengths ""ZYPREXA 
ZYDIS"
        
        "02229250"|"ZYPREXA  -2.5MG"|"N05AH03"|"2.5"|"MG"
        "02229269"|"ZYPREXA - 5MG"|"N05AH03"|"5"|"MG"
        "02229277"|"ZYPREXA  -7.5MG"|"N05AH03"|"7.5"|"MG"

        "02243086"|"ZYPREXA ZYDIS"|"N05AH03"|"5"|"MG"
        "02243087"|"ZYPREXA ZYDIS"|"N05AH03"|"10"|"MG"
        "02243088"|"ZYPREXA ZYDIS"|"N05AH03"|"15"|"MG"

conflicts with

>       From: Karsten Hilbert <address@hidden>
>       Date: January 2, 2011 6:15:10 AM PST
>       To: address@hidden
>       Subject: Re: [Gnumed-devel] Re: GNUmed and FreeDiams
>       ...
>       Brands across different strengths must have (ever so
>       slightly) differing names, say
>               "MetoPharm comp 100/12.5"
>               "MetoPharm comp 100/25"

why, in branded-drugs, do we need UNIQUE (description, preparation) meaning 
UNIQUE (brand_name, form) ?

**********
re #2

>       From: Karsten Hilbert <address@hidden>
>       Date: January 2, 2011 6:15:10 AM PST
>       To: address@hidden
>       Subject: Re: [Gnumed-devel] Re: GNUmed and FreeDiams
>       ...
>               ... is there some way that the addition of a
>               substance to a patient drug list would keep resolvable the
>               [specific-to-strength] external_code? 
> 
>       I am not sure I follow this question.


My question "is there some way" is maybe better understood by ignoring 
[specific-to-strength] …  In table clin.substance_intake, there is a warning on 
column

        fk_substance    (FKEY ref.consumable_substance.pk)

which warns

        DO NOT TRY TO USE THIS TO FIND OUT THE BRAND. IT WILL BE WRONG.

is it wrong because the reference substance may have been linked-to multiple 
brands, and therefore is unable to completely resolve which one?

*But* the column ref.lnk_substance2brand.pk *will* resolve it --- provided the 
user *bothered* to specify/distinguish the Brand, right?

-- Jim