[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] PHP to drug db
From: |
Hilmar Berger |
Subject: |
Re: [Gnumed-devel] PHP to drug db |
Date: |
Wed, 23 Oct 2002 19:03:04 +0200 (CEST) |
> I would think to suggest some changes to gmdrugs.sql:
>
> 1/ a link_dose_component table to specify the dose for each component
> of a compound drug.
absolutely yes.
> 2/ link_class_adverse_effect, link_class_warning,
> link_class_information.
>
> OTOH, would it be
> better to unify drug_class and generic_drug, to avoid doubling all the
> linktables. This would also allow drug-tp-class interactions, which,
> IMHO, are far more common than drug-to-drug interactions. (I know I have
> suggested this before, but nobody objected....)
AMIS has both drug-to-class and drug-to-drug interactions, so we should
need this.
> 3/ normalise out the PBS authority warnings (as many are shared between
> drugs, such as the statins and the bisphosphonates)
these are certainly country specific,
> 4/ drug_routes appears to be 'orphaned': a link in product?
yes, but I would prefer a link in generic drug, since a product may have
different parts (say creme + suppository).
> 5/ a product can have several manufacturers, but only one brandname?
> surely brandname should be in link_product_manufacturer.
I would prefer putting brandname in product, as I don't see how different
manufacturers will have *exactly* the same product (think of adjuvants,
package size, even allowed indications can be different for same
active substance)
Hilmar
- [Gnumed-devel] Back on board, Ian Haywood, 2002/10/19
- Re: [Gnumed-devel] Back on board, Horst Herb, 2002/10/19
- [Gnumed-devel] PHP to drug db, Ian Haywood, 2002/10/19
- Re: [Gnumed-devel] PHP to drug db, Karsten Hilbert, 2002/10/20
- Re: [Gnumed-devel] PHP to drug db, Ian Haywood, 2002/10/23
- Re: [Gnumed-devel] PHP to drug db, Horst Herb, 2002/10/23
- Re: [Gnumed-devel] PHP to drug db,
Hilmar Berger <=
- Re: [Gnumed-devel] PHP to drug db, Horst Herb, 2002/10/23
- Re: [Gnumed-devel] PHP to drug db, Elizabeth Dodd, 2002/10/26
- Re: [Gnumed-devel] PHP to drug db, Ian Haywood, 2002/10/25
- Re: [Gnumed-devel] PHP to drug db, Hilmar Berger, 2002/10/25
- Re: [Gnumed-devel] PHP to drug db, Karsten Hilbert, 2002/10/24
- Re: [Gnumed-devel] PHP to drug db, Ian Haywood, 2002/10/25
- Re: [Gnumed-devel] PHP to drug db, Elizabeth Dodd, 2002/10/26
- Re: [Gnumed-devel] PHP to drug db, Horst Herb, 2002/10/26
- Re: [Gnumed-devel] PHP to drug db, Karsten Hilbert, 2002/10/26
- Re: [Gnumed-devel] PHP to drug db, Karsten Hilbert, 2002/10/26