activities_users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
activity_id CHAR 36 null
activities.id Defined in XMLR
parent_type VARCHAR 100 √ null
parent_id CHAR 36 √ null
accounts.id Defined in XMLR
acl_role_sets.id Defined in XMLR
activities.id Defined in XMLR
bugs.id Defined in XMLR
business_centers.id Defined in XMLR
calls.id Defined in XMLR
campaigns.id Defined in XMLR
cases.id Defined in XMLR
categories.id Defined in XMLR
changetimers.id Defined in XMLR
commentlog.id Defined in XMLR
console_configuration.id Defined in XMLR
contacts.id Defined in XMLR
contract_types.id Defined in XMLR
contracts.id Defined in XMLR
dashboards.id Defined in XMLR
data_privacy.id Defined in XMLR
documents.id Defined in XMLR
eapm.id Defined in XMLR
embedded_files.id Defined in XMLR
filters.id Defined in XMLR
forecast_manager_worksheets.id Defined in XMLR
forecast_worksheets.id Defined in XMLR
kbarticles.id Defined in XMLR
kbcontent_templates.id Defined in XMLR
kbcontents.id Defined in XMLR
kbdocuments.id Defined in XMLR
leads.id Defined in XMLR
manufacturers.id Defined in XMLR
meetings.id Defined in XMLR
notes.id Defined in XMLR
notifications.id Defined in XMLR
oauth_consumer.id Defined in XMLR
opportunities.id Defined in XMLR
pdfmanager.id Defined in XMLR
pmse_bpm_activity_definition.id Defined in XMLR
pmse_bpm_activity_step.id Defined in XMLR
pmse_bpm_activity_user.id Defined in XMLR
pmse_bpm_config.id Defined in XMLR
pmse_bpm_dynamic_forms.id Defined in XMLR
pmse_bpm_event_definition.id Defined in XMLR
pmse_bpm_flow.id Defined in XMLR
pmse_bpm_form_action.id Defined in XMLR
pmse_bpm_gateway_definition.id Defined in XMLR
pmse_bpm_group.id Defined in XMLR
pmse_bpm_group_user.id Defined in XMLR
pmse_bpm_notes.id Defined in XMLR
pmse_bpm_process_definition.id Defined in XMLR
pmse_bpm_related_dependency.id Defined in XMLR
pmse_bpm_thread.id Defined in XMLR
pmse_bpmn_activity.id Defined in XMLR
pmse_bpmn_artifact.id Defined in XMLR
pmse_bpmn_bound.id Defined in XMLR
pmse_bpmn_data.id Defined in XMLR
pmse_bpmn_diagram.id Defined in XMLR
pmse_bpmn_documentation.id Defined in XMLR
pmse_bpmn_event.id Defined in XMLR
pmse_bpmn_extension.id Defined in XMLR
pmse_bpmn_flow.id Defined in XMLR
pmse_bpmn_gateway.id Defined in XMLR
pmse_bpmn_lane.id Defined in XMLR
pmse_bpmn_laneset.id Defined in XMLR
pmse_bpmn_participant.id Defined in XMLR
pmse_bpmn_process.id Defined in XMLR
pmse_business_rules.id Defined in XMLR
pmse_email_message.id Defined in XMLR
pmse_emails_templates.id Defined in XMLR
pmse_inbox.id Defined in XMLR
pmse_project.id Defined in XMLR
product_categories.id Defined in XMLR
product_templates.id Defined in XMLR
product_types.id Defined in XMLR
products.id Defined in XMLR
prospects.id Defined in XMLR
quotas.id Defined in XMLR
quotes.id Defined in XMLR
report_schedules.id Defined in XMLR
revenue_line_items.id Defined in XMLR
saved_reports.id Defined in XMLR
schedulers.id Defined in XMLR
shippers.id Defined in XMLR
styleguide.id Defined in XMLR
subscriptions.id Defined in XMLR
sugarfavorites.id Defined in XMLR
tags.id Defined in XMLR
tasks.id Defined in XMLR
taxrates.id Defined in XMLR
teams.id Defined in XMLR
users.id Defined in XMLR
users_signatures.id Defined in XMLR
visual_pipeline.id Defined in XMLR
weblogichooks.id Defined in XMLR
fields LONGTEXT 2147483647 √ null
date_modified DATETIME 26 √ null
deleted BIT 1 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
activities_records Performance Asc/Asc parent_type + parent_id
activities_users_parent Performance Asc/Asc/Asc activity_id + parent_id + parent_type

Relationships

Close relationships within degrees of separation