Users

From Expertiza_Wiki
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
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

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.