Jump to content

Archived

This topic is now archived and is closed to further replies.

chinni

Db design question

Recommended Posts

Hello everybody,

 

Question: topic, under that sub-topics,under that articles

 

For each topic there could be some 20 sub-topics and for each subtopic there could be some 1000 or 2000 or more articles.

 

For example, if i have a topic 1 and under that sub-topic1, sub-topic2, sub-topic3, sub-topic4 and if have 1000 or 2000 articles for each subtopic, then i cant imagine the size now;-)

 

So, could you please tell me the best idea how i can get the design.

 

But, this is true: For each topic, there are many sub-topics and for each sub topic there are many articles.

 

My previous design was: 3 tables-[topic(topic_id, topic_name), subtopic(subtopic_id, topic_id, subtopic_name), articles(article_id, subtopic_id, article_name, article_content)

 

How could you suggest me now??each topic a table or some thing like that.

 

A nice explanation would help me more.

 

Thank you so much

Share this post


Link to post
Share on other sites

u can do that like this:

u create a table

than create groups

than insert the articles to this groups

u can find group example in mysql manual

see u later...

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.