SchemaSpy Analysis of a86cab0agenerated Generated by
SchemaSpy
Generated on Thu Jun 17 08:21 UTC 2021
Database Type: MySQL - 5.7.23 SourceForge.net


XML Representation
Insertion Order Deletion Order

Table Children Parents Columns Comments
accounts 17 23 44
accounts_audit 1 12
accounts_bugs 2 5
accounts_cases 5
accounts_contacts 2 6
accounts_dataprivacy 2 5
accounts_opportunities 5
accounts_purchases 5
acl_actions 1 10
acl_fields 10
acl_role_sets 1 6 10
acl_role_sets_acl_roles 5
acl_roles 2 8
acl_roles_actions 2 6
acl_roles_users 2 5
activities 1 5 13
activities_users 103 7
address_book 3
address_book_list_items 2
address_book_lists 3
archive_runs 7 16
audit_events 6
bugs 7 19 29
bugs_audit 1 12
business_centers 5 12 54
business_centers_audit 1 12
business_centers_holidays 2 5
calls 2 30 40
calls_audit 1 12
calls_contacts 2 7
calls_leads 2 7
calls_users 2 7
campaign_log 5 5 16
campaign_trkrs 1 11
campaigns 12 12 30
campaigns_audit 1 12
cases 8 21 39
cases_audit 1 12
cases_bugs 2 5
cases_purchases 2 5
categories 4 17
category_tree 4
changetimers 6 17
commentlog 6 10
commentlog_rel 49 5
comments 1 9
config 4
console_configuration 6 13
contacts 13 31 60
contacts_audit 1 12
contacts_bugs 2 6
contacts_cases 2 6
contacts_dataprivacy 2 5
contacts_purchases 2 5
contacts_users 5
contract_types 1 7 10
contracts 2 19 26
contracts_audit 1 12
contracts_contacts 2 5
contracts_opportunities 5
contracts_products 2 5
contracts_quotes 2 5
currencies 13 11
custom_fields 13
custom_queries 3 15
dashboards 8 17
data_archivers 1 6 13
data_privacy 1 15 31
data_privacy_audit 1 12
data_sets 3 28
dataset_attributes 18
dataset_layouts 13
document_revisions 3 15
documents 3 21 26
documents_accounts 2 5
documents_bugs 2 5
documents_cases 2 5
documents_contacts 2 5
documents_opportunities 2 5
documents_products 2 5
documents_purchasedlineitems 2 5
documents_purchases 2 5
documents_quotes 2 5
documents_revenuelineitems 2 5
eapm 6 19
email_addr_bean_rel 7 9
email_addresses 3 1 9
email_addresses_audit 12
email_cache 16
email_marketing 3 17
email_marketing_prospect_lists 2 5
email_templates 2 7 22
emailman 1 15
emails 2 19 28
emails_beans 19 7
emails_email_addr_rel 2 9
emails_text 10
embedded_files 4 11
erased_fields 3
expressions 1 4 26
fields_meta_data 22
filters 8 16
folders 15
folders_rel 5
folders_subscriptions 3
forecast_manager_worksheets 9 30
forecast_manager_worksheets_audit 12
forecast_tree 5
forecast_worksheets 14 46
forecasts 2 17
fts_queue 6
holidays 5 14
import_maps 14
inbound_email 1 5 28
inbound_email_autoreply 6
inbound_email_cache_ts 2
job_queue 1 2 24
kbarticles 1 9 14
kbcontent_templates 8 13
kbcontent_templates_audit 1 12
kbcontents 7 17 30
kbcontents_audit 1 12
kbdocuments 2 8 13
kbusefulness 9
leads 9 24 66
leads_audit 1 12
leads_dataprivacy 2 5
linked_documents 3 7
locked_field_bean_rel 66 6
manufacturers 4 6 11
meetings 2 30 45
meetings_audit 1 12
meetings_contacts 2 7
meetings_leads 2 7
meetings_users 2 7
messages 29 24
messages_audit 1 12
metadata_cache 5
mobile_devices 5 12
notes 1 36 29
notes_audit 1 12
notifications 5 14
oauth_consumer 1 6 14
oauth_nonce 3
oauth_tokens 3 13
opportunities 13 21 41
opportunities_audit 1 12
opportunities_contacts 2 6
outbound_email 5 22
pdfmanager 9 26
pmse_bpm_activity_definition 4 45
pmse_bpm_activity_step 4 15
pmse_bpm_activity_user 4 14
pmse_bpm_config 4 12
pmse_bpm_dynamic_forms 4 15
pmse_bpm_event_definition 4 19
pmse_bpm_flow 4 38
pmse_bpm_form_action 4 21
pmse_bpm_gateway_definition 4 13
pmse_bpm_group 4 12
pmse_bpm_group_user 4 11
pmse_bpm_notes 4 20
pmse_bpm_process_definition 5 16
pmse_bpm_related_dependency 4 47
pmse_bpm_thread 4 17
pmse_bpmn_activity 4 39
pmse_bpmn_artifact 4 15
pmse_bpmn_bound 4 23
pmse_bpmn_data 4 21
pmse_bpmn_diagram 4 13
pmse_bpmn_documentation 4 15
pmse_bpmn_event 4 32
pmse_bpmn_extension 4 15
pmse_bpmn_flow 4 28
pmse_bpmn_gateway 4 20
pmse_bpmn_lane 4 15
pmse_bpmn_laneset 4 16
pmse_bpmn_participant 4 18
pmse_bpmn_process 4 17
pmse_business_rules 9 23
pmse_email_message 3 21
pmse_emails_templates 9 22
pmse_inbox 7 27
pmse_project 9 25
product_bundle_note 2 6
product_bundle_notes 1 7
product_bundle_product 2 6
product_bundle_quote 6
product_bundles 8 30
product_categories 7 6 12
product_definition 1
product_product 2 5
product_templates 5 15 44
product_templates_audit 1 12
product_types 5 6 10
products 4 31 77
products_audit 1 12
project 8 15 17
project_resources 3 8
project_task 6 9 35
project_task_audit 1 12
projects_accounts 2 5
projects_bugs 2 5
projects_cases 2 5
projects_contacts 2 5
projects_opportunities 2 5
projects_products 2 5
projects_quotes 2 5
projects_revenue_line_items 5
prospect_list_campaigns 2 5
prospect_lists 11 14
prospect_lists_prospects 6 6
prospects 7 17 47
prospects_audit 1 12
prospects_dataprivacy 2 5
purchased_line_items 6 22 75
purchased_line_items_audit 1 12
purchases 5 19 24
purchases_audit 1 12
push_notifications 5 15
quotas 9 18
quotas_audit 1 12
quotes 9 20 55
quotes_accounts 2 6
quotes_audit 1 12
quotes_contacts 2 6
quotes_opportunities 2 5
record_list 5
releases 2 9
report_cache 7
report_maker 3 14
report_schedules 11 20
report_schedules_audit 1 12
reportschedules_users 2 5
revenue_line_items 9 24 85
revenue_line_items_audit 1 12
roles 1 9
roles_modules 6
roles_users 2 5
saved_reports 1 8 20
saved_search 4 12
schedulers 1 5 19
schedulers_times 7
session_active 9
session_history 9
shift_exceptions 12 23
shift_exceptions_audit 1 12
shift_exceptions_users 2 5
shifts 12 51
shifts_audit 1 12
shifts_users 2 5
shippers 1 6 13
styleguide 6 48
subscriptions 4 9
sugar_live 6 10
sugarfavorites 6 12
tag_bean_rel 45 6
tags 7 14
tags_audit 1 12
tasks 4 27 22
tasks_audit 1 12
taxrates 2 6 12
team_memberships 2 7
team_notices 3 16
team_set_events 4
team_sets 54 1 7
team_sets_modules 4
team_sets_teams 56 5
team_sets_users_1 2
team_sets_users_2 2
teams 54 7 12
time_aware_schedules 6
timeperiods 1 1 15
tracker 3 12
tracker_perf 1 8
tracker_queries 1 9
tracker_sessions 9
tracker_tracker_queries 2 4
upgrade_history 17
user_preferences 7
users 312 21 52
users_holidays 5
users_last_import 6
users_password_link 7
users_signatures 7 12
vcals 8
versions 9
visual_pipeline 6 16
weblogichooks 4 13
workflow 3 1 15
workflow_actions 1 14
workflow_actionshells 3 1 12
workflow_alerts 1 1 19
workflow_alertshells 1 1 12
workflow_schedules 11
workflow_triggershells 1 1 15
         
296 Tables     4,346  
0 Views     0