we were tasked to create a system in which users have the ability to rate a content using the star rating. i understand that sharepoint has an ootb functionality for the star rating however it just shows the average rating for that particular item. we can use that one to display the average rating but what i need to find out is how to display the rating of the currently logged in user of that paritcular content.
we were thinking of having another list for it which contains that user, the id of the content (from doc library) and the rating. but this doesn't seem feasible because there would be thousands of users and managing the list like that may not be a good practice.
what would be a good approach to store a user rating for a particular doc lib item?