Tables


SchemaSpy Analysis of sugar

Generated on Mon Nov 06 18:52 GMT 2023

XML Representation
Insertion Order Deletion Order
TABLES 428
VIEWS 0
COLUMNS 5372
Constraints 0
Anomalies 96
Routines 1

Database Properties

Database Type: MySQL - 5.7.42

Schema sugar

generated

Tables

Table / View Children Parents Columns Type Comments
filters 1 8 17 Table
outbound_email 0 5 23 Table
pmse_emails_templates 1 9 22 Table
prospect_list_campaigns 2 0 5 Table
pmse_project_audit 0 1 1 Table
pmse_emails_templates_audit 0 1 1 Table
pubsub_moduleevent_pushsubs 1 6 13 Table
prospects_dataprivacy 2 0 5 Table
saved_search 0 4 12 Table
accounts_bugs 2 0 5 Table
kbarticles 3 9 14 Table
kbusefulness 0 0 9 Table
embedded_files 1 4 11 Table
pmse_bpm_group_user 1 4 11 Table
taxrates_audit 0 1 1 Table
pmse_bpmn_flow 1 4 28 Table
system_process_lock 0 0 3 Table
quotes_opportunities 2 0 5 Table
categories 1 4 17 Table
pmse_bpmn_participant_audit 0 1 1 Table
pmse_bpm_dynamic_forms 1 4 15 Table
kbdocuments_audit 0 1 1 Table
tracker 0 3 12 Table
leads 11 27 102 Table
emailman 0 1 15 Table
saved_reports 3 8 20 Table
pmse_bpmn_bound_audit 0 1 1 Table
purchases 6 21 26 Table
tags 1 71 14 Table
pmse_bpmn_flow_audit 0 1 1 Table
roles_users 2 0 5 Table
manufacturers 5 6 11 Table
user_preferences 0 0 7 Table
dri_subworkflows 5 12 28 Table
messages_contacts 2 0 7 Table
pmse_bpm_dynamic_forms_audit 0 1 1 Table
pmse_bpmn_gateway 1 4 20 Table
pmse_email_message_audit 0 1 1 Table
pmse_bpm_flow_audit 0 1 1 Table
contacts_users 0 0 5 Table
calendar_ical_configs 0 0 3 Table
documents_purchases 2 0 5 Table
kbcontent_templates_audit 1 1 12 Table
documents_opportunities 2 0 5 Table
email_addresses 4 16 9 Table
embedded_files_audit 0 1 1 Table
subscriptions_audit 0 1 1 Table
product_bundle_notes 0 1 7 Table
acl_fields 0 0 10 Table
bugs 9 20 33 Table
dri_workflows_audit 1 1 12 Table
contracts_quotes 2 0 5 Table
acl_roles_users 2 0 5 Table
purchased_line_items 7 24 75 Table
document_revisions 0 4 15 Table
external_users_audit 0 1 1 Table
hint_accountsets_audit 0 1 1 Table
archive_runs_audit 0 1 1 Table
calendar_audit 0 1 1 Table
team_sets_users_2 0 0 2 Table
team_sets_users_1 0 0 2 Table
contacts 15 37 92 Table
fts_queue 0 0 6 Table
push_notifications 1 5 15 Table
acl_role_sets_acl_roles 0 0 5 Table
data_privacy 2 15 31 Table
releases 2 0 9 Table
cases_purchases 2 0 5 Table
sugarfavorites_audit 0 1 1 Table
pmse_bpm_activity_user 1 4 14 Table
shippers_audit 0 1 1 Table
pmse_bpm_group_user_audit 0 1 1 Table
data_archivers 2 6 13 Table
documents_audit 1 1 12 Table
messages_audit 1 1 12 Table
docusign_envelopes_audit 1 1 12 Table
product_product 2 0 5 Table
revenue_line_items_audit 1 1 12 Table
push_notifications_audit 0 1 1 Table
contracts_opportunities 0 0 5 Table
report_cache 0 0 7 Table
accounts 21 28 58 Table
pmse_bpm_gateway_definition_audit 0 1 1 Table
accounts_purchases 0 0 5 Table
leads_audit 1 1 12 Table
pmse_project 1 9 25 Table
contracts_contacts 2 0 5 Table
workflow_alerts 3 1 19 Table
teams_audit 0 1 1 Table
pmse_bpmn_activity_audit 0 1 1 Table
pubsub_moduleevent_pushsubs_audit 0 1 1 Table
workflow_schedules 0 0 11 Table
opportunities_contacts 2 0 6 Table
documents 5 25 27 Table
shippers 2 6 13 Table
hint_notification_targets_audit 0 1 1 Table
documents_revenuelineitems 2 0 5 Table
hint_news_notifications_audit 0 1 1 Table
filters_audit 0 1 1 Table
data_privacy_audit 1 1 12 Table
email_addr_bean_rel 32 0 9 Table
dashboards 1 8 17 Table
visual_pipeline 1 6 19 Table
activities 2 127 13 Table
project_task 6 9 35 Table
changetimers_audit 0 1 1 Table
cases 12 23 45 Table
schedulers 2 7 19 Table
pmse_bpm_group_audit 0 1 1 Table
projects_accounts 2 0 5 Table
external_users_opportunities 2 0 5 Table
prospects 8 18 48 Table
tasks_audit 1 1 12 Table
report_schedules 1 12 22 Table
contract_types_audit 0 1 1 Table
visual_pipeline_audit 0 1 1 Table
revenue_line_items 10 24 86 Table
pmse_business_rules_audit 0 1 1 Table
pmse_bpm_process_definition 1 88 16 Table
projects_products 3 0 5 Table
inbound_email_autoreply 0 0 6 Table
pmse_bpm_group 1 4 12 Table
tag_bean_rel 130 0 6 Table
pmse_bpmn_extension_audit 0 1 1 Table
reportschedules_users 2 0 5 Table
dri_subworkflow_templates 8 11 18 Table
pmse_inbox_audit 0 1 1 Table
forecast_worksheets 1 14 46 Table
product_categories 8 6 12 Table
pmse_bpm_config 1 4 12 Table
oauth_nonce 0 0 3 Table
hint_notification_targets 1 8 12 Table
shift_exceptions_audit 1 1 12 Table
document_templates 1 11 22 Table
acl_role_sets 3 6 10 Table
changetimers 1 6 17 Table
oauth_tokens 0 3 13 Table
eapm_audit 0 1 1 Table
contracts_audit 1 1 12 Table
session_active 0 0 9 Table
pmse_bpmn_gateway_audit 0 1 1 Table
users 378 34 54 Table
documents_products 2 0 5 Table
forecast_tree 0 0 5 Table
meetings_users 2 0 7 Table
product_templates 6 15 45 Table
contacts_dataprivacy 2 0 5 Table
pmse_bpmn_lane_audit 0 1 1 Table
contacts_bugs 2 0 6 Table
pmse_bpmn_process_audit 0 1 1 Table
teams 72 80 12 Table
contacts_audit 1 1 12 Table
notifications 1 5 14 Table
pmse_bpm_activity_user_audit 0 1 1 Table
documents_cases 2 0 5 Table
product_bundle_product 2 0 6 Table
calls_contacts 2 0 7 Table
pmse_business_rules 1 9 23 Table
accounts_audit 1 1 12 Table
product_bundle_note 2 0 6 Table
dataset_attributes 0 0 18 Table
activities_users 246 0 7 Table
pmse_bpmn_diagram_audit 0 1 1 Table
opportunities_audit 1 1 12 Table
tags_audit 1 1 12 Table
folders_subscriptions 0 0 3 Table
dri_subworkflow_templates_audit 0 1 1 Table
console_configuration 1 6 14 Table
forecast_manager_worksheets_audit 0 1 12 Table
emails_beans 42 0 7 Table
contracts_products 2 0 5 Table
shifts 1 12 51 Table
cj_web_hooks 1 12 26 Table
category_tree 0 0 4 Table
config 0 0 4 Table
contacts_cases 2 0 6 Table
team_sets 70 1 7 Table
job_queue 1 2 24 Table
documents_quotes 2 0 5 Table
pmse_bpmn_activity 1 4 39 Table
messages_users 2 0 7 Table
report_maker 0 3 14 Table
mobile_devices 1 5 12 Table
pmse_bpm_activity_definition_audit 0 1 1 Table
notifications_audit 0 1 1 Table
calls_users 2 0 7 Table
escalations_audit 1 1 12 Table
project_resources 4 0 8 Table
activities_audit 0 1 1 Table
products_audit 1 1 12 Table
pmse_bpm_flow 1 4 38 Table
pmse_bpmn_data 1 4 21 Table
projects_bugs 2 0 5 Table
commentlog_audit 0 1 1 Table
dri_workflow_templates_audit 0 1 1 Table
custom_queries 0 3 15 Table
dashboards_audit 0 1 1 Table
team_sets_teams 146 0 5 Table
acl_actions 0 1 10 Table
address_book_lists 0 0 3 Table
shift_exceptions_users 2 0 5 Table
forecasts 0 4 17 Table
pmse_bpm_thread 1 4 17 Table
accounts_escalations 2 0 5 Table
pmse_bpm_related_dependency 1 4 47 Table
pmse_bpmn_laneset_audit 0 1 1 Table
external_users_quotes 2 0 5 Table
locked_field_bean_rel 168 0 6 Table
team_memberships 2 0 7 Table
docusign_envelopes 1 11 22 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 1 4 15 Table
external_users 3 15 48 Table
pmse_bpmn_data_audit 0 1 1 Table
dri_subworkflows_audit 0 1 1 Table
team_notices 0 3 16 Table
taxrates 3 6 12 Table
pmse_bpm_activity_step 1 4 15 Table
data_sets 0 3 28 Table
accounts_opportunities 0 0 5 Table
linked_documents 4 0 7 Table
campaigns_audit 1 1 12 Table
pmse_bpm_related_dependency_audit 0 1 1 Table
commentlog 1 72 10 Table
tracker_tracker_queries 2 0 4 Table
sugarfavorites 1 6 12 Table
product_definition 0 0 1 Table
data_archivers_audit 0 1 1 Table
pmse_bpmn_event 1 4 32 Table
custom_fields 0 0 13 Table
pmse_bpm_process_definition_audit 0 1 1 Table
tracker_sessions 0 0 9 Table
projects_opportunities 2 0 5 Table
oauth_consumer 2 6 14 Table
oauth_consumer_audit 0 1 1 Table
hint_accountsets 1 11 15 Table
email_templates 3 7 22 Table
roles 0 1 1 Table
upgrade_history 0 0 18 Table
team_sets_modules 0 0 4 Table
users_last_states 0 0 5 Table
projects_cases 2 0 5 Table
campaign_trkrs 0 1 11 Table
externalusers 0 2 1 Table
quotes_accounts 4 0 6 Table
email_cache 0 0 16 Table
time_aware_schedules 0 0 6 Table
workflow_alertshells 1 1 12 Table
emails 5 39 28 Table
business_centers_holidays 2 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 1 4 13 Table
schedulers_times 0 0 7 Table
purchased_line_items_audit 1 1 12 Table
messages 1 33 26 Table
document_merges_audit 1 1 12 Table
meetings_contacts 2 0 7 Table
styleguide 1 7 48 Table
bugs_audit 1 1 12 Table
notes_audit 1 1 12 Table
pdfmanager_audit 0 1 1 Table
accounts_contacts 2 0 6 Table
expressions 1 8 26 Table
dataset_layouts 0 0 13 Table
documents_contacts 2 0 5 Table
cloud_drive_paths 1 6 18 Table
calls 7 39 78 Table
quotes 10 23 56 Table
email_addresses_audit 0 0 12 Table
quotes_audit 1 1 12 Table
cloud_drive_paths_audit 0 1 1 Table
pmse_bpm_activity_step_audit 0 1 1 Table
pmse_bpm_config_audit 0 1 1 Table
geocode 0 0 16 Table
kbcontents 9 18 30 Table
external_users_accounts 2 0 5 Table
kbcontents_audit 1 1 12 Table
pmse_bpm_event_definition_audit 0 1 1 Table
product_bundles 0 8 30 Table
pmse_bpmn_event_audit 0 1 1 Table
calls_audit 1 1 12 Table
kbarticles_audit 0 1 1 Table
cj_forms 1 15 31 Table
project 8 17 17 Table
acl_roles_actions 2 0 6 Table
pmse_bpm_thread_audit 0 1 1 Table
geocode_queue 0 0 6 Table
pmse_bpmn_participant 1 4 18 Table
documents_escalations 2 0 5 Table
kbcontent_templates 1 8 13 Table
purchases_audit 1 1 12 Table
inbound_email 1 5 28 Table
product_categories_audit 0 1 1 Table
saved_reports_audit 0 1 1 Table
document_merges 1 11 25 Table
campaigns 13 14 29 Table
hint_news_notifications 1 7 16 Table
versions 0 0 9 Table
meetings 7 39 70 Table
projects_revenue_line_items 0 0 5 Table
accounts_cases 0 0 5 Table
notes 2 40 33 Table
folders_rel 0 0 5 Table
pmse_bpm_notes_audit 0 1 1 Table
metadata_cache 0 0 5 Table
business_centers_audit 1 1 12 Table
shifts_audit 1 1 12 Table
audit_events 0 0 7 Table
acl_role_sets_audit 0 1 1 Table
subscriptions 1 4 9 Table
acl_roles 0 2 8 Table
forecast_manager_worksheets 1 9 30 Table
pmse_inbox 1 7 27 Table
cj_web_hooks_audit 0 1 1 Table
product_types_audit 0 1 1 Table
pmse_bpm_notes 1 4 20 Table
erased_fields 0 0 3 Table
meetings_audit 1 1 12 Table
projects_contacts 2 0 5 Table
session_history 0 0 9 Table
contract_types 2 7 10 Table
contracts 3 19 26 Table
campaign_log 5 6 16 Table
opportunities 16 23 54 Table
dri_workflows 5 21 38 Table
users_signatures 1 8 12 Table
report_schedules_audit 1 1 12 Table
contacts_escalations 2 0 5 Table
contacts_purchases 2 0 5 Table
forecast_worksheets_audit 0 1 1 Table
geocode_job 0 0 9 Table
pmse_bpm_form_action 1 4 21 Table
pmse_bpmn_bound 1 4 23 Table
pmse_bpm_form_action_audit 0 1 1 Table
holidays 0 5 14 Table
pmse_email_message 1 3 22 Table
pmse_bpmn_process 1 4 17 Table
dri_workflow_task_templates_audit 0 1 1 Table
hint_events_queue 0 0 9 Table
calendar 1 10 35 Table
documents_purchasedlineitems 2 0 5 Table
pdfmanager 1 9 26 Table
manufacturers_audit 0 1 1 Table
users_holidays 0 0 5 Table
cases_audit 1 1 12 Table
pmse_bpm_event_definition 1 4 19 Table
archive_runs 1 7 16 Table
prospect_lists_prospects 10 0 6 Table
mobile_devices_audit 0 1 1 Table
comments 0 1 9 Table
styleguide_audit 0 1 1 Table
import_maps 0 0 14 Table
record_list 0 0 5 Table
email_marketing 0 3 17 Table
team_set_events 0 0 4 Table
vcals 0 0 8 Table
workflow_triggershells 3 2 15 Table
kbdocuments 3 8 13 Table
metrics 1 9 24 Table
workflow_actions 0 1 14 Table
inbound_email_cache_ts 0 0 2 Table
quotes_contacts 4 0 6 Table
leads_dataprivacy 2 0 5 Table
documents_accounts 2 0 5 Table
hint_enrich_field_config_audit 0 1 1 Table
accounts_dataprivacy 2 0 5 Table
weblogichooks_audit 0 1 1 Table
pmse_bpmn_extension 1 4 15 Table
pmse_bpmn_lane 1 4 15 Table
workflow 4 1 15 Table
email_marketing_prospect_lists 2 0 5 Table
prospect_lists 0 15 14 Table
pmse_bpmn_documentation_audit 0 1 1 Table
weblogichooks 1 4 13 Table
reports_panels 0 0 9 Table
currencies 14 0 11 Table
quotas_audit 1 1 12 Table
cj_forms_audit 1 1 12 Table
business_centers 6 12 55 Table
pmse_bpmn_diagram 1 4 13 Table
product_templates_audit 1 1 12 Table
dri_workflow_templates 18 10 26 Table
external_users_bugs 2 0 5 Table
schedulers_audit 0 1 1 Table
documents_bugs 2 0 5 Table
folders 0 0 15 Table
products 5 31 77 Table
pmse_bpmn_artifact_audit 0 1 1 Table
eapm 1 6 19 Table
product_bundle_quote 0 0 6 Table
emails_text 0 0 10 Table
console_configuration_audit 0 1 1 Table
document_templates_audit 1 1 12 Table
users_password_link 0 0 7 Table
cases_bugs 2 0 5 Table
pmse_bpmn_laneset 1 4 16 Table
pmse_bpmn_documentation 1 4 15 Table
commentlog_rel 134 0 5 Table
sugar_live 1 6 10 Table
shift_exceptions 1 12 23 Table
hint_enrich_field_config 1 7 13 Table
hint_accountsets_targets 2 0 5 Table
tasks 9 36 50 Table
escalations 6 19 19 Table
categories_audit 0 1 1 Table
metrics_audit 1 1 12 Table
calls_leads 2 0 7 Table
workflow_actionshells 3 1 12 Table
users_signatures_audit 0 1 1 Table
pmse_bpm_activity_definition 1 4 45 Table
messages_leads 2 0 7 Table
dri_workflow_task_templates 11 19 57 Table
roles_modules 0 0 6 Table
prospects_audit 1 1 12 Table
address_book_list_items 0 0 2 Table
address_book 0 0 3 Table
product_types 6 6 10 Table
projects_quotes 2 0 5 Table
quotas 1 10 18 Table
tracker_queries 0 1 9 Table
external_users_cases 2 0 5 Table
project_task_audit 1 0 12 Table
sugar_live_audit 0 1 1 Table