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

[Jim Busser]

On 2010-07-28, at 12:43 PM, Karsten Hilbert wrote:

> On Wed, Jul 28, 2010 at 09:28:13PM +0200, Karsten Hilbert 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


-- Jim