Purpose: Stores any data submitted after the end date of a paper for Progress Tests and Summative exams.
Joins: users, papers, questions and log_metadata tables.
| Field | Type | Purpose |
|---|---|---|
| id | int(8) | Primary Key – auto increment. |
| q_id | int(4) | ID of the question that is being saved. |
| mark | float | Mark awarded to student |
| adjmark | float | Adjusted mark awarded to student |
| totalpos | tinyint(4) | Maximum available marks for this question |
| user_answer | text | User answer |
| errorstate | tinyint(3) unsignednot currently used | 6.0.5 onwards - stores calculation question error state (numerical value from Rserv) |
| screen | tinyint(3) unsigned | Screen the question is on (Note: same question ID could be on multiple screens in a survey) |
| duration | mediumint(9) | Time the user has spent in seconds on the current screen |
| updated | datetime | Datetime when this question has last saved |
| dismiss | char(20) | Storage of any dismiss data so that state can be remembered while traversing screens |
| option_order | varchar(255) | The order the various stems were presented in within a question |
| metadataID | int(11) unsigned | The ID of the main log_metadata record |