Tables


SchemaSpy Analysis of sugar

Generated on Thu Jan 13 23:26 GMT 2022

XML Representation
Insertion Order Deletion Order
TABLES 233
VIEWS 0
COLUMNS 3005
Constraints 0
Anomalies 9
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 41 10 Table
filters 0 7 16 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 12 Table
saved_search 0 4 11 Table
product_definition 0 0 1 Table
accounts_bugs 2 0 5 Table
kbarticles 2 8 13 Table
kbusefulness 0 0 9 Table
embedded_files 0 3 11 Table
custom_fields 0 0 13 Table
tracker_sessions 0 0 9 Table
projects_opportunities 2 0 5 Table
oauth_consumer 1 5 14 Table
quotes_opportunities 2 0 5 Table
categories 0 3 17 Table
email_templates 2 7 21 Table
tracker 0 3 12 Table
roles 0 1 9 Table
upgrade_history 0 0 18 Table
leads 9 23 62 Table
team_sets_modules 0 0 4 Table
emailman 0 1 15 Table
saved_reports 2 8 19 Table
tags 0 39 14 Table
users_last_states 0 0 5 Table
projects_cases 2 0 5 Table
campaign_trkrs 0 1 11 Table
roles_users 2 0 5 Table
manufacturers 3 5 11 Table
quotes_accounts 4 0 6 Table
user_preferences 0 0 7 Table
email_cache 0 0 16 Table
time_aware_schedules 0 0 6 Table
workflow_alertshells 1 1 12 Table
emails 5 33 27 Table
contacts_users 0 0 5 Table
fields_meta_data 0 0 22 Table
meetings_leads 2 0 7 Table
schedulers_times 0 0 7 Table
calendar_ical_configs 0 0 3 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 48 Table
bugs 5 18 22 Table
bugs_audit 1 0 12 Table
contracts_quotes 2 0 5 Table
acl_roles_users 2 0 5 Table
notes_audit 1 0 12 Table
document_revisions 0 4 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 27 37 Table
team_sets_users_1 0 0 2 Table
quotes 9 21 53 Table
contacts 13 30 49 Table
fts_queue 0 0 6 Table
email_addresses_audit 0 0 12 Table
quotes_audit 1 1 12 Table
acl_role_sets_acl_roles 0 0 5 Table
data_privacy 0 14 25 Table
releases 2 0 9 Table
kbcontents 7 17 29 Table
kbcontents_audit 1 0 12 Table
data_archivers 1 5 13 Table
product_bundles 0 8 29 Table
calls_audit 1 0 12 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 16 23 40 Table
leads_audit 1 1 12 Table
kbcontent_templates 0 7 12 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 29 Table
documents 4 20 25 Table
versions 0 0 9 Table
meetings 1 27 45 Table
projects_revenue_line_items 0 0 5 Table
accounts_cases 0 0 5 Table
notes 1 35 28 Table
folders_rel 0 0 5 Table
shippers 1 5 13 Table
documents_revenuelineitems 2 0 5 Table
metadata_cache 0 0 5 Table
audit_events 0 0 6 Table
data_privacy_audit 1 0 12 Table
email_addr_bean_rel 28 0 9 Table
dashboards 0 7 16 Table
subscriptions 0 3 9 Table
acl_roles 0 2 8 Table
forecast_manager_worksheets 0 8 29 Table
activities 1 61 13 Table
project_task 5 9 34 Table
cases 8 17 21 Table
schedulers 1 6 19 Table
erased_fields 0 0 3 Table
projects_accounts 2 0 5 Table
meetings_audit 1 0 12 Table
projects_contacts 2 0 5 Table
prospects 6 17 46 Table
session_history 0 0 9 Table
tasks_audit 1 0 12 Table
contract_types 1 6 10 Table
report_schedules 0 11 20 Table
contracts 1 18 25 Table
revenue_line_items 6 21 71 Table
campaign_log 5 6 16 Table
projects_products 3 0 5 Table
inbound_email_autoreply 0 0 6 Table
opportunities 11 19 30 Table
tag_bean_rel 68 0 6 Table
users_signatures 0 7 12 Table
report_schedules_audit 1 0 12 Table
reportschedules_users 2 0 5 Table
forecast_worksheets 0 13 45 Table
product_categories 5 5 12 Table
oauth_nonce 0 0 3 Table
holidays 0 4 14 Table
acl_role_sets 2 5 10 Table
oauth_tokens 0 3 13 Table
contracts_audit 1 0 12 Table
calendar 0 9 34 Table
session_active 0 0 9 Table
pdfmanager 0 8 25 Table
users 192 30 50 Table
users_holidays 0 0 5 Table
cases_audit 1 1 12 Table
documents_products 2 0 5 Table
archive_runs 0 6 16 Table
forecast_tree 0 0 5 Table
prospect_lists_prospects 10 0 6 Table
meetings_users 2 0 7 Table
product_templates 3 14 39 Table
contacts_dataprivacy 2 0 5 Table
comments 0 1 9 Table
contacts_bugs 2 0 6 Table
import_maps 0 0 14 Table
record_list 0 0 5 Table
teams 43 52 12 Table
email_marketing 0 3 17 Table
contacts_audit 1 1 12 Table
notifications 0 4 14 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 12 Table
calls_contacts 2 0 7 Table
workflow_actions 0 1 14 Table
inbound_email_cache_ts 0 0 2 Table
accounts_audit 1 1 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
activities_users 116 0 7 Table
accounts_dataprivacy 2 0 5 Table
opportunities_audit 1 1 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 43 1 7 Table
weblogichooks 0 3 13 Table
currencies 12 0 11 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
project_resources 4 0 8 Table
product_templates_audit 1 0 12 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 29 66 Table
team_sets_teams 92 0 5 Table
eapm 0 5 19 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 74 0 5 Table
forecasts 0 4 17 Table
tasks 3 24 21 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 12 Table
address_book_list_items 0 0 2 Table
address_book 0 0 3 Table
product_types 3 5 10 Table
projects_quotes 2 0 5 Table
quotas 0 9 18 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