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)
email	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)

Browser not supported