Users

Name	Datatype	Description
id	int(11)	Primary key of the entry in table, auto increments by default
name	varchar(255)	User name of the respective user
crypted_password	varchar(40)	Password of the respective user
role_id	int(11)	Role which this user corresponds to FK into ROLES table. Examples are super_admin, admin, instructor, etc.
password_salt	varchar(255)
fullname	varchar(255)	Registered full name of the user, e.g., Lastname, firstname
email	varchar(255)	Registered email of the respective user.
parent_id	int(11)	Parent of the respective user; corresponding to the user who created this user. The value of this field is the primary key in the users table for the parent user, e.g., 2 if the parent is the super-admin (username admin).
private_by_default	tinyint(1)	If the user is private by default; essentially Boolean. It seems that this is not used in the system, don't know what it was intended to mean. Could be removed.
mru_directory_path	varchar(128)	To allow the user to log back in to the same directory that (s)he logged out from before.
email_on_review	tiny_int(1)	Whether the user should be e-mailed when a new review is received for their work.
email_on_submission	tiny_int(1)	If user is to be e-mailed when something they reviewed is resubmitted.
email_on_review_of_review	tiny_int(1)	Whether the user should be e-mailed when one of their reviews is meta-reviewed by another reviewer.
is_new_user	tiny_int(1)	Determines whether the user has logged in before; if not, upon login the user should be presented with the new-user agreement.
master_permssion_granted	tiny_int(4)	If the user has the master user permission is granted. What?! What does master permission mean?!
handle	varchar(255)	A handle is an alternate name by which the user would want to be known, e.g., on the wiki, if this assignment involves writing on a wiki. This allows the user to appear anonymous. In the code, this is sometimes known as the "default handle", because users can also create assignment-specific handles.
digital_certificate	mediumtext	Digital certificate generated for the user to protect his password
timezonepref	varchar(255)	Timezone that times should be displayed in when the user logs in.
public_key	mediumtext	Public key used for data-encryption by user
copy_of_emails	tinyint(1)	Whether this user wants to receive copies of e-mails sent for all assignments they are participating in. It seems that this is only implemented for instructors.
institution_id	int(11)	id of the institution that the user is associated with

E/R diagram of tables referencing users table

The following image shows the tables referencing users table

E/R diagram of tables users table is referencing to

The users table is not referenced by any other tables

Back to Database Tables Main page.