Re: [Gnumed-devel] gmdrugs structure

[Hilmar Berger]

On Wed, 20 Nov 2002, Karsten Hilbert wrote:

> > should be part of the standard gnumed drug database, on the other hand
> > these tables can be just ignored by a client running in a different
> > country.  
> Or one could split the SQL into gmdrugs-generic.sql and
> gmdrugs-regulations-*.sql which would, of course,
> live in country/specific/*/ and which would be selected upon
> database configuration.
That is the best idea, I guess - that way we have cleanly separated
tables. 

> >  a) the substance itself (i.e. active substance, adjuvant or whatever,
> > e.g. paracetamol, fentanyl etc.). This entity  has a name and belongs
> > to one class (e.g. NSAID). I might be linked to further information
> Depending on the crispness of the definition it may belong to
> more than one class (pain killer + antiphlogistic,
> antiarrythmic + anaesthetic).
That depends on the classification. In ATC, every substance has exactly
one class. It can have a unlimited number of indications, though.
 
> >  b) the specific form of appearance of substances defined by formulation,
> > (i.e. tablet, solution etc.), amount of drug, adjuvants etc. This is IMHO
> [...]
> > level without being ambiguous ('preparation' ?).
> Isn't this a "drug" (as in German Medikament vs. Stoff) while
> a) would be "substance" ?
Yes, I guess that's the name I was looking for :).
 
Hilmar