[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] PHP to drug db
From: |
Ian Haywood |
Subject: |
Re: [Gnumed-devel] PHP to drug db |
Date: |
Fri, 25 Oct 2002 03:28:26 -0400 |
User-agent: |
Mutt/1.3.28i |
On Wed, Oct 23, 2002 at 05:16:10PM +0200, Karsten Hilbert wrote:
> > 1/ a link_dose_component table to specify the dose for each component
> > of a compound drug.
> Shouldn't the dose of the component be specified in the same
> place where the component itself is specified ? After all that
> dosage is unique to this drug (= combination of components) ?
The problem is some compounds have different doses, viz
"Panadeine" = paracetamol 500mg, codeine 8mg
"Panadeine Forte" = paracetamol 500mg, codeine 30mg
However, we still want to have the concept of the compound, irrespective of
dose,
to assign properties such as indications, etc. to it.
Another solution is to make product.dose and product.unit into arrays, agreeing
the
order is the alphabetical order of the constituents. (so codeine first in the
example above)
Of course, in the USA paracetamol ("acetoaminophen") would be
first....
Any other suggestions?
Ian
pgpdBT32QPm3i.pgp
Description: PGP signature
- [Gnumed-devel] PHP to drug db, (continued)
- [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, 2002/10/23
- 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 <=
- 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