Discussion: Normalization
Afficher un message
Vieux 19/09/2007, 15h18   #3
Peter H. Coffin
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: Normalization

On Tue, 18 Sep 2007 22:26:34 +0200, Michael Fesser wrote:
> A third idea: Add a field 'lang' for storing a language code (2 or 5
> chars). Make that the primary key together with the DestID field. Then
> store one record for each language.


This is the right general plan for the OP.

Though for some reason, my brain is nagging me to say "Nope, primary key
on DestID only, add another index for the DestID plus LangID" but I
can't remember why.

--
6. I will not gloat over my enemies' predicament before killing them.
--Peter Anspach's list of things to do as an Evil Overlord
  Réponse avec citation
 
Page generated in 0,05935 seconds with 9 queries