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
archive_runs.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_archivers.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
messages.id Defined in XMLR
mobile_devices.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
purchased_line_items.id Defined in XMLR
purchases.id Defined in XMLR
push_notifications.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
shift_exceptions.id Defined in XMLR
shifts.id Defined in XMLR
shippers.id Defined in XMLR
styleguide.id Defined in XMLR
subscriptions.id Defined in XMLR
sugar_live.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