Rating Solution

Scriptcase 9 General
#1

I would like to use your advice on how to approach a voting/rating feature. This is pretty common and nothing new, but it is new to me to implement.

Say I have a 3 tables I could use:

  • USERS
  • ITEMS
  • SCORES

I would build a relationship having ITEMS a main object. Then I would add related record to the SCORES. The SCORES record would hold the RatingAamount (ie. 1, 2 or 3) and UserID. The USERS table would serve for lookup only to fetch UserID. I wonder if there is ant other approach or solution or if I’m no missing something.

Thanks - Arthur