Reviews
Jump to navigation
Jump to search
Reviews provide a means or communicating information from one user to another about the submission content.
Deprecated
Reviews variable documentation
| Field Name | Type | Description |
|---|---|---|
| id | int(11) | The unique record id |
| review_mapping_id | int(11) | The ID of the review mapping used to define the relationship between and author/team and a reviewer |
| review_num_for_author | int(11) | (Unused at present?) This is supposed to be the review number, as seen by the author. [Should be changed to review_num_for_creator] |
| review_num_for_reviewer | int(11) | (Unused at present?) This is supposed to be the review number, as seen by the reviewer. Normally for non-team assignments, it will be the same as the review_num_for_author. For team assignments, it often differs from review_num_for_author, because the creator receives more reviews than each individual reviewer creates. |
| ignore | tinyint(4) | Designate that a given review is not included in the score. May be unused |
| additional_comment | text | An additional comment provided by the reviewer to support his/or her review content |
| updated_at | datetime | The timestamp indicating when this review was last modified |
| created_at | datetime | The timestamp indicating when this review was created |
E/R diagram for Parents Tables
Tables referred by the Reviews Table as Foreign Key Relationship.
E/R diagram for Child Tables
Tables referred by the Reviews Table as Foreign Key Relationship.
Back to the database documentation