Re: [Gnumed-devel] Medication tweaks

[Jim Busser]

On 2011-06-20, at 5:38 AM, Karsten Hilbert wrote:

>> what is the table structure?
> 
>       
> http://publicdb.gnumed.de/~ncq/gnumed/schema/gnumed_v15/gnumed-schema.html#ref.schema
> 
>       -> ref.consumable_substance
>       -> ref.branded_drug
>       -> ref.lnk_substance2brand

I am also further wondering the best way to populate a GNUmed database with 
multiple Brand drugs. Since it is possible that a single

        ref.consumable_substance

could be re-used in multiple different commercial products (say, where any one

        description,
        amount,
        unit

as a unique combination is nevertheless found non-uniquely in

        one or more "proprietary" manufacturers' products, and/or
        one or more "generic" manufacturers' products

therefore is it saner to maybe populate a GNUmed database as follows:

- first, with all values which need to go into

        ref.consumable_substance

- second, with all values of

        ref.branded_drug

each of which requires a unique description, and

- third, to create the links to

        ref.lnk_substance2brand

which would require to lookup a pk for each component substance identified by

        (description, amount, unit [ignoring ATC])