This space is archived
For current information please use the current ExamSys documentation
log_metadata
Purpose: Holds metadata against log0, log1, log2, log3 and log5.
Joins: users, papers, questions and logX 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. |