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