Hi there,
I am building a blog like application where an author creates a post and the users without registering comment on the post the comment will be displayed if and only approved by the author, the help i want is regarding the database table, i have created a table which will hold the records such as name, email, phone, location etc. i have defined a new_id as foreign key to hold the id of the news to which it belongs.
is this the correct way of doing it as the commenting system will be built on many to one relationship, or do i need to create another table to define foreign keys ? how do i achieve it?