Purpose: Holds responses for Surveys.
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 awared to student|
|adjmark||float||Adjusted mark awared to student|
|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|