SchemaSpy Analysis of afc273bbgenerated Generated by
SchemaSpy
Generated on Wed Oct 21 20:21 UTC 2015
Database Type: MySQL - 5.5.22-0ubuntu1 SourceForge.net

XML Representation
Insertion Order Deletion Order

Table Children Parents Columns Comments
accounts 11 18 35
accounts_audit 1 10
accounts_bugs 2 5
accounts_cases 5
accounts_contacts 2 5
accounts_opportunities 2 5
acl_actions 1 10
acl_fields 10
acl_roles 2 8
acl_roles_actions 2 6
acl_roles_users 2 5
address_book 3
address_book_list_items 2
address_book_lists 3
bugs 5 15 23
bugs_audit 1 10
calls 1 18 30
calls_contacts 2 7
calls_leads 2 7
calls_users 2 7
campaign_log 5 5 16
campaign_trkrs 1 11
campaigns 9 8 27
campaigns_audit 1 10
cases 6 13 20
cases_audit 1 10
cases_bugs 2 5
category_tree 4
config 3
contacts 8 25 42
contacts_audit 1 10
contacts_bugs 2 6
contacts_cases 2 6
contacts_users 2 5
contract_types 2 8
contracts 2 13 23
contracts_audit 1 10
contracts_contacts 2 5
contracts_opportunities 2 5
contracts_products 2 5
contracts_quotes 2 5
cron_remove_documents 4
currencies 1 10
custom_fields 13
custom_queries 3 14
data_sets 3 27
dataset_attributes 18
dataset_layouts 13
document_revisions 2 14
documents 1 14 24
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
eapm 3 18
email_addr_bean_rel 6 9
email_addresses 1 8
email_cache 16
email_marketing 3 17
email_marketing_prospect_lists 2 5
email_templates 1 4 20
emailman 1 15
emails 3 17 20
emails_beans 13 7
emails_email_addr_rel 5
emails_text 10
expressions 1 4 26
fields_meta_data 21
folders 14
folders_rel 5
folders_subscriptions 3
forecast_schedule 1 10
forecasts 1 12
fts_queue 4
holidays 2 13
import_maps 14
inbound_email 5 23
inbound_email_autoreply 6
inbound_email_cache_ts 2
job_queue 1 19
kbcontents 4 10
kbcontents_audit 1 10
kbdocument_revisions 2 14
kbdocuments 1 9 26
kbdocuments_kbtags 4 10
kbdocuments_views_ratings 6
kbtags 3 11
leads 7 19 52
leads_audit 1 10
linked_documents 4 7
manufacturers 1 9
meetings 1 19 38
meetings_contacts 2 7
meetings_leads 2 7
meetings_users 2 7
notes 23 18
notifications 4 10
notifications_audit 1 10
oauth_consumer 1 11
oauth_nonce 3
oauth_tokens 2 9
oauthkeys 3 3
opportunities 7 16 21
opportunities_audit 1 10
opportunities_contacts 2 6
outbound_email 12
product_bundle_note 2 1 6
product_bundle_notes 7
product_bundle_product 2 6
product_bundle_quote 2 6
product_bundles 6 24
product_categories 3 1 10
product_product 2 5
product_templates 5 34
product_types 2 9
products 1 17 50
products_audit 1 10
project 7 15 16
project_resources 3 8
project_task 5 9 34
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
prospect_list_campaigns 2 5
prospect_lists 7 13
prospect_lists_prospects 6 6
prospects 6 10 38
quotas 13
quotes 6 16 50
quotes_accounts 2 6
quotes_audit 1 10
quotes_contacts 2 6
quotes_opportunities 2 5
relationships 16
releases 2 9
report_cache 7
report_maker 3 13
report_schedules 10
roles 1 9
roles_modules 6
roles_users 2 5
saved_reports 4 17
saved_search 4 11
schedulers 1 2 16
schedulers_times 7
schedulersjobs 1 1
session_active 9
session_history 9
shippers 1 9
sugarfavorites 3 11
sugarfeed 6 15
systems 12
tasks 1 18 20
taxrates 10
team_memberships 2 7
team_notices 3 15
team_sets 35 1 7
team_sets_modules 4
team_sets_teams 37 5
teams 35 2 11
timeperiods 2 1 10
tracker 3 12
tracker_perf 1 8
tracker_queries 1 9
tracker_sessions 10
tracker_tracker_queries 2 4
upgrade_history 12
user_preferences 7
users 95 15 41
users_feeds 5
users_holidays 5
users_last_import 6
users_password_link 4
users_signatures 1 8
vcals 8
versions 9
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
worksheet 11
         
192 Tables     2,223  
0 Views     0