-
Articles with Multiple Categories?
I have a news article site and I'm needing some help on how to arrange the database.
On the news article site there will be about 200 categories.
Sometimes Articles will fit into about 80 different categories.
What is the best way to setup a database that has an article that is assigned to 80+ categories?
-
Three tables:
- Articles
- Categories
- ArticleCategories
-
What would your column structure be like in: ArticleCategories
-
ArticleId
CategoryId
It's a table that contains the relationships between the articles and the categories (which is a many-to-many relationship)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Bookmarks