Table a7af7d0c.users Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id char 36
accounts.assigned_user_id Defined in XML R
accounts.created_by Defined in XML R
accounts.modified_user_id Defined in XML R
acl_role_sets.created_by Defined in XML R
acl_role_sets.modified_user_id Defined in XML R
activities.created_by Defined in XML R
activities.modified_user_id Defined in XML R
archive_runs.created_by Defined in XML R
archive_runs.modified_user_id Defined in XML R
bugs.assigned_user_id Defined in XML R
bugs.created_by Defined in XML R
bugs.modified_user_id Defined in XML R
business_centers.assigned_user_id Defined in XML R
business_centers.created_by Defined in XML R
business_centers.modified_user_id Defined in XML R
calls.assigned_user_id Defined in XML R
calls.created_by Defined in XML R
calls.modified_user_id Defined in XML R
campaigns.assigned_user_id Defined in XML R
campaigns.created_by Defined in XML R
campaigns.modified_user_id Defined in XML R
cases.assigned_user_id Defined in XML R
cases.created_by Defined in XML R
cases.first_response_user_id Defined in XML R
cases.modified_user_id Defined in XML R
categories.created_by Defined in XML R
categories.modified_user_id Defined in XML R
changetimers.created_by Defined in XML R
changetimers.modified_user_id Defined in XML R
commentlog.created_by Defined in XML R
commentlog.modified_user_id Defined in XML R
console_configuration.created_by Defined in XML R
console_configuration.modified_user_id Defined in XML R
contacts.assigned_user_id Defined in XML R
contacts.created_by Defined in XML R
contacts.modified_user_id Defined in XML R
contract_types.created_by Defined in XML R
contract_types.modified_user_id Defined in XML R
contracts.assigned_user_id Defined in XML R
contracts.created_by Defined in XML R
contracts.modified_user_id Defined in XML R
dashboards.assigned_user_id Defined in XML R
dashboards.created_by Defined in XML R
dashboards.modified_user_id Defined in XML R
data_archivers.created_by Defined in XML R
data_archivers.modified_user_id Defined in XML R
data_privacy.assigned_user_id Defined in XML R
data_privacy.created_by Defined in XML R
data_privacy.modified_user_id Defined in XML R
document_revisions.created_by Defined in XML R
documents.assigned_user_id Defined in XML R
documents.created_by Defined in XML R
documents.modified_user_id Defined in XML R
eapm.assigned_user_id Defined in XML R
eapm.created_by Defined in XML R
eapm.modified_user_id Defined in XML R
email_templates.assigned_user_id Defined in XML R
email_templates.created_by Defined in XML R
email_templates.modified_user_id Defined in XML R
emails.assigned_user_id Defined in XML R
emails.created_by Defined in XML R
emails.modified_user_id Defined in XML R
embedded_files.created_by Defined in XML R
embedded_files.modified_user_id Defined in XML R
filters.assigned_user_id Defined in XML R
filters.created_by Defined in XML R
filters.modified_user_id Defined in XML R
forecast_manager_worksheets.assigned_user_id Defined in XML R
forecast_manager_worksheets.created_by Defined in XML R
forecast_manager_worksheets.modified_user_id Defined in XML R
forecast_worksheets.assigned_user_id Defined in XML R
forecast_worksheets.created_by Defined in XML R
forecast_worksheets.modified_user_id Defined in XML R
forecasts.user_id Defined in XML R
holidays.created_by Defined in XML R
holidays.modified_user_id Defined in XML R
holidays.person_id Defined in XML R
inbound_email.created_by Defined in XML R
inbound_email.modified_user_id Defined in XML R
job_queue.assigned_user_id Defined in XML R
kbarticles.assigned_user_id Defined in XML R
kbarticles.created_by Defined in XML R
kbarticles.modified_user_id Defined in XML R
kbcontent_templates.created_by Defined in XML R
kbcontent_templates.modified_user_id Defined in XML R
kbcontents.assigned_user_id Defined in XML R
kbcontents.created_by Defined in XML R
kbcontents.kbsapprover_id Defined in XML R
kbcontents.modified_user_id Defined in XML R
kbdocuments.assigned_user_id Defined in XML R
kbdocuments.created_by Defined in XML R
kbdocuments.modified_user_id Defined in XML R
leads.assigned_user_id Defined in XML R
leads.created_by Defined in XML R
leads.modified_user_id Defined in XML R
manufacturers.created_by Defined in XML R
manufacturers.modified_user_id Defined in XML R
meetings.assigned_user_id Defined in XML R
meetings.created_by Defined in XML R
meetings.modified_user_id Defined in XML R
messages.assigned_user_id Defined in XML R
messages.created_by Defined in XML R
messages.modified_user_id Defined in XML R
mobile_devices.assigned_user_id Defined in XML R
mobile_devices.created_by Defined in XML R
mobile_devices.modified_user_id Defined in XML R
notes.assigned_user_id Defined in XML R
notes.created_by Defined in XML R
notes.modified_user_id Defined in XML R
notifications.assigned_user_id Defined in XML R
notifications.created_by Defined in XML R
notifications.modified_user_id Defined in XML R
oauth_consumer.assigned_user_id Defined in XML R
oauth_consumer.created_by Defined in XML R
oauth_consumer.modified_user_id Defined in XML R
oauth_tokens.assigned_user_id Defined in XML R
opportunities.assigned_user_id Defined in XML R
opportunities.created_by Defined in XML R
opportunities.modified_user_id Defined in XML R
pdfmanager.assigned_user_id Defined in XML R
pdfmanager.created_by Defined in XML R
pdfmanager.modified_user_id Defined in XML R
pmse_bpm_activity_definition.assigned_user_id Defined in XML R
pmse_bpm_activity_definition.created_by Defined in XML R
pmse_bpm_activity_definition.modified_user_id Defined in XML R
pmse_bpm_activity_step.assigned_user_id Defined in XML R
pmse_bpm_activity_step.created_by Defined in XML R
pmse_bpm_activity_step.modified_user_id Defined in XML R
pmse_bpm_activity_user.assigned_user_id Defined in XML R
pmse_bpm_activity_user.created_by Defined in XML R
pmse_bpm_activity_user.modified_user_id Defined in XML R
pmse_bpm_config.assigned_user_id Defined in XML R
pmse_bpm_config.created_by Defined in XML R
pmse_bpm_config.modified_user_id Defined in XML R
pmse_bpm_dynamic_forms.assigned_user_id Defined in XML R
pmse_bpm_dynamic_forms.created_by Defined in XML R
pmse_bpm_dynamic_forms.modified_user_id Defined in XML R
pmse_bpm_event_definition.assigned_user_id Defined in XML R
pmse_bpm_event_definition.created_by Defined in XML R
pmse_bpm_event_definition.modified_user_id Defined in XML R
pmse_bpm_flow.assigned_user_id Defined in XML R
pmse_bpm_flow.created_by Defined in XML R
pmse_bpm_flow.modified_user_id Defined in XML R
pmse_bpm_form_action.assigned_user_id Defined in XML R
pmse_bpm_form_action.created_by Defined in XML R
pmse_bpm_form_action.modified_user_id Defined in XML R
pmse_bpm_gateway_definition.assigned_user_id Defined in XML R
pmse_bpm_gateway_definition.created_by Defined in XML R
pmse_bpm_gateway_definition.modified_user_id Defined in XML R
pmse_bpm_group.assigned_user_id Defined in XML R
pmse_bpm_group.created_by Defined in XML R
pmse_bpm_group.modified_user_id Defined in XML R
pmse_bpm_group_user.assigned_user_id Defined in XML R
pmse_bpm_group_user.created_by Defined in XML R
pmse_bpm_group_user.modified_user_id Defined in XML R
pmse_bpm_notes.assigned_user_id Defined in XML R
pmse_bpm_notes.created_by Defined in XML R
pmse_bpm_notes.modified_user_id Defined in XML R
pmse_bpm_process_definition.assigned_user_id Defined in XML R
pmse_bpm_process_definition.created_by Defined in XML R
pmse_bpm_process_definition.modified_user_id Defined in XML R
pmse_bpm_related_dependency.assigned_user_id Defined in XML R
pmse_bpm_related_dependency.created_by Defined in XML R
pmse_bpm_related_dependency.modified_user_id Defined in XML R
pmse_bpm_thread.assigned_user_id Defined in XML R
pmse_bpm_thread.created_by Defined in XML R
pmse_bpm_thread.modified_user_id Defined in XML R
pmse_bpmn_activity.assigned_user_id Defined in XML R
pmse_bpmn_activity.created_by Defined in XML R
pmse_bpmn_activity.modified_user_id Defined in XML R
pmse_bpmn_artifact.assigned_user_id Defined in XML R
pmse_bpmn_artifact.created_by Defined in XML R
pmse_bpmn_artifact.modified_user_id Defined in XML R
pmse_bpmn_bound.assigned_user_id Defined in XML R
pmse_bpmn_bound.created_by Defined in XML R
pmse_bpmn_bound.modified_user_id Defined in XML R
pmse_bpmn_data.assigned_user_id Defined in XML R
pmse_bpmn_data.created_by Defined in XML R
pmse_bpmn_data.modified_user_id Defined in XML R
pmse_bpmn_diagram.assigned_user_id Defined in XML R
pmse_bpmn_diagram.created_by Defined in XML R
pmse_bpmn_diagram.modified_user_id Defined in XML R
pmse_bpmn_documentation.assigned_user_id Defined in XML R
pmse_bpmn_documentation.created_by Defined in XML R
pmse_bpmn_documentation.modified_user_id Defined in XML R
pmse_bpmn_event.assigned_user_id Defined in XML R
pmse_bpmn_event.created_by Defined in XML R
pmse_bpmn_event.modified_user_id Defined in XML R
pmse_bpmn_extension.assigned_user_id Defined in XML R
pmse_bpmn_extension.created_by Defined in XML R
pmse_bpmn_extension.modified_user_id Defined in XML R
pmse_bpmn_flow.assigned_user_id Defined in XML R
pmse_bpmn_flow.created_by Defined in XML R
pmse_bpmn_flow.modified_user_id Defined in XML R
pmse_bpmn_gateway.assigned_user_id Defined in XML R
pmse_bpmn_gateway.created_by Defined in XML R
pmse_bpmn_gateway.modified_user_id Defined in XML R
pmse_bpmn_lane.assigned_user_id Defined in XML R
pmse_bpmn_lane.created_by Defined in XML R
pmse_bpmn_lane.modified_user_id Defined in XML R
pmse_bpmn_laneset.assigned_user_id Defined in XML R
pmse_bpmn_laneset.created_by Defined in XML R
pmse_bpmn_laneset.modified_user_id Defined in XML R
pmse_bpmn_participant.assigned_user_id Defined in XML R
pmse_bpmn_participant.created_by Defined in XML R
pmse_bpmn_participant.modified_user_id Defined in XML R
pmse_bpmn_process.assigned_user_id Defined in XML R
pmse_bpmn_process.created_by Defined in XML R
pmse_bpmn_process.modified_user_id Defined in XML R
pmse_business_rules.assigned_user_id Defined in XML R
pmse_business_rules.created_by Defined in XML R
pmse_business_rules.modified_user_id Defined in XML R
pmse_email_message.created_by Defined in XML R
pmse_email_message.modified_user_id Defined in XML R
pmse_emails_templates.assigned_user_id Defined in XML R
pmse_emails_templates.created_by Defined in XML R
pmse_emails_templates.modified_user_id Defined in XML R
pmse_inbox.assigned_user_id Defined in XML R
pmse_inbox.created_by Defined in XML R
pmse_inbox.modified_user_id Defined in XML R
pmse_project.assigned_user_id Defined in XML R
pmse_project.created_by Defined in XML R
pmse_project.modified_user_id Defined in XML R
product_categories.assigned_user_id Defined in XML R
product_categories.created_by Defined in XML R
product_categories.modified_user_id Defined in XML R
product_templates.assigned_user_id Defined in XML R
product_templates.created_by Defined in XML R
product_templates.modified_user_id Defined in XML R
product_types.created_by Defined in XML R
product_types.modified_user_id Defined in XML R
products.assigned_user_id Defined in XML R
products.created_by Defined in XML R
products.modified_user_id Defined in XML R
project.assigned_user_id Defined in XML R
project.created_by Defined in XML R
project.modified_user_id Defined in XML R
project_task.assigned_user_id Defined in XML R
project_task.created_by Defined in XML R
project_task.modified_user_id Defined in XML R
prospect_lists.assigned_user_id Defined in XML R
prospect_lists.created_by Defined in XML R
prospect_lists.modified_user_id Defined in XML R
prospects.assigned_user_id Defined in XML R
prospects.created_by Defined in XML R
prospects.modified_user_id Defined in XML R
purchased_line_items.assigned_user_id Defined in XML R
purchased_line_items.created_by Defined in XML R
purchased_line_items.modified_user_id Defined in XML R
purchases.assigned_user_id Defined in XML R
purchases.created_by Defined in XML R
purchases.modified_user_id Defined in XML R
push_notifications.assigned_user_id Defined in XML R
push_notifications.created_by Defined in XML R
push_notifications.modified_user_id Defined in XML R
quotas.assigned_user_id Defined in XML R
quotas.created_by Defined in XML R
quotas.modified_user_id Defined in XML R
quotas.user_id Defined in XML R
quotes.assigned_user_id Defined in XML R
quotes.created_by Defined in XML R
quotes.modified_user_id Defined in XML R
report_schedules.assigned_user_id Defined in XML R
report_schedules.created_by Defined in XML R
report_schedules.modified_user_id Defined in XML R
revenue_line_items.assigned_user_id Defined in XML R
revenue_line_items.created_by Defined in XML R
revenue_line_items.modified_user_id Defined in XML R
saved_reports.assigned_user_id Defined in XML R
saved_reports.created_by Defined in XML R
saved_reports.modified_user_id Defined in XML R
saved_search.assigned_user_id Defined in XML R
schedulers.created_by Defined in XML R
schedulers.modified_user_id Defined in XML R
shift_exceptions.assigned_user_id Defined in XML R
shift_exceptions.created_by Defined in XML R
shift_exceptions.modified_user_id Defined in XML R
shifts.assigned_user_id Defined in XML R
shifts.created_by Defined in XML R
shifts.modified_user_id Defined in XML R
shippers.created_by Defined in XML R
shippers.modified_user_id Defined in XML R
styleguide.assigned_user_id Defined in XML R
styleguide.created_by Defined in XML R
styleguide.modified_user_id Defined in XML R
subscriptions.created_by Defined in XML R
subscriptions.modified_user_id Defined in XML R
sugar_live.created_by Defined in XML R
sugar_live.modified_user_id Defined in XML R
sugarfavorites.assigned_user_id Defined in XML R
sugarfavorites.created_by Defined in XML R
sugarfavorites.modified_user_id Defined in XML R
tags.assigned_user_id Defined in XML R
tags.created_by Defined in XML R
tags.modified_user_id Defined in XML R
tasks.assigned_user_id Defined in XML R
tasks.created_by Defined in XML R
tasks.modified_user_id Defined in XML R
taxrates.created_by Defined in XML R
taxrates.modified_user_id Defined in XML R
teams.created_by Defined in XML R
teams.modified_user_id Defined in XML R
tracker.user_id Defined in XML R
users.reports_to_id Defined in XML R
users_signatures.created_by Defined in XML R
users_signatures.modified_user_id Defined in XML R
users_signatures.user_id Defined in XML R
visual_pipeline.created_by Defined in XML R
visual_pipeline.modified_user_id Defined in XML R
weblogichooks.created_by Defined in XML R
weblogichooks.modified_user_id Defined in XML R
messages_users.user_id Defined in XML R
project_resources.resource_id Defined in XML R
calls_users.user_id Defined in XML R
email_addr_bean_rel.bean_id Defined in XML R
shifts_users.user_id Defined in XML R
users.created_by Defined in XML R
acl_roles_users.user_id Defined in XML R
prospect_lists_prospects.related_id Defined in XML R
emails_beans.bean_id Defined in XML R
roles_users.user_id Defined in XML R
reportschedules_users.user_id Defined in XML R
shift_exceptions_users.user_id Defined in XML R
team_memberships.user_id Defined in XML R
meetings_users.user_id Defined in XML R
campaign_log.target_id Defined in XML R
activities_users.parent_id Defined in XML R
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
send_email_on_mention bit 1  √  0
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.id Defined in XML R
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
license_type text 65535  √  null
default_team char 36  √  null
teams.id Defined in XML R
team_set_id char 36  √  null
team_sets_teams.team_set_id Defined in XML R
team_sets.id Defined in XML R
acl_team_set_id char 36  √  null
business_center_id char 36  √  null
business_centers.id Defined in XML R
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.id Defined in XML R
is_group bit 1  √  0
preferred_language varchar 255  √  null
acl_role_set_id char 36  √  null
acl_role_sets.id Defined in XML R
site_user_id varchar 64  √  null
cookie_consent bit 1  √  0
cookie_consent_received_on datetime 19  √  null
sync_key varchar 100  √  null

Analyzed at Thu Jul 01 08:16 UTC 2021

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
last_login Performance Asc idx_last_login  
department Performance Asc idx_user_department  
first_name + last_name + deleted Performance Asc/Asc/Asc idx_user_first_last  
last_name + first_name + deleted Performance Asc/Asc/Asc idx_user_last_first  
user_name + is_group + status + last_name + first_name + id Performance Asc/Asc/Asc/Asc/Asc/Asc idx_user_name  
title Performance Asc idx_user_title  
status + is_admin + deleted Performance Asc/Asc/Asc idx_user_type_status  
reports_to_id + id Performance Asc/Asc idx_users_reports_to_id  
sync_key Must be unique Asc idx_users_skey This unique column is also nullable
team_set_id Performance Asc idx_users_tmst_id  

Close relationships  within of separation: