| id |
char(36)
|
utf8mb4_general_ci
|
|
|
| user_name |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| user_hash |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| system_generated_password |
tinyint(1)
|
|
|
|
| pwd_last_changed |
datetime
|
|
|
|
| authenticate_id |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| sugar_login |
tinyint(1)
|
|
|
|
| first_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| last_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| is_admin |
tinyint(1)
|
|
|
|
| external_auth_only |
tinyint(1)
|
|
|
|
| receive_notifications |
tinyint(1)
|
|
|
|
| description |
text
|
utf8mb4_general_ci
|
|
|
| date_entered |
datetime
|
|
|
|
| date_modified |
datetime
|
|
|
|
| modified_user_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| created_by |
char(36)
|
utf8mb4_general_ci
|
|
|
| title |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| photo |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| department |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| phone_home |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| phone_mobile |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| phone_work |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| phone_other |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| phone_fax |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| status |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| address_street |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| address_city |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| address_state |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| address_country |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| address_postalcode |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| deleted |
tinyint(1)
|
|
|
|
| portal_only |
tinyint(1)
|
|
|
|
| show_on_employees |
tinyint(1)
|
|
|
|
| employee_status |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| messenger_id |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| messenger_type |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| reports_to_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| is_group |
tinyint(1)
|
|
|
|
| factor_auth |
tinyint(1)
|
|
|
|
| factor_auth_interface |
varchar(255)
|
utf8mb4_general_ci
|
|
|
