civicrm Database

TABLES 155

COLUMNS 2861

Constraints 267

Anomalies 5

Routines 0

Database Properties

Database Type: MySQL - 5.5.5-10.1.44-MariaDB-0ubuntu0.18.04.1

Tables

All Tables Views Comments

Search:

Table / View	Children	Parents	Columns	Rows	Type
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	12	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	55	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	70	2	52	3	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	31	0	Table
civicrm_contribution_page	4	3	59	3	Table
civicrm_contribution_page_en_US	0	0	46	0	View
civicrm_contribution_page_fr_CA	0	0	46	0	View
civicrm_contribution_product	0	2	10	0	Table
civicrm_contribution_recur	2	5	29	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	18	Table
civicrm_dedupe_rule_group	2	0	7	8	Table
civicrm_discount	1	1	6	0	Table
civicrm_domain	17	1	7	0	Table
civicrm_email	5	1	12	3	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	10	Table
civicrm_file	1	1	8	0	Table
civicrm_financial_account	5	2	15	14	Table
civicrm_financial_item	0	2	11	0	Table
civicrm_financial_trxn	1	3	18	0	Table
civicrm_financial_type	12	0	6	4	Table
civicrm_grant	0	2	15	0	Table
civicrm_group	10	3	21	3	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_install_canary	0	0	1	0	Table
civicrm_job	0	1	11	17	Table
civicrm_job_log	0	1	8	243898	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	338	Table
civicrm_mail_settings	0	1	15	0	Table
civicrm_mailing	4	13	43	5	Table
civicrm_mailing_abtest	0	1	14	0	Table
civicrm_mailing_bounce_pattern	0	1	3	165	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	16	0	Table
civicrm_membership_block	0	2	17	2	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	2	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	453	Table
civicrm_mosaico_msg_template	0	1	7	0	Table
civicrm_mosaico_template	0	1	7	0	Table
civicrm_msg_template	5	0	11	48	Table
civicrm_navigation	2	2	12	295	Table
civicrm_note	0	1	8	0	Table
civicrm_openid	0	1	6	0	Table
civicrm_option_group	1	0	10	95	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	864	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	24	2	Table
civicrm_payment_processor_en_US	0	0	23	0	View
civicrm_payment_processor_fr_CA	0	0	23	0	View
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_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	7	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	13	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	6	Table
civicrm_price_set_en_US	0	0	13	0	View
civicrm_price_set_entity	0	1	4	4	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	165	Table
civicrm_sms_provider	2	1	11	0	Table
civicrm_state_province	2	1	4	3945	Table
civicrm_status_pref	0	1	8	20	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	33	13	Table
civicrm_uf_group_en_US	0	0	27	0	View
civicrm_uf_group_fr_CA	0	0	27	0	View
civicrm_uf_join	0	1	8	6	Table
civicrm_uf_match	0	2	6	2	Table
civicrm_value_informations__1	0	1	5	1152	Table
civicrm_website	0	1	4	0	Table
civicrm_word_replacement	0	1	6	0	Table
civicrm_worldregion	1	0	2	6	Table

Showing 1 to 211 of 211 entries