Tables


SchemaSpy Analysis of sugar

Generated on Thu Mar 24 14:26 GMT 2022

XML Representation
Insertion Order Deletion Order
TABLES 271
VIEWS 0
COLUMNS 3809
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 45 9 Table
filters 0 8 15 Table
tracker_tracker_queries 2 0 4 Table
outbound_email 0 5 22 Table
pmse_emails_templates 0 9 21 Table
prospect_list_campaigns 2 0 5 Table
prospects_dataprivacy 2 0 5 Table
sugarfavorites 0 6 11 Table
saved_search 0 4 12 Table
product_definition 0 0 1 Table
accounts_bugs 2 0 5 Table
kbarticles 2 9 13 Table
kbusefulness 0 0 9 Table
pmse_bpmn_event 0 4 31 Table
embedded_files 0 4 10 Table
pmse_bpm_group_user 0 4 10 Table
custom_fields 0 0 13 Table
pmse_bpmn_flow 0 4 27 Table
tracker_sessions 0 0 9 Table
projects_opportunities 2 0 5 Table
oauth_consumer 1 6 13 Table
quotes_opportunities 2 0 5 Table
categories 0 4 16 Table
pmse_bpm_dynamic_forms 0 4 14 Table
email_templates 2 6 22 Table
tracker 0 3 12 Table
roles 0 1 9 Table
upgrade_history 0 0 13 Table
leads 8 25 65 Table
team_sets_modules 0 0 4 Table
emailman 0 1 15 Table
saved_reports 2 8 19 Table
tags 0 41 13 Table
projects_cases 2 0 5 Table
campaign_trkrs 0 1 11 Table
roles_users 2 0 5 Table
manufacturers 3 6 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 27 Table
pmse_bpmn_gateway 0 4 19 Table
business_centers_holidays 2 0 5 Table
contacts_users 0 0 5 Table
fields_meta_data 0 0 21 Table
meetings_leads 2 0 7 Table
pmse_bpm_gateway_definition 0 4 12 Table
schedulers_times 0 0 7 Table
users_feeds 0 0 5 Table
kbcontent_templates_audit 1 0 12 Table
email_addresses 4 14 9 Table
documents_opportunities 2 0 5 Table
product_bundle_notes 0 1 7 Table
acl_fields 0 0 10 Table
meetings_contacts 2 0 7 Table
styleguide 0 7 47 Table
bugs 6 19 28 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
dataset_layouts 0 0 13 Table
documents_contacts 2 0 5 Table
team_sets_users_2 0 0 2 Table
calls 1 27 36 Table
team_sets_users_1 0 0 2 Table
quotes 8 22 53 Table
contacts 12 32 59 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 1 15 30 Table
releases 2 0 9 Table
pmse_bpm_activity_user 0 4 13 Table
kbcontents 7 18 29 Table
kbcontents_audit 1 0 12 Table
product_bundles 0 8 29 Table
product_product 2 0 5 Table
revenue_line_items_audit 1 0 12 Table
project 7 17 17 Table
acl_roles_actions 2 0 6 Table
contracts_opportunities 0 0 5 Table
report_cache 0 0 7 Table
accounts 15 25 43 Table
pmse_bpmn_participant 0 4 17 Table
leads_audit 1 0 12 Table
kbcontent_templates 0 8 12 Table
inbound_email 1 5 28 Table
pmse_project 0 9 24 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 29 Table
documents 3 20 25 Table
versions 0 0 9 Table
meetings 1 27 44 Table
projects_revenue_line_items 0 0 5 Table
accounts_cases 0 0 5 Table
notes 0 33 26 Table
folders_rel 0 0 5 Table
shippers 1 6 12 Table
documents_revenuelineitems 2 0 5 Table
metadata_cache 0 0 5 Table
business_centers_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 16 Table
subscriptions 0 4 8 Table
acl_roles 0 2 8 Table
forecast_manager_worksheets 0 9 29 Table
visual_pipeline 0 6 15 Table
activities 1 97 12 Table
project_task 5 9 35 Table
pmse_inbox 0 7 26 Table
cases 7 20 36 Table
schedulers 1 7 18 Table
pmse_bpm_notes 0 4 19 Table
erased_fields 0 0 3 Table
projects_accounts 2 0 5 Table
projects_contacts 2 0 5 Table
prospects 6 18 46 Table
tasks_audit 1 0 12 Table
session_history 0 0 9 Table
contract_types 1 7 9 Table
report_schedules 0 12 19 Table
contracts 1 19 25 Table
revenue_line_items 5 22 73 Table
campaign_log 5 6 16 Table
pmse_bpm_process_definition 0 59 15 Table
projects_products 3 0 5 Table
inbound_email_autoreply 0 0 6 Table
opportunities 11 21 35 Table
pmse_bpm_group 0 4 11 Table
tag_bean_rel 70 0 6 Table
users_signatures 0 8 11 Table
report_schedules_audit 1 0 12 Table
reportschedules_users 2 0 5 Table
forecast_worksheets 0 14 45 Table
product_categories 5 6 11 Table
pmse_bpm_config 0 4 11 Table
oauth_nonce 0 0 3 Table
pmse_bpm_form_action 0 4 20 Table
pmse_bpmn_bound 0 4 22 Table
holidays 0 5 14 Table
acl_role_sets 2 6 9 Table
changetimers 0 6 16 Table
oauth_tokens 0 3 13 Table
pmse_email_message 0 3 20 Table
pmse_bpmn_process 0 4 16 Table
contracts_audit 1 0 12 Table
session_active 0 0 9 Table
pdfmanager 0 9 25 Table
users 296 31 50 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 18 Table
forecast_tree 0 0 5 Table
prospect_lists_prospects 10 0 6 Table
meetings_users 2 0 7 Table
product_templates 3 15 42 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 50 60 11 Table
email_marketing 0 3 17 Table
contacts_audit 1 0 12 Table
notifications 0 5 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 8 12 Table
calls_contacts 2 0 7 Table
pmse_business_rules 0 9 22 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 186 0 7 Table
opportunities_audit 1 0 12 Table
pmse_bpmn_extension 0 4 14 Table
pmse_bpmn_lane 0 4 14 Table
tags_audit 1 0 12 Table
workflow 4 1 15 Table
folders_subscriptions 0 0 3 Table
console_configuration 0 6 12 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 14 Table
contacts_cases 2 0 6 Table
config 0 0 4 Table
team_sets 50 1 7 Table
weblogichooks 0 4 12 Table
currencies 12 0 10 Table
job_queue 1 2 24 Table
documents_quotes 2 0 5 Table
pmse_bpmn_activity 0 4 38 Table
report_maker 0 3 14 Table
quotas_audit 1 0 12 Table
calls_users 2 0 7 Table
business_centers 5 12 53 Table
pmse_bpmn_diagram 0 4 12 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 37 Table
pmse_bpmn_data 0 4 20 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 3 29 68 Table
team_sets_teams 106 0 5 Table
eapm 0 6 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
pmse_bpmn_laneset 0 4 15 Table
pmse_bpmn_documentation 0 4 14 Table
commentlog_rel 80 0 5 Table
forecasts 0 4 17 Table
pmse_bpm_thread 0 4 16 Table
pmse_bpm_related_dependency 0 4 46 Table
tasks 3 25 21 Table
locked_field_bean_rel 110 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 14 Table
pmse_bpm_activity_definition 0 4 37 Table
team_notices 0 3 16 Table
roles_modules 0 0 6 Table
prospects_audit 1 0 12 Table
taxrates 2 6 11 Table
address_book_list_items 0 0 2 Table
address_book 0 0 3 Table
product_types 3 6 9 Table
projects_quotes 2 0 5 Table
quotas 0 10 17 Table
pmse_bpm_activity_step 0 4 14 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