SchemaSpy - Table a90f811b.users

Generated by
SchemaSpy

Legend:

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

char

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
bugs.assigned_user_id	Defined in XML R
bugs.created_by	Defined in XML R
bugs.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.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
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
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
emails.assigned_user_id	Defined in XML R
emails.created_by	Defined in XML R
emails.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.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
kbdocument_revisions.created_by	Defined in XML R
kbdocuments.assigned_user_id	Defined in XML R
kbdocuments.created_by	Defined in XML R
kbdocuments.kbdoc_approver_id	Defined in XML R
kbdocuments.modified_user_id	Defined in XML R
kbdocuments_kbtags.created_by	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
meetings.assigned_user_id	Defined in XML R
meetings.created_by	Defined in XML R
meetings.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_access_management.assigned_user_id	Defined in XML R
pmse_bpm_access_management.created_by	Defined in XML R
pmse_bpm_access_management.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_case_data.assigned_user_id	Defined in XML R
pmse_bpm_case_data.created_by	Defined in XML R
pmse_bpm_case_data.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_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
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
prospects.assigned_user_id	Defined in XML R
prospects.created_by	Defined in XML R
prospects.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
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_search.assigned_user_id	Defined in XML R
schedulers.created_by	Defined in XML R
schedulers.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
sugarfavorites.assigned_user_id	Defined in XML R
sugarfavorites.created_by	Defined in XML R
sugarfavorites.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
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
weblogichooks.created_by	Defined in XML R
weblogichooks.modified_user_id	Defined in XML R

activities_users.parent_id	Defined in XML R
emails_beans.bean_id	Defined in XML R
campaign_log.target_id	Defined in XML R
acl_roles_users.user_id	Defined in XML R
roles_users.user_id	Defined in XML R
calls_users.user_id	Defined in XML R
project_resources.resource_id	Defined in XML R
prospect_lists_prospects.related_id	Defined in XML R
team_memberships.user_id	Defined in XML R
email_addr_bean_rel.bean_id	Defined in XML R
meetings_users.user_id	Defined in XML R

user_name

varchar

√

null

user_hash

varchar

255

√

null

system_generated_password

bit

√

null

pwd_last_changed

datetime

√

null

authenticate_id

varchar

100

√

null

sugar_login

bit

√

picture

varchar

255

√

null

first_name

varchar

√

null

last_name

varchar

√

null

is_admin

bit

√

external_auth_only

bit

√

receive_notifications

bit

√

description

text

65535

√

null

date_entered

datetime

√

null

date_modified

datetime

√

null

last_login

datetime

√

null

modified_user_id

char

√

null

created_by

char

√

null

title

varchar

√

null

department

varchar

√

null

phone_home

varchar

√

null

phone_mobile

varchar

√

null

phone_work

varchar

√

null

phone_other

varchar

√

null

phone_fax

varchar

√

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

√

null

default_team

char

√

null

teams.id

Defined in XML R

team_set_id

char

√

null

team_sets_teams.team_set_id	Defined in XML R
team_sets.id	Defined in XML R

deleted

bit

√

null

portal_only

bit

√

show_on_employees

bit

√

employee_status

varchar

100

√

null

messenger_id

varchar

100

√

null

messenger_type

varchar

100

√

null

reports_to_id

char

√

null

users.id

Defined in XML R

is_group

bit

√

null

preferred_language

varchar

255

√

null

acl_role_set_id

char

√

null

acl_role_sets.id

Defined in XML R

Analyzed at Mon Jun 15 09:07 UTC 2015

Indexes:

Column(s)	Type	Sort	Constraint Name
id	Primary key	Asc	PRIMARY
last_login	Performance	Asc	idx_last_login
department	Performance	Asc	idx_user_department
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
reports_to_id + id	Performance	Asc/Asc	idx_users_reports_to_id
team_set_id	Performance	Asc	idx_users_tmst_id