Table ss6519ce.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
document_revisions
documents
documents
documents
eapm
eapm
eapm
email_templates
emails
emails
emails
inbound_email
inbound_email
leads
leads
leads
meetings
meetings
meetings
notes
notes
notes
oauth_tokens
oauthkeys
oauthkeys
oauthkeys
opportunities
opportunities
opportunities
project
project
project
project_task
project_task
project_task
prospect_lists
prospects
prospects
prospects
saved_search
schedulers
schedulers
schedulersjobs
sugarfeed
sugarfeed
sugarfeed
tasks
tasks
tasks
users
users_signatures
acl_roles_users
meetings_users
calls_users
roles_users
contacts_users
campaign_log
prospect_lists_prospects
emails_beans
email_addr_bean_rel
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
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
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

Analyzed at Mon Nov 24 22:04 UTC 2014

Indexes:
Column(s) Type Sort
id Primary key Asc
user_name + is_group + status + last_name + first_name + id Performance Asc/Asc/Asc/Asc/Asc/Asc

Close relationships  within of separation: