Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shapper
Constraint Violating Yak Guru
450 Posts |
 Posted - 2007-01-23 : 11:21:44
|
| Hello,I am trying to create a simple FAQ system which supports multiple categories and is multi language.I am having some trouble in creating my database structure.Could someone help me out with this or point me to some articles in internet?Basically I have 2 tables: FAQ and FAQLocalized with the following fields:[FAQ] > FAQId, FAQType[FAQLocalized] > FAQLocalizedId, FAQId, FAQQuestion, FAQAnswer, FAQCulture I am not sure if this is the best way. I started with SQL just sometime ago so I am not sure about my structure.Thanks,Miguel |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-23 : 12:01:15
|
| That looks fine, but you should probably make one change.Add a tables for FAQType and FAQCulture, so it would be like this[FAQType] > FAQTypeId, FAQType, other type columns as necessary[FAQCulture] > FAQCultureId, FAQCulture, other culture columns as necessary[FAQ] > FAQId, FAQTypeId[FAQLocalized] > FAQLocalizedId, FAQId, FAQQuestion, FAQAnswer, FAQCultureId |
 |
|
|
|
|
|
|
|
FAQ System