review_comments

Purpose: Stores external examiner and internal reviewer comments. Used mainly for summative exams.
Joins: review_metadata and questions table.

FieldTypePurpose
idint(11)Primary Key – auto increment.
q_idint(11)ID of the question being commented on.
categorytinyint(4)1=OK, 2=Minor problems, 3=Major problems.
commenttextThe text of the comment
actionenum('Not actioned','Read - disagree','Read - actioned')Institutional response.
responsetextText (reasons) of the institutional response.
durationmediumint(9)How many seconds the reviewer has spent in total on the current screen.
screentinyint(4)Screen number that the question is on.
metadataIDint(11)ID of review metadata