users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
accounts.assigned_user_id Defined in XMLR
accounts.created_by Defined in XMLR
accounts.modified_user_id Defined in XMLR
acl_role_sets.created_by Defined in XMLR
acl_role_sets.modified_user_id Defined in XMLR
activities.created_by Defined in XMLR
activities.modified_user_id Defined in XMLR
archive_runs.created_by Defined in XMLR
archive_runs.modified_user_id Defined in XMLR
bugs.assigned_user_id Defined in XMLR
bugs.created_by Defined in XMLR
bugs.modified_user_id Defined in XMLR
business_centers.assigned_user_id Defined in XMLR
business_centers.created_by Defined in XMLR
business_centers.modified_user_id Defined in XMLR
calls.assigned_user_id Defined in XMLR
calls.created_by Defined in XMLR
calls.modified_user_id Defined in XMLR
campaigns.assigned_user_id Defined in XMLR
campaigns.created_by Defined in XMLR
campaigns.modified_user_id Defined in XMLR
cases.assigned_user_id Defined in XMLR
cases.created_by Defined in XMLR
cases.first_response_user_id Defined in XMLR
cases.modified_user_id Defined in XMLR
categories.created_by Defined in XMLR
categories.modified_user_id Defined in XMLR
changetimers.created_by Defined in XMLR
changetimers.modified_user_id Defined in XMLR
commentlog.created_by Defined in XMLR
commentlog.modified_user_id Defined in XMLR
console_configuration.created_by Defined in XMLR
console_configuration.modified_user_id Defined in XMLR
contacts.assigned_user_id Defined in XMLR
contacts.created_by Defined in XMLR
contacts.modified_user_id Defined in XMLR
contract_types.created_by Defined in XMLR
contract_types.modified_user_id Defined in XMLR
contracts.assigned_user_id Defined in XMLR
contracts.created_by Defined in XMLR
contracts.modified_user_id Defined in XMLR
dashboards.assigned_user_id Defined in XMLR
dashboards.created_by Defined in XMLR
dashboards.modified_user_id Defined in XMLR
data_archivers.created_by Defined in XMLR
data_archivers.modified_user_id Defined in XMLR
data_privacy.assigned_user_id Defined in XMLR
data_privacy.created_by Defined in XMLR
data_privacy.modified_user_id Defined in XMLR
document_revisions.created_by Defined in XMLR
documents.assigned_user_id Defined in XMLR
documents.created_by Defined in XMLR
documents.modified_user_id Defined in XMLR
eapm.assigned_user_id Defined in XMLR
eapm.created_by Defined in XMLR
eapm.modified_user_id Defined in XMLR
email_templates.assigned_user_id Defined in XMLR
email_templates.created_by Defined in XMLR
email_templates.modified_user_id Defined in XMLR
emails.assigned_user_id Defined in XMLR
emails.created_by Defined in XMLR
emails.modified_user_id Defined in XMLR
embedded_files.created_by Defined in XMLR
embedded_files.modified_user_id Defined in XMLR
filters.assigned_user_id Defined in XMLR
filters.created_by Defined in XMLR
filters.modified_user_id Defined in XMLR
forecast_manager_worksheets.assigned_user_id Defined in XMLR
forecast_manager_worksheets.created_by Defined in XMLR
forecast_manager_worksheets.modified_user_id Defined in XMLR
forecast_worksheets.assigned_user_id Defined in XMLR
forecast_worksheets.created_by Defined in XMLR
forecast_worksheets.modified_user_id Defined in XMLR
forecasts.user_id Defined in XMLR
holidays.created_by Defined in XMLR
holidays.modified_user_id Defined in XMLR
holidays.person_id Defined in XMLR
inbound_email.created_by Defined in XMLR
inbound_email.modified_user_id Defined in XMLR
job_queue.assigned_user_id Defined in XMLR
kbarticles.assigned_user_id Defined in XMLR
kbarticles.created_by Defined in XMLR
kbarticles.modified_user_id Defined in XMLR
kbcontent_templates.created_by Defined in XMLR
kbcontent_templates.modified_user_id Defined in XMLR
kbcontents.assigned_user_id Defined in XMLR
kbcontents.created_by Defined in XMLR
kbcontents.kbsapprover_id Defined in XMLR
kbcontents.modified_user_id Defined in XMLR
kbdocuments.assigned_user_id Defined in XMLR
kbdocuments.created_by Defined in XMLR
kbdocuments.modified_user_id Defined in XMLR
leads.assigned_user_id Defined in XMLR
leads.created_by Defined in XMLR
leads.modified_user_id Defined in XMLR
manufacturers.created_by Defined in XMLR
manufacturers.modified_user_id Defined in XMLR
meetings.assigned_user_id Defined in XMLR
meetings.created_by Defined in XMLR
meetings.modified_user_id Defined in XMLR
messages.assigned_user_id Defined in XMLR
messages.created_by Defined in XMLR
messages.modified_user_id Defined in XMLR
mobile_devices.assigned_user_id Defined in XMLR
mobile_devices.created_by Defined in XMLR
mobile_devices.modified_user_id Defined in XMLR
notes.assigned_user_id Defined in XMLR
notes.created_by Defined in XMLR
notes.modified_user_id Defined in XMLR
notifications.assigned_user_id Defined in XMLR
notifications.created_by Defined in XMLR
notifications.modified_user_id Defined in XMLR
oauth_consumer.assigned_user_id Defined in XMLR
oauth_consumer.created_by Defined in XMLR
oauth_consumer.modified_user_id Defined in XMLR
oauth_tokens.assigned_user_id Defined in XMLR
opportunities.assigned_user_id Defined in XMLR
opportunities.created_by Defined in XMLR
opportunities.modified_user_id Defined in XMLR
pdfmanager.assigned_user_id Defined in XMLR
pdfmanager.created_by Defined in XMLR
pdfmanager.modified_user_id Defined in XMLR
pmse_bpm_activity_definition.assigned_user_id Defined in XMLR
pmse_bpm_activity_definition.created_by Defined in XMLR
pmse_bpm_activity_definition.modified_user_id Defined in XMLR
pmse_bpm_activity_step.assigned_user_id Defined in XMLR
pmse_bpm_activity_step.created_by Defined in XMLR
pmse_bpm_activity_step.modified_user_id Defined in XMLR
pmse_bpm_activity_user.assigned_user_id Defined in XMLR
pmse_bpm_activity_user.created_by Defined in XMLR
pmse_bpm_activity_user.modified_user_id Defined in XMLR
pmse_bpm_config.assigned_user_id Defined in XMLR
pmse_bpm_config.created_by Defined in XMLR
pmse_bpm_config.modified_user_id Defined in XMLR
pmse_bpm_dynamic_forms.assigned_user_id Defined in XMLR
pmse_bpm_dynamic_forms.created_by Defined in XMLR
pmse_bpm_dynamic_forms.modified_user_id Defined in XMLR
pmse_bpm_event_definition.assigned_user_id Defined in XMLR
pmse_bpm_event_definition.created_by Defined in XMLR
pmse_bpm_event_definition.modified_user_id Defined in XMLR
pmse_bpm_flow.assigned_user_id Defined in XMLR
pmse_bpm_flow.created_by Defined in XMLR
pmse_bpm_flow.modified_user_id Defined in XMLR
pmse_bpm_form_action.assigned_user_id Defined in XMLR
pmse_bpm_form_action.created_by Defined in XMLR
pmse_bpm_form_action.modified_user_id Defined in XMLR
pmse_bpm_gateway_definition.assigned_user_id Defined in XMLR
pmse_bpm_gateway_definition.created_by Defined in XMLR
pmse_bpm_gateway_definition.modified_user_id Defined in XMLR
pmse_bpm_group.assigned_user_id Defined in XMLR
pmse_bpm_group.created_by Defined in XMLR
pmse_bpm_group.modified_user_id Defined in XMLR
pmse_bpm_group_user.assigned_user_id Defined in XMLR
pmse_bpm_group_user.created_by Defined in XMLR
pmse_bpm_group_user.modified_user_id Defined in XMLR
pmse_bpm_notes.assigned_user_id Defined in XMLR
pmse_bpm_notes.created_by Defined in XMLR
pmse_bpm_notes.modified_user_id Defined in XMLR
pmse_bpm_process_definition.assigned_user_id Defined in XMLR
pmse_bpm_process_definition.created_by Defined in XMLR
pmse_bpm_process_definition.modified_user_id Defined in XMLR
pmse_bpm_related_dependency.assigned_user_id Defined in XMLR
pmse_bpm_related_dependency.created_by Defined in XMLR
pmse_bpm_related_dependency.modified_user_id Defined in XMLR
pmse_bpm_thread.assigned_user_id Defined in XMLR
pmse_bpm_thread.created_by Defined in XMLR
pmse_bpm_thread.modified_user_id Defined in XMLR
pmse_bpmn_activity.assigned_user_id Defined in XMLR
pmse_bpmn_activity.created_by Defined in XMLR
pmse_bpmn_activity.modified_user_id Defined in XMLR
pmse_bpmn_artifact.assigned_user_id Defined in XMLR
pmse_bpmn_artifact.created_by Defined in XMLR
pmse_bpmn_artifact.modified_user_id Defined in XMLR
pmse_bpmn_bound.assigned_user_id Defined in XMLR
pmse_bpmn_bound.created_by Defined in XMLR
pmse_bpmn_bound.modified_user_id Defined in XMLR
pmse_bpmn_data.assigned_user_id Defined in XMLR
pmse_bpmn_data.created_by Defined in XMLR
pmse_bpmn_data.modified_user_id Defined in XMLR
pmse_bpmn_diagram.assigned_user_id Defined in XMLR
pmse_bpmn_diagram.created_by Defined in XMLR
pmse_bpmn_diagram.modified_user_id Defined in XMLR
pmse_bpmn_documentation.assigned_user_id Defined in XMLR
pmse_bpmn_documentation.created_by Defined in XMLR
pmse_bpmn_documentation.modified_user_id Defined in XMLR
pmse_bpmn_event.assigned_user_id Defined in XMLR
pmse_bpmn_event.created_by Defined in XMLR
pmse_bpmn_event.modified_user_id Defined in XMLR
pmse_bpmn_extension.assigned_user_id Defined in XMLR
pmse_bpmn_extension.created_by Defined in XMLR
pmse_bpmn_extension.modified_user_id Defined in XMLR
pmse_bpmn_flow.assigned_user_id Defined in XMLR
pmse_bpmn_flow.created_by Defined in XMLR
pmse_bpmn_flow.modified_user_id Defined in XMLR
pmse_bpmn_gateway.assigned_user_id Defined in XMLR
pmse_bpmn_gateway.created_by Defined in XMLR
pmse_bpmn_gateway.modified_user_id Defined in XMLR
pmse_bpmn_lane.assigned_user_id Defined in XMLR
pmse_bpmn_lane.created_by Defined in XMLR
pmse_bpmn_lane.modified_user_id Defined in XMLR
pmse_bpmn_laneset.assigned_user_id Defined in XMLR
pmse_bpmn_laneset.created_by Defined in XMLR
pmse_bpmn_laneset.modified_user_id Defined in XMLR
pmse_bpmn_participant.assigned_user_id Defined in XMLR
pmse_bpmn_participant.created_by Defined in XMLR
pmse_bpmn_participant.modified_user_id Defined in XMLR
pmse_bpmn_process.assigned_user_id Defined in XMLR
pmse_bpmn_process.created_by Defined in XMLR
pmse_bpmn_process.modified_user_id Defined in XMLR
pmse_business_rules.assigned_user_id Defined in XMLR
pmse_business_rules.created_by Defined in XMLR
pmse_business_rules.modified_user_id Defined in XMLR
pmse_email_message.created_by Defined in XMLR
pmse_email_message.modified_user_id Defined in XMLR
pmse_emails_templates.assigned_user_id Defined in XMLR
pmse_emails_templates.created_by Defined in XMLR
pmse_emails_templates.modified_user_id Defined in XMLR
pmse_inbox.assigned_user_id Defined in XMLR
pmse_inbox.created_by Defined in XMLR
pmse_inbox.modified_user_id Defined in XMLR
pmse_project.assigned_user_id Defined in XMLR
pmse_project.created_by Defined in XMLR
pmse_project.modified_user_id Defined in XMLR
product_categories.assigned_user_id Defined in XMLR
product_categories.created_by Defined in XMLR
product_categories.modified_user_id Defined in XMLR
product_templates.assigned_user_id Defined in XMLR
product_templates.created_by Defined in XMLR
product_templates.modified_user_id Defined in XMLR
product_types.created_by Defined in XMLR
product_types.modified_user_id Defined in XMLR
products.assigned_user_id Defined in XMLR
products.created_by Defined in XMLR
products.modified_user_id Defined in XMLR
project.assigned_user_id Defined in XMLR
project.created_by Defined in XMLR
project.modified_user_id Defined in XMLR
project_task.assigned_user_id Defined in XMLR
project_task.created_by Defined in XMLR
project_task.modified_user_id Defined in XMLR
prospect_lists.assigned_user_id Defined in XMLR
prospect_lists.created_by Defined in XMLR
prospect_lists.modified_user_id Defined in XMLR
prospects.assigned_user_id Defined in XMLR
prospects.created_by Defined in XMLR
prospects.modified_user_id Defined in XMLR
purchased_line_items.assigned_user_id Defined in XMLR
purchased_line_items.created_by Defined in XMLR
purchased_line_items.modified_user_id Defined in XMLR
purchases.assigned_user_id Defined in XMLR
purchases.created_by Defined in XMLR
purchases.modified_user_id Defined in XMLR
push_notifications.assigned_user_id Defined in XMLR
push_notifications.created_by Defined in XMLR
push_notifications.modified_user_id Defined in XMLR
quotas.assigned_user_id Defined in XMLR
quotas.created_by Defined in XMLR
quotas.modified_user_id Defined in XMLR
quotas.user_id Defined in XMLR
quotes.assigned_user_id Defined in XMLR
quotes.created_by Defined in XMLR
quotes.modified_user_id Defined in XMLR
report_schedules.assigned_user_id Defined in XMLR
report_schedules.created_by Defined in XMLR
report_schedules.modified_user_id Defined in XMLR
revenue_line_items.assigned_user_id Defined in XMLR
revenue_line_items.created_by Defined in XMLR
revenue_line_items.modified_user_id Defined in XMLR
saved_reports.assigned_user_id Defined in XMLR
saved_reports.created_by Defined in XMLR
saved_reports.modified_user_id Defined in XMLR
saved_search.assigned_user_id Defined in XMLR
schedulers.created_by Defined in XMLR
schedulers.modified_user_id Defined in XMLR
shift_exceptions.assigned_user_id Defined in XMLR
shift_exceptions.created_by Defined in XMLR
shift_exceptions.modified_user_id Defined in XMLR
shifts.assigned_user_id Defined in XMLR
shifts.created_by Defined in XMLR
shifts.modified_user_id Defined in XMLR
shippers.created_by Defined in XMLR
shippers.modified_user_id Defined in XMLR
styleguide.assigned_user_id Defined in XMLR
styleguide.created_by Defined in XMLR
styleguide.modified_user_id Defined in XMLR
subscriptions.created_by Defined in XMLR
subscriptions.modified_user_id Defined in XMLR
sugar_live.created_by Defined in XMLR
sugar_live.modified_user_id Defined in XMLR
sugarfavorites.assigned_user_id Defined in XMLR
sugarfavorites.created_by Defined in XMLR
sugarfavorites.modified_user_id Defined in XMLR
tags.assigned_user_id Defined in XMLR
tags.created_by Defined in XMLR
tags.modified_user_id Defined in XMLR
tasks.assigned_user_id Defined in XMLR
tasks.created_by Defined in XMLR
tasks.modified_user_id Defined in XMLR
taxrates.created_by Defined in XMLR
taxrates.modified_user_id Defined in XMLR
teams.created_by Defined in XMLR
teams.modified_user_id Defined in XMLR
tracker.user_id Defined in XMLR
users.reports_to_id Defined in XMLR
users_signatures.created_by Defined in XMLR
users_signatures.modified_user_id Defined in XMLR
users_signatures.user_id Defined in XMLR
visual_pipeline.created_by Defined in XMLR
visual_pipeline.modified_user_id Defined in XMLR
weblogichooks.created_by Defined in XMLR
weblogichooks.modified_user_id Defined in XMLR
acl_roles_users.user_id Defined in XMLR
email_addr_bean_rel.bean_id Defined in XMLR
campaign_log.target_id Defined in XMLR
prospect_lists_prospects.related_id Defined in XMLR
shift_exceptions_users.user_id Defined in XMLR
meetings_users.user_id Defined in XMLR
emails_beans.bean_id Defined in XMLR
reportschedules_users.user_id Defined in XMLR
team_memberships.user_id Defined in XMLR
roles_users.user_id Defined in XMLR
calls_users.user_id Defined in XMLR
activities_users.parent_id Defined in XMLR
users.created_by Defined in XMLR
shifts_users.user_id Defined in XMLR
project_resources.resource_id Defined in XMLR
user_name VARCHAR 60 √ null
user_hash VARCHAR 255 √ null
system_generated_password BIT 1 √ 0
pwd_last_changed DATETIME 26 √ 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 26 √ null
date_modified DATETIME 26 √ null
last_login DATETIME 26 √ null
modified_user_id CHAR 36 √ null
created_by CHAR 36 √ null
users.id Defined in XMLR
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 XMLR
team_set_id CHAR 36 √ null
team_sets_teams.team_set_id Defined in XMLR
team_sets.id Defined in XMLR
acl_team_set_id CHAR 36 √ null
business_center_id CHAR 36 √ null
business_centers.id Defined in XMLR
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 XMLR
is_group BIT 1 √ 0
preferred_language VARCHAR 255 √ null
acl_role_set_id CHAR 36 √ null
acl_role_sets.id Defined in XMLR
site_user_id VARCHAR 64 √ null
cookie_consent BIT 1 √ 0
cookie_consent_received_on DATETIME 26 √ null
sync_key VARCHAR 100 √ null

Indexes

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

Relationships

Close relationships within degrees of separation