Re: [Gnumed-devel] Medication tweaks

[Karsten Hilbert]

On Mon, Jun 20, 2011 at 08:44:25PM -0700, Jim Busser wrote:

> therefore is it saner to maybe populate a GNUmed database as follows:
> 
> - first, with all values which need to go into
> 
>       ref.consumable_substance
> 
> - second, with all values of
> 
>       ref.branded_drug
> 
> each of which requires a unique description, and
> 
> - third, to create the links to
> 
>       ref.lnk_substance2brand
> 
> which would require to lookup a pk for each component substance identified by
> 
>       (description, amount, unit [ignoring ATC])

That's right.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346