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.

FieldTypePurpose
idint(11)Primary Key – auto increment.
first_nameschar(60)First name(s) of student.
surnamechar(50)Surname of student.
titleenum('Dr','Miss','Mr','Mrs','Ms','Professor')Title of student.
student_idchar(10)Student ID (optional).
assigned_accountchar(10)Username of allocated temporary account.
reserveddatetimeDatetime when the account was reserved. Information helps when clearing old unused reserved accounts.

See also: Guest Accounts