[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Medication tweaks
From: |
Jim Busser |
Subject: |
Re: [Gnumed-devel] Medication tweaks |
Date: |
Mon, 20 Jun 2011 20:44:25 -0700 |
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])
- Re: [Gnumed-devel] Medication tweaks, (continued)
- Re: [Gnumed-devel] Medication tweaks, Jim Busser, 2011/06/22
- Re: [Gnumed-devel] Medication tweaks, Karsten Hilbert, 2011/06/22
- Re: [Gnumed-devel] Medication tweaks, Jim Busser, 2011/06/22
- Re: [Gnumed-devel] Medication tweaks, Karsten Hilbert, 2011/06/22
- Re: [Gnumed-devel] Medication tweaks, Jim Busser, 2011/06/20
- Re: [Gnumed-devel] Medication tweaks, Karsten Hilbert, 2011/06/21
- Re: [Gnumed-devel] Medication tweaks,
Jim Busser <=
- Re: [Gnumed-devel] Medication tweaks, Karsten Hilbert, 2011/06/21
Re: [Gnumed-devel] Medication tweaks, Karsten Hilbert, 2011/06/24