[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Re: FreeDiams' LK_MOL_ATC
From: |
Jim Busser |
Subject: |
Re: [Gnumed-devel] Re: FreeDiams' LK_MOL_ATC |
Date: |
Wed, 28 Jul 2010 15:13:33 -0700 |
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
Re: [Gnumed-devel] Re: FreeDiams' LK_MOL_ATC, Eric MAEKER, 2010/07/29