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