ratings: ratings

In Hunt-Laboratory/huntr: Hunt Lab Experiment Data

Description

Users can rate the responses and comments of other users. The following table captures these ratings. Note that users can rate as many times as they like (each of which is captured in the table), but only the last ratings are used in calculating the aggregate rating. In other words, the ""rating_total"" with the latest timestamp in the *Ratings* table should match the ""team_rating"" in the *TopReport* table.

Format

problem_id

Unique identifier of the problem

team_id

Unique identifier for the team that produced the report

content_type

'report', 'resource', or 'comment'. Other types may be added in future.

content_id

Unique identifier for the content (content can be response or comment)

author_id

Unique identifier of the original author of the response

author

Name of the user who originally authored the response

rater_id

Unique identifier of a user who rated the response

rater

Name of the user who rated the response

last_edited

Timestamp when the rating was last updated

rating_type

'thumbs', 'simple', 'detailed'

rating_total

1 or 0 for thumbs, number (0-100) for simple, aggregated number for detailed rating

rating_sub_01_title

The title of the ratings subfield

rating_sub_01

Number for detailed rating field 1

rating_sub_02_title

The title of the ratings subfield

rating_sub_02

Number for detailed rating field 2

rating_sub_03_title

The title of the ratings subfield

rating_sub_03

Number for detailed rating field 3

rating_sub_04_title

The title of the ratings subfield

rating_sub_04

Number for detailed rating field 4

rating_sub_05_title

The title of the ratings subfield

rating_sub_05

Number for detailed rating field 5

rating_sub_06_title

The title of the ratings subfield

rating_sub_06

Number for detailed rating field 6

rating_sub_07_title

The title of the ratings subfield

rating_sub_07

Number for detailed rating field 7

rating_sub_08_title

The title of the ratings subfield

rating_sub_08

Number for detailed rating field 8

rating_sub_09_title

The title of the ratings subfield

rating_sub_09

Number for detailed rating field 9

problem

Short title of the problem

Hunt-Laboratory/huntr documentation built on Sept. 27, 2020, 3:17 a.m.