Check out Grant Acedrex, our featured variant for April, 2024.

Enter Your Reply

The Comment You're Replying To
Graeme Neatham wrote on Sat, Mar 10, 2012 09:42 AM UTC:

Just a few thoughts about the Likes table:

  • It might be useful to include an ID for the item's creator. I know this can be found by joining through the ItemID but keeping it in this table as well would enable faster queries concerning games inventors. It would also make it easier to stop creators rating their own games (UserID != CreatorID)
  • Will a user be able to revise their ratings? If so the table will need a timestamp field and possibly either a binary current/superseded field or a status field. Or previous ratings might have their own table - LikesHistory


Edit Form

You may not post a new comment, because ItemID Cookies does not match any item.