Purpose: Stores external examiner and internal reviewer comments. Used mainly for summative exams.
Joins: users, review_metadata and questions table.
| Field | Type | Purpose |
|---|---|---|
| id | int(11) | Primary Key – auto increment. |
| q_id | int(11) | ID of the question being commented on. |
| category | tinyint(4) | 1=OK, 2=Minor problems, 3=Major problems. |
| comment | text | The text of the comment |
| action | enum('Not actioned','Read - disagree','Read - actioned') | Institutional response. |
| response | text | Text (reasons) of the institutional response. |
| duration | mediumint(9) | How many seconds the reviewer has spent in total on the current screen. |
| screen | tinyint(4) | Screen number that the question is on. |
| metadataID | int(11) | ID of review metadata |