hamza Posted November 7, 2009 Share Posted November 7, 2009 blog data model is attached please check out my model and tell me anymore modifications and what is a roll of TAGS on a blogs? [attachment deleted by admin] Quote Link to comment Share on other sites More sharing options...
fenway Posted November 18, 2009 Share Posted November 18, 2009 If you're not sure how tags relate to blogs, maybe you shouldn't be embarking on building a blog database? Quote Link to comment Share on other sites More sharing options...
ghostcoder Posted November 19, 2009 Share Posted November 19, 2009 I wouldn't store the article ID in the category table. I would store the cat_id in the articles table along with the article. You might also want to add a timestamp or datetime field to your comments table. Also not sure why you have an archives table. If you want to mark an article as archived, simply create a trigger field in the articles table. (or simply auto archive based on age of the article) You have the date in the articles table already, so you don't need an archives table. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.