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.
| Field | Type | Purpose |
|---|---|---|
| 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. |