users
- Neill Magill
Owned by Neill Magill
Oct 25, 2022
1 min read
Loading data...
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) |