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 |
| 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?! Well, doesn't matter, because this field is set but not read in existing code. |
| 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.