Purpose: When SysAdmin uses 'Clear Old Logs' the old records from 'log_metadata' are moved to 'log_metadata_deleted'.
Joins: users, papers, questions, log0_deleted and log1_deleted tables.
|id||int(11)||Primary Key – auto increment.|
|userID||mediumint(9)||ID of the user who's responses are being recorded.|
|paperID||mediumint(8) unsigned||ID of the paper|
|started||datetime||Datetime when the paper was started.|
|ipaddress||varchar(100)||The IP address of the computer where the user is based.|
|student_grade||char(25)||The degree or programme of study the student is on.|
|year||tinyint(4)||The current year or study the student is on|
|attempt||tinyint(4)||1=1st attempt, 2=first resit, 3=second resit|
|completed||datetime||The date/time when the user first started the paper.|
|lab_name||varchar(255)||The name of the lab the exam was taken in. Stored as text rather than ID because IP addresses can be lost historically as computers are updated in each lab.|
|highest_screen||tinyint(3) unsigned||The highest screen number that has been successfully submitted - used on unidirectional papers.|