api_external.ratings
View
Released two-sided ratings and their replies, as profiles show them (Section 4.4.3, Section 4.8.2). Only released ratings appear; internal ratings and org notes never do.
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Rating. |
| rater_side | app.rating_side | Yes | Organization or Party. |
| score | smallint | Yes | Score 1 to 5. |
| comment | text | Yes | Comment. |
| submitted_at | timestamp with time zone | Yes | When given. |
| rated_person_id | uuid | Yes | Person rated, for an org's rating of a person. |
| rated_organization_id | uuid | Yes | Organization rated: the engaged account, or the org for a party's rating. |
| rater_organization_id | uuid | Yes | Organization that rated: the org, or the engaged account. |
| reply | text | Yes | Public reply of the rated side. |
| replied_at | timestamp with time zone | Yes | When replied. |