Re: [Gnumed-devel] PHP to drug db

[Elizabeth Dodd]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, 25 Oct 2002 17:28, Ian Haywood wrote:
> 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
We are supposed to be going to one international name for each compound to 
avoid all this trouble. Whichever of acetaminophen and paracetamol is the 
winner we should use.
Liz
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iEYEARECAAYFAj26XaIACgkQSpMfinVOW13utQCfeBWULQFsgJzV1yMgCbCuEZsV
aEgAmwbp+xQmVZPbyS2zROmD4u2txDB4
=SXF1
-----END PGP SIGNATURE-----