From: | <operationsengineer1(at)yahoo(dot)com> |
---|---|
To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
Cc: | danmcb <danielmcbrearty(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: advice on setting up schema sought |
Date: | 2006-04-11 19:07:54 |
Message-ID: | 20060411190754.86197.qmail@web33307.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
--- Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
> On Mon, Apr 10, 2006 at 22:30:47 -0700,
> operationsengineer1(at)yahoo(dot)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.
something like so...
t_base_text
text_id (pkey)
language_id (fkey)
base_text (text)
t_language
language_id (pkey)
language (text)
t_translations
translations_id (pkey - composite of text_id and
language_id with a marker such as "_" inbetween.
otherwise 1 and 11 ("111") can be confused with 11 and
1 ("111"). unless someone has a better idea (which
they likely do).
translation (text)
would this be an option?
Bruno, do you even need a translations table?
couldn't you just use...
t_text
text_id (pkey)
is_base (bool)
text (text)
if the base text is all in one language, then you
wouldn't even need the boolean (as long as that rule
sticks, anyway).
is there a reason one setup is more compelling than
another?
tia...
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | operationsengineer1 | 2006-04-11 19:54:58 | Re: Curses interface |
Previous Message | Andre Majorel | 2006-04-11 18:58:07 | Curses interface |