Reviews: Difference between revisions
Jump to navigation
Jump to search
(Created page with "Reviews provide a means or communicating information from one user to another about the submission content. '''Deprecated''' ==Reviews variable documentation== {| class="wikit...") |
No edit summary |
||
| Line 40: | Line 40: | ||
|The timestamp indicating when this review was created | |The timestamp indicating when this review was created | ||
|} | |} | ||
== E/R diagram for Parents Tables == | |||
Tables referred by the Reviews Table as Foreign Key Relationship. | |||
[[File:reviews_imported.png]] | |||
== E/R diagram for Child Tables == | |||
Tables referred by the Reviews Table as Foreign Key Relationship. | |||
[[File:reviews_exported.png]] | |||
Back to the [[Documentation_on_Database_Tables|database documentation]] | Back to the [[Documentation_on_Database_Tables|database documentation]] | ||
Latest revision as of 22:06, 25 April 2018
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