Tables


SchemaSpy Analysis of suitecrm

Generated on Mon Mar 16 19:48 UTC 2020

XML Representation
Insertion Order Deletion Order
TABLES 220
VIEWS 0
COLUMNS 2557
Constraints 0
Anomalies 2
Routines 0

Database Properties

Database Type: MySQL - 5.5.5-10.4.11-MariaDB-1:10.4.11+maria~bionic

Schema suitecrm

SuiteCRM Database Schema

Tables

Table / View Children Parents Columns Type Comments
campaigns_audit 0 1 10 Table
aor_reports_audit 0 1 10 Table
outbound_email 1 3 20 Table
aos_products_audit 0 1 10 Table
jjwg_maps_jjwg_areas_c 0 2 5 Table
prospect_list_campaigns 0 2 5 Table
aok_knowledge_base_categories 2 3 9 Table
saved_search 0 1 9 Table
accounts_bugs 0 2 5 Table
jjwg_areas_audit 0 1 10 Table
custom_fields 0 0 13 Table
jjwg_maps_jjwg_markers_c 0 2 5 Table
projects_opportunities 0 2 5 Table
am_projecttemplates_users_1_c 0 2 5 Table
jjwg_maps_audit 0 1 10 Table
oauth_consumer 1 3 11 Table
aor_scheduled_reports 1 3 13 Table
email_templates 2 1 15 Table
tracker 0 0 11 Table
roles 1 0 9 Table
project_users_1_c 0 2 5 Table
upgrade_history 0 0 12 Table
aop_case_updates 2 5 12 Table
leads 17 10 54 Table
emailman 0 1 16 Table
aos_quotes_os_contracts_c 0 2 5 Table
projects_cases 0 2 5 Table
campaign_trkrs 0 1 11 Table
aod_index 1 3 11 Table
roles_users 0 2 5 Table
user_preferences 0 0 7 Table
email_cache 0 0 16 Table
surveyquestionoptions_surveyquestionresponses 0 2 5 Table
emails 3 12 22 Table
jjwg_areas 3 3 13 Table
surveyquestionresponses_audit 0 1 10 Table
aow_processed_aow_actions 0 2 6 Table
contacts_users 0 2 5 Table
fields_meta_data 0 0 21 Table
meetings_leads 0 2 7 Table
users_feeds 0 0 5 Table
aop_case_events 1 4 10 Table
email_addresses 2 0 13 Table
documents_opportunities 0 2 5 Table
meetings_contacts 0 2 7 Table
bugs 13 5 19 Table
surveyquestionresponses 3 4 14 Table
bugs_audit 0 1 10 Table
surveyquestions 3 4 13 Table
surveys 5 3 14 Table
acl_roles_users 0 2 5 Table
aos_product_categories_audit 0 1 10 Table
opportunities_cstm 0 1 5 Table
document_revisions 0 2 14 Table
accounts_contacts 0 2 5 Table
aow_workflow_audit 0 1 10 Table
fp_event_locations_fp_events_1_c 0 2 5 Table
documents_contacts 0 2 5 Table
calls 6 12 28 Table
aos_invoices 5 5 46 Table
contacts 30 7 42 Table
email_addresses_audit 0 1 10 Table
aod_indexevent 1 3 13 Table
releases 2 0 9 Table
accounts_cstm 0 1 5 Table
aos_products_quotes 1 8 34 Table
securitygroups_users 0 2 7 Table
fp_event_locations_audit 0 1 10 Table
fp_events_fp_event_delegates_1_c 0 0 5 Table
am_projecttemplates 5 3 12 Table
aop_case_updates_audit 0 1 10 Table
aow_actions 1 3 12 Table
aow_workflow 5 3 14 Table
am_tasktemplates_am_projecttemplates_c 0 2 5 Table
project 18 4 14 Table
am_projecttemplates_contacts_1_c 0 2 5 Table
acl_roles_actions 0 2 6 Table
accounts 23 6 33 Table
aos_contracts 11 6 39 Table
aos_contracts_documents 0 2 6 Table
aok_knowledgebase_audit 0 1 10 Table
surveys_audit 0 1 10 Table
jjwg_address_cache_audit 0 1 10 Table
leads_audit 0 1 10 Table
aor_charts 0 3 12 Table
inbound_email 0 2 21 Table
aos_quotes_project_c 0 2 5 Table
aos_pdf_templates_audit 0 1 10 Table
aow_processed 1 3 12 Table
fp_events_audit 0 1 10 Table
surveyresponses 3 5 15 Table
jjwg_maps 12 3 14 Table
opportunities_contacts 0 2 6 Table
aos_products 3 4 22 Table
campaigns 13 4 26 Table
am_projecttemplates_audit 0 1 10 Table
documents 9 3 22 Table
meetings 7 13 38 Table
notes 1 19 16 Table
accounts_cases 0 0 5 Table
folders_rel 0 0 5 Table
am_projecttemplates_project_1_c 0 2 5 Table
email_addr_bean_rel 0 6 9 Table
aos_products_quotes_audit 0 1 10 Table
securitygroups_records 0 41 8 Table
aos_contracts_audit 0 1 10 Table
acl_roles 3 0 8 Table
sugarfeed 0 3 13 Table
project_task 8 4 32 Table
jjwg_markers 3 3 15 Table
cases 15 6 18 Table
contacts_cstm 0 1 5 Table
schedulers 1 2 16 Table
relationships 0 0 16 Table
cron_remove_documents 0 0 4 Table
projects_accounts 0 2 5 Table
aobh_businesshours 0 2 12 Table
prospects_cstm 0 1 5 Table
projects_contacts 0 2 5 Table
prospects 12 5 40 Table
aor_conditions 0 3 18 Table
aor_reports 6 3 11 Table
projects_products 0 0 5 Table
campaign_log 5 5 16 Table
inbound_email_autoreply 0 0 6 Table
opportunities 17 6 19 Table
oauth2clients 1 3 16 Table
surveyquestionoptions_audit 0 1 10 Table
users_signatures 0 0 8 Table
securitygroups_acl_roles 0 2 5 Table
surveyquestions_audit 0 1 10 Table
surveyresponses_audit 0 1 10 Table
aos_invoices_audit 0 1 10 Table
reminders_invitees 0 3 12 Table
leads_cstm 0 1 5 Table
cases_cstm 0 1 5 Table
calls_reschedule_audit 0 1 10 Table
spots 1 3 11 Table
oauth_nonce 0 0 3 Table
fp_events_fp_event_locations_1_c 0 2 5 Table
oauth2tokens 0 4 18 Table
aos_quotes_aos_invoices_c 0 2 5 Table
oauth_tokens 0 2 18 Table
am_tasktemplates 2 3 20 Table
fp_events 7 3 19 Table
users 214 2 41 Table
jjwg_markers_audit 0 1 10 Table
cases_audit 0 1 10 Table
prospect_lists_prospects 0 6 6 Table
meetings_users 0 2 7 Table
aos_product_categories 4 4 11 Table
aop_case_events_audit 0 1 10 Table
aok_knowledgebase 3 3 14 Table
aos_quotes 7 6 49 Table
contacts_bugs 0 2 6 Table
import_maps 0 0 14 Table
aod_index_audit 0 1 10 Table
surveyquestionoptions 3 4 11 Table
securitygroups_default 0 0 5 Table
email_marketing 2 2 18 Table
contacts_audit 0 1 10 Table
documents_cases 0 2 5 Table
vcals 0 0 8 Table
calls_contacts 0 2 7 Table
inbound_email_cache_ts 0 0 2 Table
accounts_audit 0 1 10 Table
fp_events_prospects_1_c 0 2 8 Table
documents_accounts 0 2 5 Table
aos_line_item_groups_audit 0 1 10 Table
opportunities_audit 0 1 10 Table
securitygroups 4 3 10 Table
fp_event_locations 4 3 15 Table
aok_knowledge_base_categories_audit 0 1 10 Table
folders_subscriptions 0 0 3 Table
email_marketing_prospect_lists 0 2 5 Table
calls_reschedule 1 4 11 Table
emails_beans 0 14 7 Table
securitygroups_audit 0 1 10 Table
prospect_lists 4 1 11 Table
contacts_cases 0 2 6 Table
config 0 0 3 Table
currencies 0 1 10 Table
job_queue 0 2 19 Table
favorites 0 3 11 Table
aor_fields 0 3 23 Table
project_contacts_1_c 0 2 5 Table
calls_users 0 2 7 Table
aos_line_item_groups 2 6 25 Table
templatesectionline 0 2 11 Table
aow_conditions 0 3 15 Table
aos_pdf_templates 2 3 21 Table
projects_bugs 0 2 5 Table
alerts 0 3 14 Table
outbound_email_audit 0 1 10 Table
project_cstm 0 1 5 Table
folders 0 0 12 Table
documents_bugs 0 2 5 Table
aos_quotes_audit 0 1 10 Table
eapm 0 3 18 Table
emails_text 0 0 10 Table
users_password_link 0 0 4 Table
aok_knowledgebase_categories 0 2 5 Table
acl_actions 1 0 10 Table
cases_bugs 0 2 5 Table
fp_events_leads_1_c 0 2 8 Table
meetings_cstm 0 1 5 Table
fp_events_contacts_c 0 2 8 Table
tasks 3 14 18 Table
calls_leads 0 2 7 Table
emails_email_addr_rel 0 0 5 Table
users_last_import 0 0 6 Table
roles_modules 0 0 6 Table
address_book 0 0 3 Table
jjwg_address_cache 1 3 11 Table
project_task_audit 0 1 10 Table
reminders 0 3 18 Table
aod_indexevent_audit 0 1 10 Table
am_tasktemplates_audit 0 1 10 Table
accounts_opportunities 0 2 5 Table
linked_documents 0 2 7 Table