[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams
From: |
Jim Busser |
Subject: |
[Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams |
Date: |
Mon, 03 Jan 2011 15:18:21 -0800 |
Whoa! Where did the v15 drug-related tables go to…
ref.table.lnk-substance2brand
clin.table.active-substance
ref.table.consumable-substance
ref.table.branded-drug
In the meantime, I had been trying to figure out how to populate the above
tables in their last known form…
- a source file could usefully (?) contain, where brand 2 is a combo drug,
something like
brand1name, +- brand1atc, external_code, external_code_type, substance1Name,
substanceStrength, substanceUnits, +- substanceATC
brand2name, +- brand1atc, external_code, external_code_type, substance1Name,
substanceStrength, substanceUnits, +- substanceATC
brand2name, +- brand1atc, external_code, external_code_type, substance2Name,
substanceStrength, substanceUnits, +- substanceATC
--> from this, we could populate the table
ref.consumable.substances
with
SELECT DISTINCT substanceName, strength, units
and then update (where substanceATC was available in source)
UPDATE ref.consumable.substances
SET atc…
--> then populate the table branded-drug
SELECT DISTINCT brandName, brandATC, external_code, external_code_type
--> then create links between
branded-drug
consumable.substances
where branded-drug keyed to source table links to
consumable.substances keyed to source table
?
- Re: [Gnumed-devel] Re: GNUmed and FreeDiams, (continued)
- Re: [Gnumed-devel] Re: GNUmed and FreeDiams, Jim Busser, 2011/01/01
- Re: [Gnumed-devel] Re: GNUmed and FreeDiams, Jim Busser, 2011/01/01
- Re: [Gnumed-devel] Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/02
- Re: [Gnumed-devel] Re: GNUmed and FreeDiams, Jim Busser, 2011/01/02
- [Gnumed-devel] GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/03
- [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/03
- [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams,
Jim Busser <=
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Eric Maeker, 2011/01/03
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/04