Re: Multilanguage application & database

From: K <kristofvdw_at_matt.es>
Date: 27 Oct 2004 01:53:53 -0700
Message-ID: <ef74fcf7.0410270053.906fa92@posting.google.com>

Here's what I finally came up with:

CREATE TABLE Expressions (
IdExpression NUMBER(5) NOT NULL,
PRIMARY KEY (IdExpression) );

CREATE TABLE Languages (
  IdLanguage NUMBER(2) NOT NULL,
  IdExpression NUMBER(5) NOT NULL REFERENCES Expressions
(IdExpression),

  PRIMARY KEY (IdLanguage) );

CREATE TABLE Translations (
  IdExpression NUMBER(5) NOT NULL REFERENCES Expressions
(IdExpression),

  IdLanguage NUMBER(2) NOT NULL REFERENCES Languages (IdLanguage),   Translation VARCHAR2(2000) NOT NULL,
  PRIMARY KEY (IdExpression, IdLanguage) );

If I have to link an "expression" to another table, I can pass its key without the language (which I get at runtime).

Thanks all for your input!
K Received on Wed Oct 27 2004 - 03:53:53 CDT