Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams

[Karsten Hilbert]

On Tue, Jan 04, 2011 at 01:56:20PM -0800, Jim Busser wrote:

> > The meaning of the
> > 
> > clin.substance_intake.fk_substance
> > -> ref.consumable_substance.pk
> >  -> ref.lnk_substance2brand.fk_substance
> >   -> ref.lnk_substance2brand.fk_brand
> >    -> ref.branded_drug.pk
> > 
> > chain is
> > 
> >     those are the registered-with-GNUmed brands containing
> >     the substance the patient happens to be taking
> 
> … giving a way to offer a user, for any
> 
>       substance, strength/amount, unit
> 
> a list of Brands that provide that
> 
>       substance, strength/amount, unit

Yes, given a substance (whether derived from

        clin.substance_intake.fk_substance or from
        ref.consumable_substance.description or some other means
)

the above chain would indeed allow to show brands containing
that unit-ed amount of said substance in a certain form.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346