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