I am creating a home-grown Content Management System (CMS), and could use some advice on how to separate my data.
When this started, I just had "Articles", but as things have grown, I will also have other content like: Interviews, Case Studies, Current Events, Famous Cases, etc.
The way I am building my pages, is to have attributes in my "Articles" table like this:
(**NOTE: In the "body" field I just copy and paste my raw HTML code in there, so all of the content and markup are there.)
Because of how my table is structured, it seems to me that I could not only have "Articles" in this one table, but also "Interviews", "Case Studies", "Current Events", "Famous Cases", "Op-Ed", etc.
So, should I have a separate table for each type of content OR should I add a "Category" field and dump all of the content into just one table?!