Users: Difference between revisions
Jump to navigation
Jump to search
(Created page with "{| class="wikitable" !Name !!Datatype !!Description |- !id |int(11) |Primary key of the entry in table, auto increments by default |- !name |varchar(255) |User name of...") |
No edit summary |
||
| Line 64: | Line 64: | ||
Back to [http:// | Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page. | ||
Revision as of 14:31, 17 May 2016
| 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 |
| 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 |
| 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(1) | If the user has the master user permission is granted |
Back to Database Tables Main page.