Re: advice on setting up schema sought

On Mon, Apr 10, 2006 at 22:30:47 -0700,
  operationsengineer1@yahoo.com wrote:
>
> Daniel, i'm not sure i totally understand your
> request.  from what i could make of it, though, would
> this workd?
>
> t_text
> text_id (pkey)
> language_id (fkey)
> text
>
> t_language
> language_id (pkey)
> language
>
> the foreign key of the t_text table would reference
> the the pkey (primary key) of the t_language.

In the translation table, you need to make the primary key a composite of
text_id and language_id so that only one unique combination of the two is
allowed.