[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Re: FreeDiams' LK_MOL_ATC
Date: Thu, 29 Jul 2010 09:00:36 +0200
User-agent: Mutt/1.5.20 (2009-06-14)

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 (
> >>    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 ;-)

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

[Prev in Thread] Current Thread [Next in Thread]