Purpose: Holds information about users (staff, students and external examiners).
Joins: sid, logX, special_needs, user_roles table.
|grade||char(30)||Degree or programme of student students are on|
|username||char(15)||Username (should match LDAP where required)|
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.|
|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)|