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
calendar.id Defined in XMLR
calls.id Defined in XMLR
campaigns.id Defined in XMLR
cases.id Defined in XMLR
categories.id Defined in XMLR
commentlog.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
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
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
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