SchemaSpy Analysis of a1acf74egenerated Generated by
SchemaSpy
Generated on Thu Jun 08 08:25 UTC 2017
Database Type: MySQL - 5.6.26 SourceForge.net


XML Representation
Insertion Order Deletion Order

Table Children Parents Columns Comments
accounts 14 20 40
accounts_audit 1 10
accounts_bugs 2 5
accounts_cases 5
accounts_contacts 2 6
accounts_opportunities 5
acl_actions 1 10
acl_fields 10
acl_role_sets 1 5 9
acl_role_sets_acl_roles 5
acl_roles 2 8
acl_roles_actions 2 6
acl_roles_users 2 5
activities 1 5 12
activities_users 82 7
address_book 3
address_book_list_items 2
address_book_lists 3
bugs 5 18 24
bugs_audit 1 10
calls 1 26 36
calls_contacts 2 7
calls_leads 2 7
calls_users 2 7
campaign_log 5 5 16
campaign_trkrs 1 11
campaigns 12 11 29
campaigns_audit 1 10
cases 6 16 22
cases_audit 1 10
cases_bugs 2 5
categories 4 16
category_tree 4
comments 1 8
config 4
contacts 11 27 51
contacts_audit 1 10
contacts_bugs 2 6
contacts_cases 2 6
contacts_users 5
contract_types 1 1 8
contracts 1 16 25
contracts_audit 1 10
contracts_contacts 2 5
contracts_opportunities 5
contracts_products 2 5
contracts_quotes 2 5
currencies 11 10
custom_fields 13
custom_queries 3 15
dashboards 6 12
data_sets 3 28
dataset_attributes 18
dataset_layouts 13
document_revisions 3 14
documents 3 18 25
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_quotes 2 5
documents_revenuelineitems 2 5
eapm 5 18
email_addr_bean_rel 7 9
email_addresses 1 8
email_cache 16
email_marketing 3 17
email_marketing_prospect_lists 2 5
email_templates 1 6 21
emailman 1 15
emails 2 17 22
emails_beans 15 7
emails_email_addr_rel 5
emails_text 10
embedded_files 4 10
expressions 1 4 26
fields_meta_data 21
filters 8 15
folders 15
folders_rel 5
folders_subscriptions 3
forecast_manager_worksheets 9 29
forecast_manager_worksheets_audit 10
forecast_tree 5
forecast_worksheets 14 45
forecasts 2 17
fts_queue 6
holidays 2 13
import_maps 14
inbound_email 5 24
inbound_email_autoreply 6
inbound_email_cache_ts 2
job_queue 1 3 24
job_queue_audit 1 10
kbarticles 1 9 13
kbcontent_templates 8 12
kbcontent_templates_audit 1 10
kbcontents 6 16 29
kbcontents_audit 1 10
kbdocuments 2 8 12
kbusefulness 9
key_value_cache 3
leads 8 21 62
leads_audit 1 10
linked_documents 3 7
locked_field_bean_rel 47 6
manufacturers 3 9
meetings 1 27 44
meetings_contacts 2 7
meetings_leads 2 7
meetings_users 2 7
metadata_cache 5
notes 29 20
notifications 5 13
notifications_audit 10
oauth_consumer 1 5 13
oauth_nonce 3
oauth_tokens 3 13
opportunities 10 19 33
opportunities_audit 1 10
opportunities_contacts 2 6
outbound_email 12
pdfmanager 8 25
pmse_bpm_activity_definition 4 36
pmse_bpm_activity_step 4 14
pmse_bpm_activity_user 4 13
pmse_bpm_config 4 11
pmse_bpm_dynamic_forms 4 14
pmse_bpm_event_definition 4 18
pmse_bpm_flow 4 37
pmse_bpm_form_action 4 20
pmse_bpm_gateway_definition 4 12
pmse_bpm_group 4 11
pmse_bpm_group_user 4 10
pmse_bpm_notes 4 19
pmse_bpm_process_definition 5 15
pmse_bpm_related_dependency 4 46
pmse_bpm_thread 4 16
pmse_bpmn_activity 4 38
pmse_bpmn_artifact 4 14
pmse_bpmn_bound 4 22
pmse_bpmn_data 4 20
pmse_bpmn_diagram 4 12
pmse_bpmn_documentation 4 14
pmse_bpmn_event 4 31
pmse_bpmn_extension 4 14
pmse_bpmn_flow 4 27
pmse_bpmn_gateway 4 19
pmse_bpmn_lane 4 14
pmse_bpmn_laneset 4 15
pmse_bpmn_participant 4 17
pmse_bpmn_process 4 16
pmse_business_rules 7 22
pmse_emails_templates 7 21
pmse_inbox 7 26
pmse_project 7 23
product_bundle_note 2 6
product_bundle_notes 1 7
product_bundle_product 2 6
product_bundle_quote 6
product_bundles 8 29
product_categories 5 6 11
product_product 2 5
product_templates 3 11 35
product_templates_audit 1 10
product_types 3 5 9
products 3 28 62
products_audit 1 10
project 7 15 17
project_resources 3 8
project_task 5 9 35
project_task_audit 1 10
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 10 14
prospect_lists_prospects 6 6
prospects 6 14 44
quotas 8 17
quotas_audit 1 10
quotes 8 20 55
quotes_accounts 2 6
quotes_audit 1 10
quotes_contacts 2 6
quotes_opportunities 2 5
record_list 5
releases 2 9
report_cache 7
report_maker 3 14
report_schedules 10
revenue_line_items 5 21 67
revenue_line_items_audit 1 10
roles 1 9
roles_modules 6
roles_users 2 5
saved_reports 8 19
saved_search 4 12
schedulers 1 4 17
schedulers_times 7
session_active 9
session_history 9
shippers 1 11
styleguide 6 47
subscriptions 4 8
sugarfavorites 5 11
systems 12
tag_bean_rel 22 6
tags 7 13
tags_audit 1 10
tasks 3 24 21
tasks_audit 1 10
taxrates 2 4 11
team_memberships 2 7
team_notices 3 16
team_sets 43 1 7
team_sets_modules 4
team_sets_teams 45 5
teams 43 6 11
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 13
user_preferences 7
users 257 17 45
users_feeds 5
users_holidays 5
users_last_import 6
users_password_link 4
users_signatures 5 11
vcals 8
versions 9
weblogichooks 4 12
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
         
250 Tables     3,425  
0 Views     0