Users: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 16: | Line 16: | ||
!role_id | !role_id | ||
|int(11) | |int(11) | ||
|Role which this user corresponds to FK into ROLES table | |Role which this user corresponds to FK into ROLES table. Examples are super_admin, admin, instructor, etc. | ||
|- | |- | ||
!password_salt | !password_salt | ||
| Line 24: | Line 24: | ||
!fullname | !fullname | ||
|varchar(255) | |varchar(255) | ||
|Registered full name of the user | |Registered full name of the user, e.g., Lastname, firstname | ||
|- | |- | ||
!email | !email | ||
| Line 32: | Line 32: | ||
!parent_id | !parent_id | ||
|int(11) | |int(11) | ||
|Parent of the respective user; | |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 | !private_by_default | ||
|tinyint(1) | |tinyint(1) | ||
|If the user is private by default; essentially Boolean | |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 | !mru_directory_path | ||
|varchar(128) | |varchar(128) | ||
| | |To allow the user to log back in to the same directory that (s)he logged out from before. | ||
|- | |- | ||
!email_on_review | !email_on_review | ||
|tiny_int(1) | |tiny_int(1) | ||
| | |Whether the user should be e-mailed when a new review is received for their work. | ||
|- | |- | ||
!email_on_submission | !email_on_submission | ||
|tiny_int(1) | |tiny_int(1) | ||
|If | |If user is to be e-mailed when something they reviewed is resubmitted. | ||
|- | |- | ||
!email_on_review_of_review | !email_on_review_of_review | ||
|tiny_int(1) | |tiny_int(1) | ||
|Whether | |Whether the user should be e-mailed when one of their reviews is meta-reviewed by another reviewer. | ||
|- | |- | ||
!is_new_user | !is_new_user | ||
|tiny_int(1) | |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 | !master_permssion_granted | ||
|tiny_int(4) | |tiny_int(4) | ||
|If the user has the master user permission is granted | |If the user has the master user permission is granted. What?! What does master permission mean?! | ||
|- | |- | ||
!handle | !handle | ||
|varchar(255) | |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 | !digital_certificate | ||
| Line 72: | Line 72: | ||
!timezonepref | !timezonepref | ||
|varchar(255) | |varchar(255) | ||
|Timezone | |Timezone that times should be displayed in when the user logs in. | ||
|- | |- | ||
!public_key | !public_key | ||
| Line 80: | Line 80: | ||
!copy_of_emails | !copy_of_emails | ||
|tinyint(1) | |tinyint(1) | ||
| | |Whether this user wants to receive copies of e-mails sent for all assignments they are participating in. | ||
|- | |- | ||
!institution_id | !institution_id | ||
|int(11) | |int(11) | ||
|id of the institution | |id of the institution that the user is associated with | ||
|} | |} | ||
Revision as of 15:45, 6 July 2018
| 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?! |
| 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.