Tables


SchemaSpy Analysis of sugar

Generated on Thu Mar 24 14:53 GMT 2022

XML Representation
Insertion Order Deletion Order
TABLES 225
VIEWS 0
COLUMNS 2817
Constraints 0
Anomalies 8
Routines 1

Database Properties

Database Type: MySQL - 5.7.36

Schema sugar

generated

Tables

Table / View Children Parents Columns Type Comments
campaigns_audit 1 0 12 Table
commentlog 0 38 9 Table
filters 0 7 14 Table
tracker_tracker_queries 2 0 4 Table
outbound_email 0 5 21 Table
prospect_list_campaigns 2 0 5 Table
prospects_dataprivacy 2 0 5 Table
sugarfavorites 0 5 11 Table
saved_search 0 4 11 Table
product_definition 0 0 1 Table
accounts_bugs 2 0 5 Table
kbarticles 2 8 12 Table
kbusefulness 0 0 9 Table
embedded_files 0 3 10 Table
custom_fields 0 0 13 Table
tracker_sessions 0 0 9 Table
projects_opportunities 2 0 5 Table
oauth_consumer 1 5 13 Table
quotes_opportunities 2 0 5 Table
categories 0 3 16 Table
email_templates 2 6 21 Table
tracker 0 3 12 Table
roles 0 1 9 Table
upgrade_history 0 0 13 Table
leads 8 23 61 Table
team_sets_modules 0 0 4 Table
emailman 0 1 15 Table
saved_reports 2 8 18 Table
tags 0 34 13 Table
projects_cases 2 0 5 Table
campaign_trkrs 0 1 11 Table
roles_users 2 0 5 Table
manufacturers 3 5 10 Table
quotes_accounts 4 0 6 Table
user_preferences 0 0 7 Table
email_cache 0 0 16 Table
workflow_alertshells 1 1 12 Table
emails 5 33 26 Table
contacts_users 0 0 5 Table
fields_meta_data 0 0 21 Table
meetings_leads 2 0 7 Table
schedulers_times 0 0 7 Table
users_feeds 0 0 5 Table
kbcontent_templates_audit 1 0 12 Table
documents_opportunities 2 0 5 Table
email_addresses 4 14 9 Table
product_bundle_notes 0 1 7 Table
acl_fields 0 0 10 Table
meetings_contacts 2 0 7 Table
styleguide 0 6 47 Table
bugs 5 18 21 Table
bugs_audit 1 0 12 Table
contracts_quotes 2 0 5 Table
acl_roles_users 2 0 5 Table
document_revisions 0 3 15 Table
accounts_contacts 2 0 6 Table
expressions 1 8 26 Table
documents_contacts 2 0 5 Table
team_sets_users_2 0 0 2 Table
calls 1 26 35 Table
team_sets_users_1 0 0 2 Table
quotes 8 21 52 Table
contacts 12 30 48 Table
fts_queue 0 0 6 Table
email_addresses_audit 0 0 12 Table
quotes_audit 1 0 12 Table
acl_role_sets_acl_roles 0 0 5 Table
data_privacy 0 14 24 Table
releases 2 0 9 Table
kbcontents 7 17 28 Table
kbcontents_audit 1 0 12 Table
product_bundles 0 8 28 Table
product_product 2 0 5 Table
revenue_line_items_audit 1 0 12 Table
project 7 17 16 Table
acl_roles_actions 2 0 6 Table
contracts_opportunities 0 0 5 Table
report_cache 0 0 7 Table
accounts 15 23 39 Table
leads_audit 1 0 12 Table
kbcontent_templates 0 7 11 Table
inbound_email 1 5 27 Table
contracts_contacts 2 0 5 Table
workflow_alerts 3 1 19 Table
workflow_schedules 0 0 11 Table
opportunities_contacts 2 0 6 Table
campaigns 12 13 28 Table
documents 3 19 24 Table
versions 0 0 9 Table
meetings 1 26 43 Table
projects_revenue_line_items 0 0 5 Table
accounts_cases 0 0 5 Table
notes 0 32 25 Table
folders_rel 0 0 5 Table
shippers 1 5 12 Table
documents_revenuelineitems 2 0 5 Table
metadata_cache 0 0 5 Table
audit_events 0 0 6 Table
email_addr_bean_rel 28 0 9 Table
data_privacy_audit 1 0 12 Table
dashboards 0 7 15 Table
subscriptions 0 3 8 Table
acl_roles 0 2 8 Table
forecast_manager_worksheets 0 8 28 Table
activities 1 58 12 Table
project_task 5 9 34 Table
cases 6 17 20 Table
schedulers 1 6 18 Table
erased_fields 0 0 3 Table
projects_accounts 2 0 5 Table
projects_contacts 2 0 5 Table
prospects 6 17 45 Table
session_history 0 0 9 Table
tasks_audit 1 0 12 Table
contract_types 1 6 9 Table
report_schedules 0 11 18 Table
contracts 1 18 24 Table
revenue_line_items 5 21 66 Table
campaign_log 5 6 16 Table
projects_products 3 0 5 Table
inbound_email_autoreply 0 0 6 Table
opportunities 10 19 29 Table
tag_bean_rel 58 0 6 Table
users_signatures 0 7 11 Table
report_schedules_audit 1 0 12 Table
reportschedules_users 2 0 5 Table
forecast_worksheets 0 13 44 Table
product_categories 5 5 11 Table
oauth_nonce 0 0 3 Table
holidays 0 4 14 Table
acl_role_sets 2 5 9 Table
oauth_tokens 0 3 13 Table
contracts_audit 1 0 12 Table
session_active 0 0 9 Table
pdfmanager 0 8 24 Table
users 185 30 48 Table
users_holidays 0 0 5 Table
cases_audit 1 0 12 Table
documents_products 2 0 5 Table
forecast_tree 0 0 5 Table
prospect_lists_prospects 10 0 6 Table
meetings_users 2 0 7 Table
product_templates 3 14 37 Table
contacts_dataprivacy 2 0 5 Table
comments 0 1 8 Table
contacts_bugs 2 0 6 Table
import_maps 0 0 14 Table
record_list 0 0 5 Table
teams 42 51 11 Table
email_marketing 0 3 17 Table
contacts_audit 1 0 12 Table
notifications 0 4 13 Table
documents_cases 2 0 5 Table
team_set_events 0 0 4 Table
vcals 0 0 8 Table
workflow_triggershells 3 2 15 Table
product_bundle_product 2 0 6 Table
kbdocuments 2 7 11 Table
calls_contacts 2 0 7 Table
workflow_actions 0 1 14 Table
inbound_email_cache_ts 0 0 2 Table
accounts_audit 1 0 12 Table
quotes_contacts 4 0 6 Table
leads_dataprivacy 2 0 5 Table
documents_accounts 2 0 5 Table
product_bundle_note 2 0 6 Table
accounts_dataprivacy 2 0 5 Table
activities_users 110 0 7 Table
opportunities_audit 1 0 12 Table
tags_audit 1 0 12 Table
workflow 4 1 15 Table
folders_subscriptions 0 0 3 Table
email_marketing_prospect_lists 2 0 5 Table
forecast_manager_worksheets_audit 0 0 12 Table
emails_beans 30 0 7 Table
contracts_products 2 0 5 Table
category_tree 0 0 4 Table
prospect_lists 0 15 13 Table
config 0 0 4 Table
contacts_cases 2 0 6 Table
team_sets 42 1 7 Table
weblogichooks 0 3 12 Table
currencies 12 0 10 Table
job_queue 1 2 24 Table
documents_quotes 2 0 5 Table
quotas_audit 1 0 12 Table
calls_users 2 0 7 Table
product_templates_audit 1 0 12 Table
project_resources 4 0 8 Table
products_audit 1 0 12 Table
projects_bugs 2 0 5 Table
documents_bugs 2 0 5 Table
folders 0 0 14 Table
products 3 28 61 Table
team_sets_teams 90 0 5 Table
eapm 0 5 18 Table
product_bundle_quote 0 0 6 Table
emails_text 0 0 10 Table
users_password_link 0 0 7 Table
acl_actions 0 1 10 Table
address_book_lists 0 0 3 Table
cases_bugs 2 0 5 Table
commentlog_rel 68 0 5 Table
forecasts 0 4 17 Table
tasks 3 24 20 Table
calls_leads 2 0 7 Table
team_memberships 2 0 7 Table
workflow_actionshells 3 1 12 Table
timeperiods 1 1 15 Table
emails_email_addr_rel 0 6 9 Table
tracker_perf 1 0 8 Table
users_last_import 0 0 6 Table
team_notices 0 3 15 Table
roles_modules 0 0 6 Table
prospects_audit 1 0 12 Table
taxrates 2 5 11 Table
address_book_list_items 0 0 2 Table
address_book 0 0 3 Table
product_types 3 5 9 Table
projects_quotes 2 0 5 Table
quotas 0 9 17 Table
tracker_queries 0 1 9 Table
project_task_audit 1 0 12 Table
accounts_opportunities 0 0 5 Table
linked_documents 4 0 7 Table