SchemaSpy Analysis of afad8983generated Generated by
SchemaSpy
Generated on Wed May 27 07:23 UTC 2015
Database Type: MySQL - 5.5.22-0ubuntu1 SourceForge.net

XML Representation
Insertion Order Deletion Order

Table Children Parents Columns Comments
accounts 9 14 33
accounts_audit 1 10
accounts_bugs 2 5
accounts_cases 5
accounts_contacts 2 5
accounts_opportunities 2 5
acl_actions 1 10
acl_roles 2 8
acl_roles_actions 2 6
acl_roles_users 2 5
address_book 3
bugs 5 12 19
bugs_audit 1 10
calls 1 14 28
calls_contacts 2 7
calls_leads 2 7
calls_users 2 7
campaign_log 5 5 16
campaign_trkrs 1 11
campaigns 9 5 25
campaigns_audit 1 10
cases 5 10 16
cases_audit 1 10
cases_bugs 2 5
config 3
contacts 7 19 35
contacts_audit 1 10
contacts_bugs 2 6
contacts_cases 2 6
contacts_users 2 5
contract_types 1 1
contracts 1 1
cron_remove_documents 4
currencies 1 10
custom_fields 13
document_revisions 2 14
documents 1 9 22
documents_accounts 2 5
documents_bugs 2 5
documents_cases 2 5
documents_contacts 2 5
documents_opportunities 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 1 15
emailman 1 15
emails 2 13 18
emails_beans 13 7
emails_email_addr_rel 5
emails_text 10
fields_meta_data 21
folders 12
folders_rel 5
folders_subscriptions 3
import_maps 14
inbound_email 2 21
inbound_email_autoreply 6
inbound_email_cache_ts 2
job_queue 1 19
leads 7 16 50
leads_audit 1 10
linked_documents 4 7
meetings 1 15 36
meetings_contacts 2 7
meetings_leads 2 7
meetings_users 2 7
notes 17 16
oauth_consumer 1 11
oauth_nonce 3
oauth_tokens 2 9
oauthkeys 3 3
opportunities 7 11 19
opportunities_audit 1 10
opportunities_contacts 2 6
outbound_email 12
products 1 1
project 6 10 13
project_task 5 6 31
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
prospect_list_campaigns 2 5
prospect_lists 4 11
prospect_lists_prospects 6 6
prospects 6 7 36
quotes 1 1
relationships 16
releases 2 9
roles 1 9
roles_modules 6
roles_users 2 5
saved_search 1 9
schedulers 1 2 16
schedulersjobs 1 1
sugarfeed 3 13
tasks 1 14 18
tracker 11
upgrade_history 12
user_preferences 7
users 69 10 38
users_feeds 5
users_last_import 6
users_password_link 4
users_signatures 1 8
vcals 8
versions 9
         
114 Tables     1,234  
0 Views     0