review_metadata

Purpose: Holds general information about a review of a paper.

Joins: properties, users, client_identifiers, review_comments

 

FieldTypePurpose
idint(11) unsignedPrimary Key – auto increment.
reviewerIDint(10) unsignedUserID of the reviewer.
paperIDmediumint(8) unsignedID of the paper the review relates to.
starteddatetimeWhen the review first started.
completedatetimeWhen the review has been finished (i.e. 'Save & Finish' button clicked)
review_typeenum('External','Internal')The type of the review.
ipaddressvarchar(100)IP address or client name of the machine the review was taken on.
paper_commenttextGeneral comments about the paper.