Hi @Ssjr ,
MongoDB has a sample IMDb database design , I think it might be a good start for you.
I recommend you review this design of the collections and see if you can use the same.
You can easily create a free Atlas cluster and load those sample data sets to play with and try out.
In general you can have:
Reviews collection:
- include.movie reference data
- include user data
- include likes
- include subscribers
- can sort based on time field and index a userId to get all the latest reviews a user did
Movies collection:
- data loaded from the API
- any data that reviewers might add to a movie like avg review rating etc.
Comments collection:
- reference to review
- comments
- embedded replys to comments
Let me know if you have follow up questions.
Ty