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



It’s a table that contains the relationships between the articles and the categories (which is a many-to-many relationship)