users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
accounts.assigned_user_id Defined in XML R
accounts.created_by Defined in XML R
accounts.modified_user_id Defined in XML R
acl_roles_users.user_id Defined in XML R
alerts.assigned_user_id Defined in XML R
alerts.created_by Defined in XML R
alerts.modified_user_id Defined in XML R
am_projecttemplates.assigned_user_id Defined in XML R
am_projecttemplates.created_by Defined in XML R
am_projecttemplates.modified_user_id Defined in XML R
am_projecttemplates_users_1_c.users_idb Defined in XML R
am_tasktemplates.assigned_user_id Defined in XML R
am_tasktemplates.created_by Defined in XML R
am_tasktemplates.modified_user_id Defined in XML R
aobh_businesshours.created_by Defined in XML R
aobh_businesshours.modified_user_id Defined in XML R
aod_index.assigned_user_id Defined in XML R
aod_index.created_by Defined in XML R
aod_index.modified_user_id Defined in XML R
aod_indexevent.assigned_user_id Defined in XML R
aod_indexevent.created_by Defined in XML R
aod_indexevent.modified_user_id Defined in XML R
aok_knowledge_base_categories.assigned_user_id Defined in XML R
aok_knowledge_base_categories.created_by Defined in XML R
aok_knowledge_base_categories.modified_user_id Defined in XML R
aok_knowledgebase.assigned_user_id Defined in XML R
aok_knowledgebase.created_by Defined in XML R
aok_knowledgebase.modified_user_id Defined in XML R
aop_case_events.assigned_user_id Defined in XML R
aop_case_events.created_by Defined in XML R
aop_case_events.modified_user_id Defined in XML R
aop_case_updates.assigned_user_id Defined in XML R
aop_case_updates.created_by Defined in XML R
aop_case_updates.modified_user_id Defined in XML R
aor_charts.created_by Defined in XML R
aor_charts.modified_user_id Defined in XML R
aor_conditions.created_by Defined in XML R
aor_conditions.modified_user_id Defined in XML R
aor_fields.created_by Defined in XML R
aor_fields.modified_user_id Defined in XML R
aor_reports.assigned_user_id Defined in XML R
aor_reports.created_by Defined in XML R
aor_reports.modified_user_id Defined in XML R
aor_scheduled_reports.created_by Defined in XML R
aor_scheduled_reports.modified_user_id Defined in XML R
aos_contracts.assigned_user_id Defined in XML R
aos_contracts.created_by Defined in XML R
aos_contracts.modified_user_id Defined in XML R
aos_invoices.assigned_user_id Defined in XML R
aos_invoices.created_by Defined in XML R
aos_invoices.modified_user_id Defined in XML R
aos_line_item_groups.assigned_user_id Defined in XML R
aos_line_item_groups.created_by Defined in XML R
aos_line_item_groups.modified_user_id Defined in XML R
aos_pdf_templates.assigned_user_id Defined in XML R
aos_pdf_templates.created_by Defined in XML R
aos_pdf_templates.modified_user_id Defined in XML R
aos_product_categories.assigned_user_id Defined in XML R
aos_product_categories.created_by Defined in XML R
aos_product_categories.modified_user_id Defined in XML R
aos_products.assigned_user_id Defined in XML R
aos_products.created_by Defined in XML R
aos_products.modified_user_id Defined in XML R
aos_products_quotes.assigned_user_id Defined in XML R
aos_products_quotes.created_by Defined in XML R
aos_products_quotes.modified_user_id Defined in XML R
aos_quotes.assigned_user_id Defined in XML R
aos_quotes.created_by Defined in XML R
aos_quotes.modified_user_id Defined in XML R
aow_actions.created_by Defined in XML R
aow_actions.modified_user_id Defined in XML R
aow_conditions.created_by Defined in XML R
aow_conditions.modified_user_id Defined in XML R
aow_processed.created_by Defined in XML R
aow_processed.modified_user_id Defined in XML R
aow_workflow.assigned_user_id Defined in XML R
aow_workflow.created_by Defined in XML R
aow_workflow.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
calendar_accounts.assigned_user_id Defined in XML R
calendar_accounts.calendar_user_id Defined in XML R
calendar_accounts.created_by Defined in XML R
calendar_accounts.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
calls_reschedule.assigned_user_id Defined in XML R
calls_reschedule.created_by Defined in XML R
calls_reschedule.modified_user_id Defined in XML R
calls_users.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
contacts_users.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_addr_bean_rel.bean_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
emails_beans.bean_id Defined in XML R
external_oauth_connections.created_by Defined in XML R
external_oauth_connections.modified_user_id Defined in XML R
external_oauth_providers.created_by Defined in XML R
external_oauth_providers.modified_user_id Defined in XML R
favorites.assigned_user_id Defined in XML R
favorites.created_by Defined in XML R
favorites.modified_user_id Defined in XML R
fp_event_locations.assigned_user_id Defined in XML R
fp_event_locations.created_by Defined in XML R
fp_event_locations.modified_user_id Defined in XML R
fp_events.assigned_user_id Defined in XML R
fp_events.created_by Defined in XML R
fp_events.modified_user_id Defined in XML R
inbound_email.created_by Defined in XML R
inbound_email.distribution_user_id Defined in XML R
inbound_email.modified_user_id Defined in XML R
jjwg_address_cache.assigned_user_id Defined in XML R
jjwg_address_cache.created_by Defined in XML R
jjwg_address_cache.modified_user_id Defined in XML R
jjwg_areas.assigned_user_id Defined in XML R
jjwg_areas.created_by Defined in XML R
jjwg_areas.modified_user_id Defined in XML R
jjwg_maps.assigned_user_id Defined in XML R
jjwg_maps.created_by Defined in XML R
jjwg_maps.modified_user_id Defined in XML R
jjwg_markers.assigned_user_id Defined in XML R
jjwg_markers.created_by Defined in XML R
jjwg_markers.modified_user_id Defined in XML R
job_queue.assigned_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
meetings.assigned_user_id Defined in XML R
meetings.created_by Defined in XML R
meetings.modified_user_id Defined in XML R
meetings_users.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
oauth2authcodes.assigned_user_id Defined in XML R
oauth2authcodes.created_by Defined in XML R
oauth2authcodes.modified_user_id Defined in XML R
oauth2clients.assigned_user_id Defined in XML R
oauth2clients.created_by Defined in XML R
oauth2clients.modified_user_id Defined in XML R
oauth2tokens.assigned_user_id Defined in XML R
oauth2tokens.created_by Defined in XML R
oauth2tokens.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
outbound_email.assigned_user_id Defined in XML R
outbound_email.created_by Defined in XML R
outbound_email.modified_user_id Defined in XML R
outbound_email.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
project_users_1_c.project_users_1users_idb Defined in XML R
prospect_lists.assigned_user_id Defined in XML R
prospect_lists_prospects.related_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
reminders.assigned_user_id Defined in XML R
reminders.created_by Defined in XML R
reminders.modified_user_id Defined in XML R
reminders_invitees.assigned_user_id Defined in XML R
reminders_invitees.created_by Defined in XML R
reminders_invitees.modified_user_id Defined in XML R
roles_users.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
securitygroups.assigned_user_id Defined in XML R
securitygroups.created_by Defined in XML R
securitygroups.modified_user_id Defined in XML R
securitygroups_users.user_id Defined in XML R
spots.assigned_user_id Defined in XML R
spots.created_by Defined in XML R
spots.modified_user_id Defined in XML R
sugarfeed.assigned_user_id Defined in XML R
sugarfeed.created_by Defined in XML R
sugarfeed.modified_user_id Defined in XML R
surveyquestionoptions.assigned_user_id Defined in XML R
surveyquestionoptions.created_by Defined in XML R
surveyquestionoptions.modified_user_id Defined in XML R
surveyquestionresponses.assigned_user_id Defined in XML R
surveyquestionresponses.created_by Defined in XML R
surveyquestionresponses.modified_user_id Defined in XML R
surveyquestions.assigned_user_id Defined in XML R
surveyquestions.created_by Defined in XML R
surveyquestions.modified_user_id Defined in XML R
surveyresponses.assigned_user_id Defined in XML R
surveyresponses.created_by Defined in XML R
surveyresponses.modified_user_id Defined in XML R
surveys.assigned_user_id Defined in XML R
surveys.created_by Defined in XML R
surveys.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
templatesectionline.created_by Defined in XML R
templatesectionline.modified_user_id Defined in XML R
users.reports_to_id Defined in XML R
users_signatures.user_id Defined in XML R
campaign_log.target_id Defined in XML R
user_name VARCHAR 60 √ NULL
user_hash VARCHAR 255 √ NULL
system_generated_password BOOLEAN 3 √ NULL
pwd_last_changed DATETIME 19 √ NULL
authenticate_id VARCHAR 100 √ NULL
sugar_login BOOLEAN 3 √ 1
first_name VARCHAR 255 √ NULL
last_name VARCHAR 255 √ NULL
is_admin BOOLEAN 3 √ 0
external_auth_only BOOLEAN 3 √ 0
receive_notifications BOOLEAN 3 √ 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
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 BOOLEAN 3 √ NULL
portal_only BOOLEAN 3 √ 0
show_on_employees BOOLEAN 3 √ 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 BOOLEAN 3 √ NULL
factor_auth BOOLEAN 3 √ 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