Users
| 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.