What are your opinions on rating systems in this case? I have users submitting ideas. Now other users can rate an idea UP or DOWN. I want to keep track of what user rates what idea, up or down, and want to be able to display this information on a page of my site, ordering by highest rated ideas or lowest rated ideas.
Is this the best way to go about this?
ideaID (auto increment prim key)
ideaText (actual paragraph of text detailing idea)
userID (userid of user that submitted idea)
ratingID (auto increment prim key)
rateType (single boolean, 0 for rate down, 1 for rate up)
userID (userid who rated)
ideaID (ideaid of the idea being rated)
So is this approach the best approach here? The only thing I fear is (definitely hypothetical) what if there are 1 million users, and 1 million ideas, and they each make ratings on many ideas. This means there will be millions of records in the ratings table. Is this still efficient ??