Tables


SchemaSpy Analysis of civicrm.civicrm

Generated on Wed Dec 13 01:32 EST 2017

XML Representation
Insertion Order Deletion Order
TABLES 152
VIEWS 54
COLUMNS 2781
Constraints 263

Database Properties

Database Type: MySQL - 5.5.5-10.0.31-MariaDB-0ubuntu0.16.04.2

Tables

Table / View Children Parents Columns Rows Type Comments
civicrm_acl 1 0 11 65 Table
civicrm_acl_cache 0 2 4 0 Table
civicrm_acl_contact_cache 0 2 4 0 Table
civicrm_acl_entity_role 0 0 5 0 Table
civicrm_action_log 0 2 10 0 Table
civicrm_action_mapping 0 0 9 6 Table
civicrm_action_schedule 1 4 38 0 Table
civicrm_activity 4 5 27 0 Table
civicrm_activity_contact 0 2 4 0 Table
civicrm_address 4 5 29 13 Table
civicrm_address_format 1 0 2 0 Table
civicrm_batch 1 3 19 0 Table
civicrm_batch_en_US 0 0 17 0 View
civicrm_batch_fr_CA 0 0 17 0 View
civicrm_cache 0 1 7 9 Table
civicrm_campaign 12 3 17 0 Table
civicrm_campaign_group 0 1 5 0 Table
civicrm_case 3 1 10 0 Table
civicrm_case_activity 0 2 3 0 Table
civicrm_case_contact 0 2 3 0 Table
civicrm_case_type 1 0 10 0 Table
civicrm_case_type_en_US 0 0 8 0 View
civicrm_case_type_fr_CA 0 0 8 0 View
civicrm_component 4 0 3 9 Table
civicrm_contact 68 2 52 4 Table
civicrm_contact_type 1 1 10 3 Table
civicrm_contact_type_en_US 0 0 8 0 View
civicrm_contact_type_fr_CA 0 0 8 0 View
civicrm_contribution 6 6 30 0 Table
civicrm_contribution_page 4 3 57 0 Table
civicrm_contribution_page_en_US 0 0 45 0 View
civicrm_contribution_page_fr_CA 0 0 45 0 View
civicrm_contribution_product 0 2 10 0 Table
civicrm_contribution_recur 2 5 28 0 Table
civicrm_contribution_soft 0 3 10 0 Table
civicrm_contribution_widget 0 1 17 0 Table
civicrm_country 3 2 9 251 Table
civicrm_county 1 1 4 6 Table
civicrm_currency 0 0 5 184 Table
civicrm_custom_field 0 1 33 0 Table
civicrm_custom_field_en_US 0 0 30 0 View
civicrm_custom_field_fr_CA 0 0 30 0 View
civicrm_custom_group 1 1 24 0 Table
civicrm_custom_group_en_US 0 0 21 0 View
civicrm_custom_group_fr_CA 0 0 21 0 View
civicrm_cxn 0 0 11 0 Table
civicrm_dashboard 1 1 12 6 Table
civicrm_dashboard_contact 0 2 6 3 Table
civicrm_dashboard_en_US 0 0 11 0 View
civicrm_dashboard_fr_CA 0 0 11 0 View
civicrm_dedupe_exception 0 2 3 0 Table
civicrm_dedupe_rule 0 1 6 17 Table
civicrm_dedupe_rule_group 2 0 7 7 Table
civicrm_discount 1 1 6 0 Table
civicrm_domain 17 1 7 0 Table
civicrm_email 5 1 12 4 Table
civicrm_entity_batch 0 1 4 0 Table
civicrm_entity_file 0 1 4 0 Table
civicrm_entity_financial_account 0 1 5 25 Table
civicrm_entity_financial_trxn 0 1 5 0 Table
civicrm_entity_tag 0 1 4 0 Table
civicrm_event 2 4 92 0 Table
civicrm_event_carts 2 1 3 0 Table
civicrm_event_en_US 0 0 69 0 View
civicrm_event_fr_CA 0 0 69 0 View
civicrm_events_in_carts 0 2 3 0 Table
civicrm_extension 0 0 8 2 Table
civicrm_file 1 0 7 0 Table
civicrm_financial_account 5 2 15 14 Table
civicrm_financial_item 0 2 11 5 Table
civicrm_financial_trxn 1 3 17 0 Table
civicrm_financial_type 12 0 6 4 Table
civicrm_grant 0 2 15 0 Table
civicrm_group 10 3 21 0 Table
civicrm_group_contact 0 4 6 0 Table
civicrm_group_contact_cache 0 2 3 0 Table
civicrm_group_en_US 0 0 20 0 View
civicrm_group_fr_CA 0 0 20 0 View
civicrm_group_nesting 0 2 3 0 Table
civicrm_group_organization 0 2 3 0 Table
civicrm_im 2 1 7 0 Table
civicrm_job 0 1 11 17 Table
civicrm_job_log 0 1 8 97527 Table
civicrm_line_item 0 4 14 0 Table
civicrm_loc_block 2 8 9 0 Table
civicrm_location_type 3 0 9 5 Table
civicrm_location_type_en_US 0 0 8 0 View
civicrm_location_type_fr_CA 0 0 8 0 View
civicrm_log 0 1 6 181 Table
civicrm_mail_settings 0 1 15 0 Table
civicrm_mailing 4 13 43 0 Table
civicrm_mailing_abtest 0 1 14 0 Table
civicrm_mailing_bounce_pattern 0 1 3 164 Table
civicrm_mailing_bounce_type 1 0 4 11 Table
civicrm_mailing_component 5 0 8 8 Table
civicrm_mailing_event_bounce 0 1 5 0 Table
civicrm_mailing_event_confirm 0 1 3 0 Table
civicrm_mailing_event_delivered 0 1 3 0 Table
civicrm_mailing_event_forward 0 2 4 0 Table
civicrm_mailing_event_opened 0 1 3 0 Table
civicrm_mailing_event_queue 8 4 6 0 Table
civicrm_mailing_event_reply 0 1 3 0 Table
civicrm_mailing_event_subscribe 1 2 5 0 Table
civicrm_mailing_event_trackable_url_open 0 2 4 0 Table
civicrm_mailing_event_unsubscribe 0 1 4 0 Table
civicrm_mailing_group 0 1 7 0 Table
civicrm_mailing_job 3 2 11 0 Table
civicrm_mailing_recipients 0 4 5 0 Table
civicrm_mailing_spool 0 1 7 0 Table
civicrm_mailing_trackable_url 1 1 3 0 Table
civicrm_managed 0 0 6 0 Table
civicrm_mapping 2 0 4 0 Table
civicrm_mapping_field 0 3 14 0 Table
civicrm_membership 3 6 15 0 Table
civicrm_membership_block 0 2 17 0 Table
civicrm_membership_block_en_US 0 0 13 0 View
civicrm_membership_block_fr_CA 0 0 13 0 View
civicrm_membership_log 0 4 9 0 Table
civicrm_membership_payment 0 2 3 0 Table
civicrm_membership_status 2 0 16 7 Table
civicrm_membership_status_en_US 0 0 15 0 View
civicrm_membership_status_fr_CA 0 0 15 0 View
civicrm_membership_type 4 3 23 0 Table
civicrm_membership_type_en_US 0 0 21 0 View
civicrm_membership_type_fr_CA 0 0 21 0 View
civicrm_menu 0 2 22 440 Table
civicrm_msg_template 3 0 11 48 Table
civicrm_navigation 2 2 12 257 Table
civicrm_note 0 1 8 0 Table
civicrm_openid 0 1 6 0 Table
civicrm_option_group 1 0 10 93 Table
civicrm_option_group_en_US 0 0 8 0 View
civicrm_option_group_fr_CA 0 0 8 0 View
civicrm_option_value 0 3 20 847 Table
civicrm_option_value_en_US 0 0 18 0 View
civicrm_option_value_fr_CA 0 0 18 0 View
civicrm_participant 2 8 19 0 Table
civicrm_participant_payment 0 2 3 0 Table
civicrm_participant_status_type 1 0 10 16 Table
civicrm_participant_status_type_en_US 0 0 9 0 View
civicrm_participant_status_type_fr_CA 0 0 9 0 View
civicrm_payment_processor 3 2 22 2 Table
civicrm_payment_processor_type 1 0 23 13 Table
civicrm_payment_token 1 3 13 0 Table
civicrm_pcp 1 1 16 0 Table
civicrm_pcp_block 0 1 14 0 Table
civicrm_pcp_block_en_US 0 0 13 0 View
civicrm_pcp_block_fr_CA 0 0 13 0 View
civicrm_persistent 0 0 5 0 Table
civicrm_phone 5 1 10 0 Table
civicrm_pledge 1 4 23 0 Table
civicrm_pledge_block 0 0 11 0 Table
civicrm_pledge_payment 0 2 10 0 Table
civicrm_preferences_date 0 0 7 7 Table
civicrm_premiums 1 0 14 0 Table
civicrm_premiums_en_US 0 0 11 0 View
civicrm_premiums_fr_CA 0 0 11 0 View
civicrm_premiums_product 0 3 5 0 Table
civicrm_prevnext_cache 0 0 7 0 Table
civicrm_price_field 2 1 20 4 Table
civicrm_price_field_en_US 0 0 17 0 View
civicrm_price_field_fr_CA 0 0 17 0 View
civicrm_price_field_value 1 3 22 8 Table
civicrm_price_field_value_en_US 0 0 18 0 View
civicrm_price_field_value_fr_CA 0 0 18 0 View
civicrm_price_set 3 2 16 4 Table
civicrm_price_set_en_US 0 0 13 0 View
civicrm_price_set_entity 0 1 4 2 Table
civicrm_price_set_fr_CA 0 0 13 0 View
civicrm_print_label 0 1 11 0 Table
civicrm_product 1 1 22 0 Table
civicrm_product_en_US 0 0 19 0 View
civicrm_product_fr_CA 0 0 19 0 View
civicrm_queue_item 0 0 6 0 Table
civicrm_recurring_entity 0 0 5 0 Table
civicrm_relationship 1 4 11 0 Table
civicrm_relationship_type 2 0 15 10 Table
civicrm_relationship_type_en_US 0 0 12 0 View
civicrm_relationship_type_fr_CA 0 0 12 0 View
civicrm_report_instance 1 5 21 36 Table
civicrm_saved_search 2 1 7 0 Table
civicrm_setting 0 4 9 150 Table
civicrm_sms_provider 2 1 11 0 Table
civicrm_state_province 2 1 4 3934 Table
civicrm_status_pref 0 1 7 9 Table
civicrm_subscription_history 0 2 7 0 Table
civicrm_survey 0 3 24 0 Table
civicrm_survey_en_US 0 0 20 0 View
civicrm_survey_fr_CA 0 0 20 0 View
civicrm_system_log 0 0 7 0 Table
civicrm_tag 2 2 11 0 Table
civicrm_tell_friend 0 0 15 0 Table
civicrm_tell_friend_en_US 0 0 10 0 View
civicrm_tell_friend_fr_CA 0 0 10 0 View
civicrm_timezone 0 1 6 0 Table
civicrm_uf_field 0 2 22 73 Table
civicrm_uf_field_en_US 0 0 19 0 View
civicrm_uf_field_fr_CA 0 0 19 0 View
civicrm_uf_group 3 3 30 13 Table
civicrm_uf_group_en_US 0 0 25 0 View
civicrm_uf_group_fr_CA 0 0 25 0 View
civicrm_uf_join 0 1 8 6 Table
civicrm_uf_match 0 2 6 3 Table
civicrm_website 0 1 4 0 Table
civicrm_word_replacement 0 1 6 0 Table
civicrm_worldregion 1 0 2 6 Table