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: 493
        
database
|best-practices
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