Best solution for a comment table for multiple content types
Posted
by KRTac
on Stack Overflow
See other posts from Stack Overflow
or by KRTac
Published on 2010-04-12T19:31:17Z
Indexed on
2010/04/12
19:32 UTC
Read the original article
Hit count: 359
I'm currently designing a comments table for a site I'm building. Users will be able to upload images, link videos and add audio files to the profile.
Each of these types of content must be commentable. Now I'm wondering what's the best approach to this.
My current options are: 1. to have one big comments table and a link tables for every content type (comments_videos, ...) with comment_id and _id. 2. to have comments separated by the type of content their for. So each type of content would have his own comments table with the comments for that type.
© Stack Overflow or respective owner