Users: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 59: Line 59:
|-  
|-  
!master_permssion_granted   
!master_permssion_granted   
|tiny_int(1)   
|tiny_int(4)   
|If the user has the master user permission is granted
|If the user has the master user permission is granted
|-
!handle 
|varchar(255)
|Name of the handle created for the user
|-
!digital_certificate 
|mediumtext
|Digital certificate generated for the user to protect his password
|-
!timezonepref
|varchar(255)
|Timezone of the user
|-
!public_key
|mediumtext
|Public key used for data-encryption by user
|-
!copy_of_emails
|tinyint(1)
|Number of copies of emails sent
|-
!institution_id
|int(11)
|id of the institution of the user
|}  
|}  




Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.
Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

Revision as of 00:31, 23 April 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
password_salt varchar(255)
fullname varchar(255) Registered full name of the user
email varchar(255) Registered email of the respective user.
parent_id int(11) Parent of the respective user; correspond to the ID which created this particular user
private_by_default tinyint(1) If the user is private by default; essentially Boolean
mru_directory_path varchar(128) Default home directory of the respective user
email_on_review tiny_int(1) If the user is emailed on receiving a review; essentially Boolean
email_on_submission tiny_int(1) If emailed on submission; essentially Boolean
email_on_review_of_review tiny_int(1) Whether to email on receiving review of review; essentially boolean
is_new_user tiny_int(1) If the user is a new user; used to check if user has signed the new user form
master_permssion_granted tiny_int(4) If the user has the master user permission is granted
handle varchar(255) Name of the handle created for the user
digital_certificate mediumtext Digital certificate generated for the user to protect his password
timezonepref varchar(255) Timezone of the user
public_key mediumtext Public key used for data-encryption by user
copy_of_emails tinyint(1) Number of copies of emails sent
institution_id int(11) id of the institution of the user


Back to Database Tables Main page.