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_roles_users.user_id Defined in XMLR
alerts.assigned_user_id Defined in XMLR
alerts.created_by Defined in XMLR
alerts.modified_user_id Defined in XMLR
am_projecttemplates.assigned_user_id Defined in XMLR
am_projecttemplates.created_by Defined in XMLR
am_projecttemplates.modified_user_id Defined in XMLR
am_projecttemplates_users_1_c.users_idb Defined in XMLR
am_tasktemplates.assigned_user_id Defined in XMLR
am_tasktemplates.created_by Defined in XMLR
am_tasktemplates.modified_user_id Defined in XMLR
aobh_businesshours.created_by Defined in XMLR
aobh_businesshours.modified_user_id Defined in XMLR
aod_index.assigned_user_id Defined in XMLR
aod_index.created_by Defined in XMLR
aod_index.modified_user_id Defined in XMLR
aod_indexevent.assigned_user_id Defined in XMLR
aod_indexevent.created_by Defined in XMLR
aod_indexevent.modified_user_id Defined in XMLR
aok_knowledge_base_categories.assigned_user_id Defined in XMLR
aok_knowledge_base_categories.created_by Defined in XMLR
aok_knowledge_base_categories.modified_user_id Defined in XMLR
aok_knowledgebase.assigned_user_id Defined in XMLR
aok_knowledgebase.created_by Defined in XMLR
aok_knowledgebase.modified_user_id Defined in XMLR
aop_case_events.assigned_user_id Defined in XMLR
aop_case_events.created_by Defined in XMLR
aop_case_events.modified_user_id Defined in XMLR
aop_case_updates.assigned_user_id Defined in XMLR
aop_case_updates.created_by Defined in XMLR
aop_case_updates.modified_user_id Defined in XMLR
aor_charts.created_by Defined in XMLR
aor_charts.modified_user_id Defined in XMLR
aor_conditions.created_by Defined in XMLR
aor_conditions.modified_user_id Defined in XMLR
aor_fields.created_by Defined in XMLR
aor_fields.modified_user_id Defined in XMLR
aor_reports.assigned_user_id Defined in XMLR
aor_reports.created_by Defined in XMLR
aor_reports.modified_user_id Defined in XMLR
aor_scheduled_reports.created_by Defined in XMLR
aor_scheduled_reports.modified_user_id Defined in XMLR
aos_contracts.assigned_user_id Defined in XMLR
aos_contracts.created_by Defined in XMLR
aos_contracts.modified_user_id Defined in XMLR
aos_invoices.assigned_user_id Defined in XMLR
aos_invoices.created_by Defined in XMLR
aos_invoices.modified_user_id Defined in XMLR
aos_line_item_groups.assigned_user_id Defined in XMLR
aos_line_item_groups.created_by Defined in XMLR
aos_line_item_groups.modified_user_id Defined in XMLR
aos_pdf_templates.assigned_user_id Defined in XMLR
aos_pdf_templates.created_by Defined in XMLR
aos_pdf_templates.modified_user_id Defined in XMLR
aos_product_categories.assigned_user_id Defined in XMLR
aos_product_categories.created_by Defined in XMLR
aos_product_categories.modified_user_id Defined in XMLR
aos_products.assigned_user_id Defined in XMLR
aos_products.created_by Defined in XMLR
aos_products.modified_user_id Defined in XMLR
aos_products_quotes.assigned_user_id Defined in XMLR
aos_products_quotes.created_by Defined in XMLR
aos_products_quotes.modified_user_id Defined in XMLR
aos_quotes.assigned_user_id Defined in XMLR
aos_quotes.created_by Defined in XMLR
aos_quotes.modified_user_id Defined in XMLR
aow_actions.created_by Defined in XMLR
aow_actions.modified_user_id Defined in XMLR
aow_conditions.created_by Defined in XMLR
aow_conditions.modified_user_id Defined in XMLR
aow_processed.created_by Defined in XMLR
aow_processed.modified_user_id Defined in XMLR
aow_workflow.assigned_user_id Defined in XMLR
aow_workflow.created_by Defined in XMLR
aow_workflow.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
calls.assigned_user_id Defined in XMLR
calls.created_by Defined in XMLR
calls.modified_user_id Defined in XMLR
calls_reschedule.assigned_user_id Defined in XMLR
calls_reschedule.created_by Defined in XMLR
calls_reschedule.modified_user_id Defined in XMLR
calls_users.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.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
contacts_users.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_addr_bean_rel.bean_id Defined in XMLR
email_templates.assigned_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
emails_beans.bean_id Defined in XMLR
favorites.assigned_user_id Defined in XMLR
favorites.created_by Defined in XMLR
favorites.modified_user_id Defined in XMLR
fp_event_locations.assigned_user_id Defined in XMLR
fp_event_locations.created_by Defined in XMLR
fp_event_locations.modified_user_id Defined in XMLR
fp_events.assigned_user_id Defined in XMLR
fp_events.created_by Defined in XMLR
fp_events.modified_user_id Defined in XMLR
inbound_email.created_by Defined in XMLR
inbound_email.modified_user_id Defined in XMLR
jjwg_address_cache.assigned_user_id Defined in XMLR
jjwg_address_cache.created_by Defined in XMLR
jjwg_address_cache.modified_user_id Defined in XMLR
jjwg_areas.assigned_user_id Defined in XMLR
jjwg_areas.created_by Defined in XMLR
jjwg_areas.modified_user_id Defined in XMLR
jjwg_maps.assigned_user_id Defined in XMLR
jjwg_maps.created_by Defined in XMLR
jjwg_maps.modified_user_id Defined in XMLR
jjwg_markers.assigned_user_id Defined in XMLR
jjwg_markers.created_by Defined in XMLR
jjwg_markers.modified_user_id Defined in XMLR
job_queue.assigned_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
meetings.assigned_user_id Defined in XMLR
meetings.created_by Defined in XMLR
meetings.modified_user_id Defined in XMLR
meetings_users.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
oauth2clients.assigned_user_id Defined in XMLR
oauth2clients.created_by Defined in XMLR
oauth2clients.modified_user_id Defined in XMLR
oauth2tokens.assigned_user_id Defined in XMLR
oauth2tokens.created_by Defined in XMLR
oauth2tokens.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
outbound_email.assigned_user_id Defined in XMLR
outbound_email.created_by Defined in XMLR
outbound_email.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
project_users_1_c.project_users_1users_idb Defined in XMLR
prospect_lists.assigned_user_id Defined in XMLR
prospect_lists_prospects.related_id Defined in XMLR
prospects.assigned_user_id Defined in XMLR
prospects.created_by Defined in XMLR
prospects.modified_user_id Defined in XMLR
reminders.assigned_user_id Defined in XMLR
reminders.created_by Defined in XMLR
reminders.modified_user_id Defined in XMLR
reminders_invitees.assigned_user_id Defined in XMLR
reminders_invitees.created_by Defined in XMLR
reminders_invitees.modified_user_id Defined in XMLR
roles_users.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
securitygroups.assigned_user_id Defined in XMLR
securitygroups.created_by Defined in XMLR
securitygroups.modified_user_id Defined in XMLR
securitygroups_users.user_id Defined in XMLR
spots.assigned_user_id Defined in XMLR
spots.created_by Defined in XMLR
spots.modified_user_id Defined in XMLR
sugarfeed.assigned_user_id Defined in XMLR
sugarfeed.created_by Defined in XMLR
sugarfeed.modified_user_id Defined in XMLR
surveyquestionoptions.assigned_user_id Defined in XMLR
surveyquestionoptions.created_by Defined in XMLR
surveyquestionoptions.modified_user_id Defined in XMLR
surveyquestionresponses.assigned_user_id Defined in XMLR
surveyquestionresponses.created_by Defined in XMLR
surveyquestionresponses.modified_user_id Defined in XMLR
surveyquestions.assigned_user_id Defined in XMLR
surveyquestions.created_by Defined in XMLR
surveyquestions.modified_user_id Defined in XMLR
surveyresponses.assigned_user_id Defined in XMLR
surveyresponses.created_by Defined in XMLR
surveyresponses.modified_user_id Defined in XMLR
surveys.assigned_user_id Defined in XMLR
surveys.created_by Defined in XMLR
surveys.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
templatesectionline.created_by Defined in XMLR
templatesectionline.modified_user_id Defined in XMLR
users.reports_to_id Defined in XMLR
campaign_log.target_id Defined in XMLR
user_name VARCHAR 60 √ null
user_hash VARCHAR 255 √ null
system_generated_password BIT 1 √ null
pwd_last_changed DATETIME 26 √ null
authenticate_id VARCHAR 100 √ null
sugar_login BIT 1 √ 1
first_name VARCHAR 255 √ null
last_name VARCHAR 255 √ null
is_admin BIT 1 √ 0
external_auth_only BIT 1 √ 0
receive_notifications BIT 1 √ 1
description TEXT 65535 √ null
date_entered DATETIME 26 √ null
date_modified DATETIME 26 √ null
modified_user_id CHAR 36 √ null
created_by CHAR 36 √ null
title VARCHAR 50 √ null
photo VARCHAR 255 √ 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.id Defined in XMLR
is_group BIT 1 √ null
factor_auth BIT 1 √ null
factor_auth_interface VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_user_name Performance Asc/Asc/Asc/Asc/Asc/Asc user_name + is_group + status + last_name + first_name + id

Relationships

Close relationships within degrees of separation