Tag, comment, rating, etc. database design

Posted by Efe Kaptan on Stack Overflow See other posts from Stack Overflow or by Efe Kaptan
Published on 2009-07-28T16:00:29Z Indexed on 2010/05/15 3:34 UTC
Read the original article Hit count: 319

Filed under:

tag

|

comment

|

rating

|

database

|

design

I want to implement modules such as comment, rating, tag, etc. to my entities. What I thought was:

comments_table -> comment_id, comment_text

entity1 -> entitity1_id, entity1_text

entity2 -> entitity2_id, entity2_text

entity1_comments -> entity1_id, comment_id

entity2_comments -> entity2_id, comment_id

....

Is this approach correct?

© Stack Overflow or respective owner

Related posts about tag

Ubuntu and Windows 8 shared partition gets corrupted

as seen on Super User - Search for 'Super User'
I have a dual boot (Ubuntu 12.04 and Windows 8) system. Both systems have access to an NTFS "DATA" partition which contains all my images, documents, music and some application data like Chrome and Thunderbird Profiles which used by both OS. Everything was working fine in my Dual boot Ubuntu/Windows… >>> More
Removing everything between a tag (including the tag itself) using Regex / Eclipse

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm fairly new to figuring out how Regex works, but this one is just frustrating. I have a massive XML document with a lot of blahblahblah tags. I want to basically remove any and all instances of . I'm using Eclipse and have tried a few examples of Regex I've found online, but nothing works. <description>(… >>> More
How can I 301 redirect domain.com/tag/* to domain.com/blog/tag/*

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am trying to redirect links to domain.com/tag/* to domain.com/blog/tag/* (where * is the actual tag name - eg music so domain.com/tag/music would redirect to domain.com/blog/tag/music) I have been trying but I just can't wrap my head around it. Any help would be appreciated. Thanks >>> More
Rails AtomFeedBuilder Entry :Url option appears in url tag but not in link tag

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I'm using the AtomFeedHelper and everything is working fine except for one feed where I need to link each entry to a URL which is not the default polymorphic_url for the record. Per the documentation I've specified an :url option for the entry. This correctly renders a <url> tag in… >>> More
jQuery: Insert html from "title" tag into a "span" of a H2 tag

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey guys, Say I had the following HTML: <h2>Heading <span></span></h2> <ul> <li><a href="#" title="I am wanting to be in H2!">Something</a></li> <li><a href="#" title="I too am wanting to be in H2!">Something else</a></li> </ul> I… >>> More

Related posts about comment

Database Down error while posting a comment through comment box in facebook iframe application

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have an iframe application. I have comment box functionality. It is displayed well but the problem comes when i click on post iam getting this error: Database Down Sorry, a temporary error has occurred. Please try again. How can i resolve this please help me on this? >>> More
I have a comment model, what to use in my mvc's? @comment, :comment or comment?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a comment model, I've seen examples of using @comment, :comment, comment to reference for the object in MVC? how do I know which is which? Is there a distinction? >>> More
Select Comment with xPath by Comment-Text

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi How can I select the next node after an defined comment? I know the text of the comment and need the next nodes. Best regards Christoph >>> More
How would you organize a large complex web application (see basic example)?

as seen on Stack Overflow - Search for 'Stack Overflow'
How do you usually organize complex web applications that are extremely rich on the client side. I have created a contrived example to indicate the kind of mess it's easy to get into if things are not managed well for big apps. Feel free to modify/extend this example as you wish - http://jsfiddle… >>> More
How would you organize this Javascript?

as seen on Stack Overflow - Search for 'Stack Overflow'
How do you usually organize complex web applications that are extremely rich on the client side. I have created a contrived example to indicate the kind of mess it's easy to get into if things are not managed well for big apps. Feel free to modify/extend this example as you wish - http://jsfiddle… >>> More