Table aa6f7169.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
contract_types
contract_types
contracts
contracts
contracts
dashboards
dashboards
dashboards
data_privacy
data_privacy
data_privacy
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
manufacturers
manufacturers
meetings
meetings
meetings
notes
notes
notes
notifications
notifications
notifications
oauth_consumer
oauth_consumer
oauth_consumer
oauth_tokens
opportunities
opportunities
opportunities
pdfmanager
pdfmanager
pdfmanager
product_categories
product_categories
product_categories
product_templates
product_templates
product_templates
product_types
product_types
products
products
products
project
project
project
project_task
project_task
project_task
prospect_lists
prospect_lists
prospect_lists
prospects
prospects
prospects
quotas
quotas
quotas
quotas
quotes
quotes
quotes
revenue_line_items
revenue_line_items
revenue_line_items
saved_reports
saved_reports
saved_reports
saved_search
schedulers
schedulers
shippers
shippers
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
calls_users
activities_users
campaign_log
roles_users
email_addr_bean_rel
acl_roles_users
users
emails_beans
prospect_lists_prospects
meetings_users
team_memberships
project_resources
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
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 Thu Mar 28 07:55 UTC 2019

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: