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

[Jim Busser]

On 2011-01-04, at 12:10 PM, Karsten Hilbert 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

?