Users

From Expertiza_Wiki
Revision as of 15:45, 6 July 2018 by Admin (talk | contribs)
Jump to navigation Jump to search
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.
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.