Table ss721pr.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
bugs
bugs
bugs
calls
calls
calls
campaigns
campaigns
campaigns
cases
cases
cases
contacts
contacts
contacts
contracts
contracts
contracts
dashboards
dashboards
dashboards
document_revisions
documents
documents
documents
eapm
eapm
eapm
email_templates
emails
emails
emails
filters
filters
filters
forecasts
holidays
inbound_email
inbound_email
job_queue
kbdocument_revisions
kbdocuments
kbdocuments
kbdocuments
kbdocuments
kbdocuments_kbtags
leads
leads
leads
meetings
meetings
meetings
notes
notes
notes
oauth_consumer
oauth_consumer
oauth_consumer
oauth_tokens
opportunities
opportunities
opportunities
pdfmanager
pdfmanager
pdfmanager
product_categories
product_categories
product_templates
product_templates
products
products
products
project
project
project
project_task
project_task
project_task
prospect_lists
prospects
prospects
prospects
quotas
quotes
quotes
quotes
revenue_line_items
revenue_line_items
revenue_line_items
saved_reports
saved_search
schedulers
schedulers
styleguide
styleguide
styleguide
sugarfavorites
sugarfavorites
sugarfavorites
tasks
tasks
tasks
teams
teams
tracker
users
users_signatures
users_signatures
users_signatures
weblogichooks
weblogichooks
acl_roles_users
prospect_lists_prospects
project_resources
campaign_log
roles_users
activities_users
meetings_users
calls_users
email_addr_bean_rel
emails_beans
user_name varchar 60  √  null
user_hash varchar 255  √  null
system_generated_password bit 1  √  null
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
modified_user_id char 36  √  null
created_by char 36  √  null
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
team_sets_teams
deleted bit 1  √  null
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  √  null
preferred_language varchar 255  √  null

Analyzed at Mon Jun 16 07:58 UTC 2014

Indexes:
Column(s) Type Sort
id Primary key Asc
department Performance 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: