# Rating System Database Help

**URL:** <https://forum.adalo.com/t/rating-system-database-help/22380>\
**Category:** Get Help\
**Created:** [January 21, 2022, 4:35pm UTC](https://forum.adalo.com/t/rating-system-database-help/22380 "2022-01-21T16:35:10Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![trble](https://avatars.discourse-cdn.com/v4/letter/t/45deac/32.png) [@trble](https://forum.adalo.com/u/trble)\
**Post date:** [January 21, 2022, 4:35pm UTC](https://forum.adalo.com/t/rating-system-database-help/22380/1 "2022-01-21T16:35:10Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [January 31, 2022, 4:35pm UTC](https://forum.adalo.com/t/rating-system-database-help/22380/2 "2022-01-31T16:35:30Z")

</div>

Closed on January 31, 2022, 4:35pm UTC

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