Best way to store "Like", "Rate", and others stuff about a movie

Okay Im trying to build a kind of IMDB / TMDB app where user can like, mark as seen, etc... movie. So what the best way to store these datas ? Create one collection per type of reaction. For example :

• Collection Movie_Rated
• Collection Movie_Liked
• Collection Movie_Watched

Or make only one collection like :

• User_Movie where each document is contain a user id, movie id, if liked, if watched and if rated

idk what the best way, instinctively I would say the second one to get all data in one api call

Best way: create a function to add 1 when someone likes anything and remove 1 when like is removed

So you will need to have a likes collection to prevent the same user liking it 2 times

when u say a function, u are no talking about Appwrite function right ? So its better to have one collection per type of reaction ?

Mhh but if I have juste one collection with a document for each movie and each user example :

• userId: 854d5g84dr25g54drg
• movieId: 597
• like: true
• watched: true
• rated: 8

How its possible to havbe an user liking 2 times ?

Yes, I'm talking about appwrite function

Respect to collection, yes, probably

The user creates 2 documents for the same film, so you get 2 likes

Instead, use a function that checks if it exists or not a document for the same film from the same user