Table ab9984a5.users Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
id char 36
accounts
accounts
accounts
acl_role_sets
acl_role_sets
activities
activities
bugs
bugs
bugs
calls
calls
calls
campaigns
campaigns
campaigns
cases
cases
cases
categories
categories
contacts
contacts
contacts
contracts
contracts
contracts
dashboards
dashboards
dashboards
document_revisions
documents
documents
documents
eapm
eapm
eapm
email_templates
email_templates
email_templates
emails
emails
emails
embedded_files
embedded_files
filters
filters
filters
forecast_manager_worksheets
forecast_manager_worksheets
forecast_manager_worksheets
forecast_worksheets
forecast_worksheets
forecast_worksheets
forecasts
holidays
inbound_email
inbound_email
job_queue
kbarticles
kbarticles
kbarticles
kbcontent_templates
kbcontent_templates
kbcontents
kbcontents
kbcontents
kbcontents
kbdocuments
kbdocuments
kbdocuments
leads
leads
leads
meetings
meetings
meetings
notes
notes
notes
notifications
notifications
notifications
oauth_consumer
oauth_consumer
oauth_consumer
oauth_tokens
opportunities
opportunities
opportunities
pdfmanager
pdfmanager
pdfmanager
pmse_bpm_activity_definition
pmse_bpm_activity_definition
pmse_bpm_activity_definition
pmse_bpm_activity_step
pmse_bpm_activity_step
pmse_bpm_activity_step
pmse_bpm_activity_user
pmse_bpm_activity_user
pmse_bpm_activity_user
pmse_bpm_config
pmse_bpm_config
pmse_bpm_config
pmse_bpm_dynamic_forms
pmse_bpm_dynamic_forms
pmse_bpm_dynamic_forms
pmse_bpm_event_definition
pmse_bpm_event_definition
pmse_bpm_event_definition
pmse_bpm_flow
pmse_bpm_flow
pmse_bpm_flow
pmse_bpm_form_action
pmse_bpm_form_action
pmse_bpm_form_action
pmse_bpm_gateway_definition
pmse_bpm_gateway_definition
pmse_bpm_gateway_definition
pmse_bpm_group
pmse_bpm_group
pmse_bpm_group
pmse_bpm_group_user
pmse_bpm_group_user
pmse_bpm_group_user
pmse_bpm_notes
pmse_bpm_notes
pmse_bpm_notes
pmse_bpm_process_definition
pmse_bpm_process_definition
pmse_bpm_process_definition
pmse_bpm_related_dependency
pmse_bpm_related_dependency
pmse_bpm_related_dependency
pmse_bpm_thread
pmse_bpm_thread
pmse_bpm_thread
pmse_bpmn_activity
pmse_bpmn_activity
pmse_bpmn_activity
pmse_bpmn_artifact
pmse_bpmn_artifact
pmse_bpmn_artifact
pmse_bpmn_bound
pmse_bpmn_bound
pmse_bpmn_bound
pmse_bpmn_data
pmse_bpmn_data
pmse_bpmn_data
pmse_bpmn_diagram
pmse_bpmn_diagram
pmse_bpmn_diagram
pmse_bpmn_documentation
pmse_bpmn_documentation
pmse_bpmn_documentation
pmse_bpmn_event
pmse_bpmn_event
pmse_bpmn_event
pmse_bpmn_extension
pmse_bpmn_extension
pmse_bpmn_extension
pmse_bpmn_flow
pmse_bpmn_flow
pmse_bpmn_flow
pmse_bpmn_gateway
pmse_bpmn_gateway
pmse_bpmn_gateway
pmse_bpmn_lane
pmse_bpmn_lane
pmse_bpmn_lane
pmse_bpmn_laneset
pmse_bpmn_laneset
pmse_bpmn_laneset
pmse_bpmn_participant
pmse_bpmn_participant
pmse_bpmn_participant
pmse_bpmn_process
pmse_bpmn_process
pmse_bpmn_process
pmse_business_rules
pmse_business_rules
pmse_business_rules
pmse_emails_templates
pmse_emails_templates
pmse_emails_templates
pmse_inbox
pmse_inbox
pmse_inbox
pmse_project
pmse_project
pmse_project
product_categories
product_categories
product_categories
product_templates
product_templates
product_templates
products
products
products
project
project
project
project_task
project_task
project_task
prospect_lists
prospects
prospects
prospects
quotas
quotas
quotas
quotas
quotes
quotes
quotes
revenue_line_items
revenue_line_items
revenue_line_items
saved_reports
saved_search
schedulers
schedulers
styleguide
styleguide
styleguide
subscriptions
subscriptions
sugarfavorites
sugarfavorites
sugarfavorites
tags
tags
tags
tasks
tasks
tasks
taxrates
taxrates
teams
teams
tracker
users
users_signatures
users_signatures
users_signatures
weblogichooks
weblogichooks
roles_users
acl_roles_users
team_memberships
emails_beans
calls_users
activities_users
campaign_log
users
prospect_lists_prospects
project_resources
email_addr_bean_rel
meetings_users
user_name varchar 60  √  null
user_hash varchar 255  √  null
system_generated_password bit 1  √  0
pwd_last_changed datetime 19  √  null
authenticate_id varchar 100  √  null
sugar_login bit 1  √  1
picture varchar 255  √  null
first_name varchar 30  √  null
last_name varchar 30  √  null
is_admin bit 1  √  0
external_auth_only bit 1  √  0
receive_notifications bit 1  √  1
description text 65535  √  null
date_entered datetime 19  √  null
date_modified datetime 19  √  null
last_login datetime 19  √  null
modified_user_id char 36  √  null
created_by char 36  √  null
users
title varchar 50  √  null
department varchar 50  √  null
phone_home varchar 50  √  null
phone_mobile varchar 50  √  null
phone_work varchar 50  √  null
phone_other varchar 50  √  null
phone_fax varchar 50  √  null
status varchar 100  √  null
address_street varchar 150  √  null
address_city varchar 100  √  null
address_state varchar 100  √  null
address_country varchar 100  √  null
address_postalcode varchar 20  √  null
default_team char 36  √  null
teams
team_set_id char 36  √  null
team_sets_teams
team_sets
acl_team_set_id char 36  √  null
deleted bit 1  √  0
portal_only bit 1  √  0
show_on_employees bit 1  √  1
employee_status varchar 100  √  null
messenger_id varchar 100  √  null
messenger_type varchar 100  √  null
reports_to_id char 36  √  null
users
is_group bit 1  √  0
preferred_language varchar 255  √  null
acl_role_set_id char 36  √  null
acl_role_sets

Analyzed at Sun Aug 27 08:13 UTC 2017

Indexes:
Column(s) Type Sort
id Primary key Asc
last_login Performance Asc
department Performance Asc
first_name + last_name + deleted Performance Asc/Asc/Asc
last_name + first_name + deleted Performance Asc/Asc/Asc
user_name + is_group + status + last_name + first_name + id Performance Asc/Asc/Asc/Asc/Asc/Asc
title Performance Asc
reports_to_id + id Performance Asc/Asc
team_set_id Performance Asc

Close relationships  within of separation: