Tables


SchemaSpy Analysis of sugar

Generated on Thu Jan 12 15:13 GMT 2023

XML Representation
Insertion Order Deletion Order
TABLES 296
VIEWS 0
COLUMNS 4338
Constraints 0
Anomalies 10
Routines 1

Database Properties

Database Type: MySQL - 5.7.37

Schema sugar

generated

Tables

Table / View Children Parents Columns Type Comments
campaigns_audit 1 0 12 Table
commentlog 0 53 10 Table
filters 0 8 16 Table
tracker_tracker_queries 2 0 4 Table
outbound_email 0 5 22 Table
pmse_emails_templates 0 9 22 Table
prospect_list_campaigns 2 0 5 Table
prospects_dataprivacy 2 0 5 Table
sugarfavorites 0 6 12 Table
saved_search 0 4 12 Table
product_definition 0 0 1 Table
accounts_bugs 2 0 5 Table
kbarticles 2 9 14 Table
kbusefulness 0 0 9 Table
pmse_bpmn_event 0 4 32 Table
embedded_files 0 4 11 Table
pmse_bpm_group_user 0 4 11 Table
custom_fields 0 0 13 Table
pmse_bpmn_flow 0 4 28 Table
tracker_sessions 0 0 9 Table
projects_opportunities 2 0 5 Table
oauth_consumer 1 6 14 Table
quotes_opportunities 2 0 5 Table
categories 0 4 17 Table
pmse_bpm_dynamic_forms 0 4 15 Table
email_templates 2 7 22 Table
tracker 0 3 12 Table
roles 0 1 1 Table
upgrade_history 0 0 17 Table
leads 9 25 66 Table
team_sets_modules 0 0 4 Table
emailman 0 1 15 Table
saved_reports 2 8 20 Table
purchases 5 20 24 Table
tags 0 50 14 Table
projects_cases 2 0 5 Table
campaign_trkrs 0 1 11 Table
roles_users 2 0 5 Table
manufacturers 4 6 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 38 28 Table
pmse_bpmn_gateway 0 4 20 Table
business_centers_holidays 2 0 5 Table
contacts_users 0 0 5 Table
fields_meta_data 0 0 22 Table
shifts_users 2 0 5 Table
meetings_leads 2 0 7 Table
pmse_bpm_gateway_definition 0 4 13 Table
schedulers_times 0 0 7 Table
purchased_line_items_audit 1 0 12 Table
documents_purchases 2 0 5 Table
messages 0 29 24 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 7 48 Table
bugs 7 19 29 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
purchased_line_items 6 24 75 Table
document_revisions 0 3 15 Table
accounts_contacts 2 0 6 Table
expressions 1 8 26 Table
dataset_layouts 0 0 13 Table
documents_contacts 2 0 5 Table
team_sets_users_2 0 0 2 Table
calls 2 30 40 Table
team_sets_users_1 0 0 2 Table
quotes 9 22 55 Table
contacts 13 33 60 Table
fts_queue 0 0 6 Table
email_addresses_audit 0 0 12 Table
quotes_audit 1 0 12 Table
push_notifications 0 5 15 Table
acl_role_sets_acl_roles 0 0 5 Table
data_privacy 1 15 31 Table
releases 2 0 9 Table
cases_purchases 2 0 5 Table
pmse_bpm_activity_user 0 4 14 Table
kbcontents 8 18 30 Table
kbcontents_audit 1 0 12 Table
data_archivers 1 6 13 Table
product_bundles 0 8 30 Table
calls_audit 1 0 12 Table
messages_audit 1 0 12 Table
product_product 2 0 5 Table
revenue_line_items_audit 1 0 12 Table
project 8 17 17 Table
acl_roles_actions 2 0 6 Table
contracts_opportunities 0 0 5 Table
report_cache 0 0 7 Table
accounts 18 25 44 Table
accounts_purchases 0 0 5 Table
pmse_bpmn_participant 0 4 18 Table
leads_audit 1 0 12 Table
kbcontent_templates 0 8 13 Table
purchases_audit 1 0 12 Table
inbound_email 1 5 28 Table
pmse_project 0 9 25 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 14 30 Table
documents 3 22 26 Table
versions 0 0 9 Table
meetings 2 30 45 Table
projects_revenue_line_items 0 0 5 Table
accounts_cases 0 0 5 Table
notes 1 37 29 Table
folders_rel 0 0 5 Table
shippers 1 6 13 Table
documents_revenuelineitems 2 0 5 Table
metadata_cache 0 0 5 Table
business_centers_audit 1 0 12 Table
shifts_audit 1 0 12 Table
audit_events 0 0 6 Table
data_privacy_audit 1 0 12 Table
email_addr_bean_rel 28 0 9 Table
dashboards 0 8 17 Table
subscriptions 0 4 9 Table
acl_roles 0 2 8 Table
forecast_manager_worksheets 0 9 30 Table
visual_pipeline 0 6 16 Table
activities 1 107 13 Table
project_task 6 9 35 Table
pmse_inbox 0 7 27 Table
cases 8 21 39 Table
schedulers 1 7 19 Table
pmse_bpm_notes 0 4 20 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 7 18 47 Table
session_history 0 0 9 Table
tasks_audit 1 0 12 Table
contract_types 1 7 10 Table
report_schedules 0 12 20 Table
contracts 2 19 26 Table
revenue_line_items 9 24 85 Table
campaign_log 5 6 16 Table
pmse_bpm_process_definition 0 69 16 Table
projects_products 3 0 5 Table
inbound_email_autoreply 0 0 6 Table
opportunities 13 21 41 Table
pmse_bpm_group 0 4 12 Table
tag_bean_rel 88 0 6 Table
users_signatures 0 8 12 Table
report_schedules_audit 1 0 12 Table
reportschedules_users 2 0 5 Table
forecast_worksheets 0 14 46 Table
product_categories 7 6 12 Table
pmse_bpm_config 0 4 12 Table
contacts_purchases 2 0 5 Table
oauth_nonce 0 0 3 Table
pmse_bpm_form_action 0 4 21 Table
shift_exceptions_audit 1 0 12 Table
pmse_bpmn_bound 0 4 23 Table
holidays 0 5 14 Table
acl_role_sets 2 6 10 Table
changetimers 0 6 17 Table
oauth_tokens 0 3 13 Table
pmse_email_message 0 3 21 Table
pmse_bpmn_process 0 4 17 Table
contracts_audit 1 0 12 Table
session_active 0 0 9 Table
documents_purchasedlineitems 2 0 5 Table
pdfmanager 0 9 26 Table
users 324 33 52 Table
users_holidays 0 0 5 Table
cases_audit 1 0 12 Table
documents_products 2 0 5 Table
pmse_bpm_event_definition 0 4 19 Table
archive_runs 0 7 16 Table
forecast_tree 0 0 5 Table
prospect_lists_prospects 10 0 6 Table
meetings_users 2 0 7 Table
product_templates 5 15 44 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 55 65 12 Table
email_marketing 0 3 17 Table
contacts_audit 1 0 12 Table
notifications 0 5 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 8 13 Table
calls_contacts 2 0 7 Table
pmse_business_rules 0 9 23 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
dataset_attributes 0 0 18 Table
accounts_dataprivacy 2 0 5 Table
activities_users 206 0 7 Table
opportunities_audit 1 0 12 Table
pmse_bpmn_lane 0 4 15 Table
pmse_bpmn_extension 0 4 15 Table
tags_audit 1 0 12 Table
workflow 4 1 15 Table
folders_subscriptions 0 0 3 Table
console_configuration 0 6 13 Table
email_marketing_prospect_lists 2 0 5 Table
forecast_manager_worksheets_audit 0 0 12 Table
emails_beans 40 0 7 Table
contracts_products 2 0 5 Table
shifts 0 12 51 Table
category_tree 0 0 4 Table
prospect_lists 0 15 14 Table
contacts_cases 2 0 6 Table
config 0 0 4 Table
team_sets 55 1 7 Table
weblogichooks 0 4 13 Table
currencies 13 0 11 Table
job_queue 1 2 24 Table
documents_quotes 2 0 5 Table
pmse_bpmn_activity 0 4 39 Table
report_maker 0 3 14 Table
mobile_devices 0 5 12 Table
quotas_audit 1 0 12 Table
calls_users 2 0 7 Table
business_centers 5 12 54 Table
pmse_bpmn_diagram 0 4 13 Table
project_resources 4 0 8 Table
product_templates_audit 1 0 12 Table
products_audit 1 0 12 Table
pmse_bpm_flow 0 4 38 Table
pmse_bpmn_data 0 4 21 Table
projects_bugs 2 0 5 Table
custom_queries 0 3 15 Table
documents_bugs 2 0 5 Table
folders 0 0 15 Table
products 4 31 77 Table
team_sets_teams 116 0 5 Table
eapm 0 6 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
pmse_bpmn_laneset 0 4 16 Table
shift_exceptions_users 2 0 5 Table
pmse_bpmn_documentation 0 4 15 Table
commentlog_rel 96 0 5 Table
forecasts 0 4 17 Table
pmse_bpm_thread 0 4 17 Table
sugar_live 0 6 10 Table
pmse_bpm_related_dependency 0 4 47 Table
shift_exceptions 0 12 23 Table
tasks 4 27 22 Table
locked_field_bean_rel 130 0 6 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
pmse_bpmn_artifact 0 4 15 Table
pmse_bpm_activity_definition 0 4 45 Table
team_notices 0 3 16 Table
roles_modules 0 0 6 Table
prospects_audit 1 0 12 Table
taxrates 2 6 12 Table
address_book_list_items 0 0 2 Table
address_book 0 0 3 Table
product_types 5 6 10 Table
projects_quotes 2 0 5 Table
quotas 0 10 18 Table
pmse_bpm_activity_step 0 4 15 Table
tracker_queries 0 1 9 Table
data_sets 0 3 28 Table
project_task_audit 1 0 12 Table
accounts_opportunities 0 0 5 Table
linked_documents 4 0 7 Table