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