Table aed81f59.activities_users Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
id char 36
activity_id char 36
activities
parent_type varchar 100  √  null
parent_id char 36  √  null
accounts
acl_role_sets
activities
bugs
calls
campaigns
cases
categories
contacts
contracts
dashboards
documents
eapm
embedded_files
filters
forecast_manager_worksheets
forecast_worksheets
kbarticles
kbcontent_templates
kbcontents
kbdocuments
leads
meetings
notes
notifications
oauth_consumer
opportunities
pdfmanager
pmse_bpm_activity_definition
pmse_bpm_activity_step
pmse_bpm_activity_user
pmse_bpm_config
pmse_bpm_dynamic_forms
pmse_bpm_event_definition
pmse_bpm_flow
pmse_bpm_form_action
pmse_bpm_gateway_definition
pmse_bpm_group
pmse_bpm_group_user
pmse_bpm_notes
pmse_bpm_process_definition
pmse_bpm_related_dependency
pmse_bpm_thread
pmse_bpmn_activity
pmse_bpmn_artifact
pmse_bpmn_bound
pmse_bpmn_data
pmse_bpmn_diagram
pmse_bpmn_documentation
pmse_bpmn_event
pmse_bpmn_extension
pmse_bpmn_flow
pmse_bpmn_gateway
pmse_bpmn_lane
pmse_bpmn_laneset
pmse_bpmn_participant
pmse_bpmn_process
pmse_business_rules
pmse_emails_templates
pmse_inbox
pmse_project
product_categories
product_templates
products
prospects
quotas
quotes
revenue_line_items
schedulers
styleguide
subscriptions
sugarfavorites
tags
tasks
taxrates
teams
users
users_signatures
weblogichooks
fields longtext 2147483647  √  null
date_modified datetime 19  √  null
deleted bit 1  √  0

Analyzed at Wed Jun 07 08:08 UTC 2017

Indexes:
Column(s) Type Sort
id Primary key Asc
parent_type + parent_id Performance Asc/Asc
activity_id + parent_id + parent_type Performance Asc/Asc/Asc

Close relationships  within of separation: