log0_deleted
- Neill Magill
Owned by Neill Magill
Oct 25, 2022
1 min read
Loading data...
Purpose: When SysAdmin? uses 'Clear Old Logs' the old records from 'log0' are moved to 'log0_deleted'.
Joins: users, papers, questions and log_metadata_deleted 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 |
| 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 |