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.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 FAQ System

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

Go to Top of Page
   

- Advertisement -