Purpose: Holds responses for Summative assessments.
Joins: users, papers, questions and log_metadata tables.
|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 taking into account question exclusions|
|totalpos||tinyint(4)||Maximum available marks for this question|
|errorstate||tinyint(3)||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)||The ID of the main log_metadata record|