Rating System Database Help

I am trying to create an app where every user can review other users based on 5 different categories. Each person can rate another person and comment once per category. So I can rate you and comment on you five times, once per category. I am stuck on how to setup the database here and I had a response before from someone trying to help but it was confusing.

Create a separate collection with properties like →

  • Text (Comment)
  • Number (No. of stars)
  • Submitted By (1 to Many relationship with users collection)
  • Submitting for which user (1 to Many relationship with users collection)
  • Category (1 to Many replationship with category collection)

I see no way to create relationships by specific property. I only see you can create relationships from collection to collection. So I am not sure why he wrote it like this.

Also is he implying I need a category collection in addition to a review collection?

If someone could help me with the database setup and relationships I would much appreciate it.

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.