var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
ERD for a blogging system...
Hey guys, I have to make a blogging system and I have to make the ERD for it and this is what I have so far
Date of Birth
Date Time of Blog
Date Time of Post
Date Time of Comment
I am trying to think of some other things which can be added to the entities I have. The way I have it is:
Each editor can have 1 blog
Each blog can have many posts
Each post can have many comments
Comments can be anonymous (So no username or email required)
Does this seem logical? Also one other thing is im abit confused that the editor table has a date of birth field because it isnt really nessasary to display the date of birth of the editor?
who really cares when an editor was born
what's more important is identifying who wrote a post
also, posts typically have titles, too
as for the comments, how do you know which post a comment refers to?
Thats true... so maybe I need to add another field to relate the posts and comments together but im not sure what do do?
This is what I have so far...
do some research on foreign keys
Originally Posted by uperkurk
your diagram says that editor-makes-post is many-to-many, but are you sure you want to allow a single post to be made by more than one editor?
similarly, your diagram says that post-have-comment is many-to-many, but are you sure you want to allow a single comment to be made on more than one post?