Database best practices

Posted by user270797 on Stack Overflow See other posts from Stack Overflow or by user270797
Published on 2010-05-27T06:02:07Z Indexed on 2010/05/27 6:11 UTC
Read the original article Hit count: 424

Filed under:
|

I have a table which stores comments, the comment can either come from another user, or another profile which are separate entities in this app.

My original thinking was that the table would have both user_id and profile_id fields, so if a user submits a comment, it gives the user_id leaves the profile_id blank

is this right, wrong, is there a better way?

© Stack Overflow or respective owner

Related posts about database

Related posts about best-practices