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. |
See also: Guest Accounts