log3
Purpose: Holds responses for Surveys.
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 awared to student |
adjmark | float | Adjusted mark awared to student |
totalpos | tinyint(4) | Maximum available marks for this question |
user_answer | text | User answer |
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 |