Users - Revision history

Admin: /* Users Variable Documentation (Reimplementation) */

2026-03-08T19:28:51Z

Users Variable Documentation (Reimplementation)

← Older revision		Revision as of 19:28, 8 March 2026
Line 55:		Line 55:
	\|varchar(255)		\|varchar(255)
	\|Timezone that times should be displayed in when the user logs in.		\|Timezone that times should be displayed in when the user logs in.
			\|-
			!language_pref
			\|varchar(255)
			\|Language that the user wants to use in interacting with Expertiza.
	\|-		\|-
	!public_key		!public_key

Rtantry2 at 03:33, 9 December 2025

2025-12-09T03:33:33Z

Show changes

Admin at 16:18, 9 July 2018

2018-07-09T16:18:14Z

← Older revision		Revision as of 16:18, 9 July 2018
Line 68:		Line 68:
	!digital_certificate		!digital_certificate
	\|mediumtext		\|mediumtext
	\|Digital certificate generated for the user to protect his password		\|Digital certificate generated for the user to protect his password. This is never read and could be removed.
	\|-		\|-
	!timezonepref		!timezonepref
Line 76:		Line 76:
	!public_key		!public_key
	\|mediumtext		\|mediumtext
	\|Public key used for data-encryption by user		\|Public key used for data-encryption by user. This is used and should stay in the table, though whether the use is meaningful is not clear.
	\|-		\|-
	!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. ~~It seems that this~~ is only implemented for instructors.		\|Whether this user wants to receive copies of e-mails sent for all assignments they are participating in. This is only implemented for instructors. Instructors would enable it so they start getting copies of all emails being sent related to their assignments. It is a way that the instructor can be reassured that emails are in fact being sent.
	\|-		\|-
	!institution_id		!institution_id

Admin at 15:49, 6 July 2018

2018-07-06T15:49:32Z

← Older revision		Revision as of 15:49, 6 July 2018
Line 60:		Line 60:
	!master_permssion_granted		!master_permssion_granted
	\|tiny_int(4)		\|tiny_int(4)
	\|If the user has the master user permission is granted. What?! What does master permission mean?!		\|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		!handle

Admin at 15:46, 6 July 2018

2018-07-06T15:46:58Z

← Older revision		Revision as of 15:46, 6 July 2018
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.		\|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		!institution_id

Admin at 15:45, 6 July 2018

2018-07-06T15:45:18Z

← Older revision		Revision as of 15:45, 6 July 2018
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; ~~correspond~~ to the ~~ID which~~ created this ~~particular~~ 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)
	\|~~Default home directory of~~ the ~~respective~~ user		\|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)
	\|If the user ~~is emailed on receiving~~ a review~~; essentially Boolean~~		\|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 ~~emailed on submission; essentially Boolean~~		\|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 ~~to email on receiving review~~ of ~~review; essentially boolean~~		\|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)
	\|If the user ~~is a new user~~; ~~used to check~~ if user ~~has signed~~ the new user ~~form~~		\|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)
	\|~~Name of~~ the ~~handle created for~~ the user		\|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 of the user		\|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)
	\|~~Number of~~ copies of ~~emails~~ sent		\|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 of the user		\|id of the institution that the user is associated with
	\|}		\|}

Smishra4: /* E/R diagram of tables referencing users table */

2018-04-23T00:47:36Z

E/R diagram of tables referencing users table

← Older revision		Revision as of 00:47, 23 April 2018
Line 89:		Line 89:
	== E/R diagram of tables referencing users table ==		== E/R diagram of tables referencing users table ==
	The following image shows the tables referencing users table		The following image shows the tables referencing users table
	[[File:Users_export.~~jpg~~]]		[[File:Users_export.png]]

	== E/R diagram of tables users table is referencing to ==		== E/R diagram of tables users table is referencing to ==

Smishra4 at 00:47, 23 April 2018

2018-04-23T00:47:06Z

← Older revision		Revision as of 00:47, 23 April 2018
Line 86:		Line 86:
	\|id of the institution of the user		\|id of the institution of the user
	\|}		\|}

			== E/R diagram of tables referencing users table ==
			The following image shows the tables referencing users table
			[[File:Users_export.jpg]]

			== E/R diagram of tables users table is referencing to ==
			The users table is not referenced by any other tables


	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.

Smishra4 at 00:31, 23 April 2018

2018-04-23T00:31:50Z

@@ Line 59: / Line 59: @@
 |-
 !master_permssion_granted
-|tiny_int(1)
+|tiny_int(4)
 |If the user has the master user permission is granted
 |}
 Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

Smishra4 at 00:19, 23 April 2018

2018-04-23T00:19:48Z

← Older revision		Revision as of 00:19, 23 April 2018
Line 10:		Line 10:
	\|User name of the respective user		\|User name of the respective user
	\|-		\|-
	!~~password~~		!crypted_password
	\|varchar(40)		\|varchar(40)
	\|Password of the respective user		\|Password of the respective user