Re: [Gnumed-devel] Re: FreeDiams' LK_MOL_ATC

[Karsten Hilbert]

On Wed, Jul 28, 2010 at 03:13:33PM -0700, Jim Busser wrote:

> >> table atc_translation
> > 
> > or maybe
> > 
> > table inn_translation
> > 
> >>    pk integer
> >>    fk_atc integer references (atc.pk)
> >>    language_code varchar
> >>    inn varchar
> >>    molecule_name varchar           (null if not existant or equal to inn)
> 
> except that for any one fk_atc and language code, there may exist more than 
> one
> 
>       molecule_name varchar
> 
> which could be distinguishable by country in cases where countries each used 
> some name different than the language INN

OK, I don't think it makes any more sense for me to comment
unless I can refer to a page detailing which term stands for
what exactly, just like we do for GNUmed :-(

Such a page FreeDiamsTerms could exist on the GNUmed wiki if
trivial creation is desired :-)

BTW: Nothing in the above yet said anything about

        (fk_atc, language_code)

being unique ;-)

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