| id |
int(10)
|
|
|
|
| email |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| password |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| permissions |
text
|
utf8mb4_unicode_ci
|
|
|
| activated |
tinyint(1)
|
|
|
|
| created_by |
int(11)
|
|
|
|
| activation_code |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| activated_at |
timestamp
|
|
|
|
| last_login |
timestamp
|
|
|
|
| persist_code |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| reset_password_code |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| first_name |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| last_name |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| display_name |
text
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| deleted_at |
timestamp
|
|
|
|
| website |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| country |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| gravatar |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| location_id |
int(11)
|
|
|
|
| phone |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| mobile |
text
|
utf8mb4_unicode_ci
|
|
|
| jobtitle |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| manager_id |
int(11)
|
|
|
|
| employee_num |
text
|
utf8mb4_unicode_ci
|
|
|
| avatar |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| username |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| company_id |
int(10)
|
|
|
|
| remember_token |
text
|
utf8mb4_unicode_ci
|
|
|
| ldap_import |
tinyint(1)
|
|
|
|
| locale |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| show_in_list |
tinyint(1)
|
|
|
|
| two_factor_secret |
varchar(32)
|
utf8mb4_unicode_ci
|
|
|
| two_factor_enrolled |
tinyint(1)
|
|
|
|
| two_factor_optin |
tinyint(1)
|
|
|
|
| department_id |
int(11)
|
|
|
|
| address |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| city |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| state |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| zip |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| skin |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| nav_link_color |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| link_light_color |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| link_dark_color |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| remote |
tinyint(1)
|
|
|
|
| start_date |
date
|
|
|
|
| end_date |
date
|
|
|
|
| scim_externalid |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| autoassign_licenses |
tinyint(1)
|
|
|
|
| vip |
tinyint(1)
|
|
|
|
| enable_sounds |
tinyint(1)
|
|
|
|
| enable_confetti |
tinyint(1)
|
|
|
|