temp_users

Purpose: Used for summative exams for students who cannot log in for whatever reason. Student fills in their personal details that can be matched up after the exam.
Joins: users table.

Field	Type	Purpose
id	int(11)	Primary Key – auto increment.
first_names	char(60)	First name(s) of student.
surname	char(50)	Surname of student.
title	enum('Dr','Miss','Mr','Mrs','Ms','Professor')	Title of student.
student_id	char(10)	Student ID (optional).
assigned_account	char(10)	Username of allocated temporary account.
reserved	datetime	Datetime when the account was reserved. Information helps when clearing old unused reserved accounts.

ExamSys (Archive)

temp_users

Related content