review_metadata
- Neill Magill
Owned by Neill Magill
Oct 25, 2022
1 min read
Loading data...
Purpose: Holds general information about a review of a paper.
Joins: properties, users, client_identifiers, review_comments
| Field | Type | Purpose |
|---|---|---|
| id | int(11) unsigned | Primary Key – auto increment. |
| reviewerID | int(10) unsigned | UserID of the reviewer. |
| paperID | mediumint(8) unsigned | ID of the paper the review relates to. |
| started | datetime | When the review first started. |
| complete | datetime | When the review has been finished (i.e. 'Save & Finish' button clicked) |
| review_type | enum('External','Internal') | The type of the review. |
| ipaddress | varchar(100) | IP address or client name of the machine the review was taken on. |
| paper_comment | text | General comments about the paper. |