I am looking to build an article management system for a sports related site. I have some questions about to build an index system that will be flexible enough to handle the needs of the site. I need some basic help on to make sure I am not overlapping any key content areas and that I am using the mysql database efficiently. Here is my plan so far.
For the site I would have a master category area with less than 10 subcategory (not sure how many yet?). Then the master category would be broken down into sub categories and then finally to a unique area which I will call a content index. So I would have a category -> subcategory -> content_index
Then from there each content index would contain articles, polls, standings, etc
My idea for how this would work would be to have the content index, which would then link to a article key and then to article objects. So it would look like this:
Content index -> article_key -> article_objects
The content index would link to various articles by article keys and then the articles are made up of various objects that are linked to the article-by-article keys. I have never done something like this and I would like to have a scalable design. Also I am not sure on how many tables I should be setup for this article database? I will be using php4 and mysql 3.23.26 Please let me know if I can help explain anything in more detail or if there are any good articles that tackle a similar issue to this. Thanks for all your help,
Bart
