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.