How to create a database for a star rating?

Question

Yii

I have tables: carton, movie, anime each has movies. I need to put a rating for each film and also determine the average rating of one film, how will the structure of this star rating be?? how to connect them? help on database structure, i used krajee-star rating

Answer 1

Or store the rating value and the number of voters for each film in the rating column and calculate the first one and increment the second
film: id | name | type | rating | vote_num
or have a separate table where to store all the votes and sum up
film: id | name | type
vote: id | user_id | film_id | rating