Re: database design question? best practise
From: Stefan Oedenkoven <stefan-oedenkoven_at_gmx.de>
Date: Thu, 1 Jul 2004 16:06:38 +0200
Message-ID: <2kik33F2pu4cU1_at_uni-berlin.de>
Date: Thu, 1 Jul 2004 16:06:38 +0200
Message-ID: <2kik33F2pu4cU1_at_uni-berlin.de>
Hi Ben,
try this . you don't need LanguageID in references in more than one table....
|languages: | ----------------|
|languageID |
|name |
|newsCategories:|
----------------|
|newsCategorieID|
|description (may be in english?)
|newsCategorySub:|
----------------
|newsCategorieSubID
|FKnewsCategorieID
|FKlanguageID
|name (name of the category in the actual language)
|news:
---------------- |newsID |FKnewsCategorieSubID |name |text
regards,
Stefan
Received on Thu Jul 01 2004 - 16:06:38 CEST