This space is archived
For current information please use the current ExamSys documentation
users
Purpose: Holds information about users (staff, students and external examiners).
Joins: sid, logX, special_needs, user_roles table.
Field | Type | Purpose |
|---|---|---|
password | char(90) | Encrypted password |
grade | char(30) | Degree or programme of student students are on |
surname | char(35) | Last name |
initials | char(10) | Initials |
title | varchar(30) | Title |
username | char(15) | Username (should match LDAP where required) |
char(65) | Email address | |
roles | char(40) | Role of the current user (staff, student, sysadmin, etc). See also User Roles This field was removed in Rogo 7.2.0 |
id | int(10) unsigned | Primary Key – auto increment. |
first_names | char(60) | First names |
gender | enum('Male','Female') | Sex |
special_needs | tinyint(4) | Flag where a student has special needs (see special_needs table) |
yearofstudy | tinyint(4) | Year of study for students |
user_deleted | datetime | Stores when a user was deleted. NULL = still live. |
password_expire | int(11) unsigned | Date when cached password will expire. Set to NULL so passwords do not expire in Rogo (i.e. for locally stored passwords) |