Civicrm tables

These are the tables used by CiviCRM 2:
* civicrm_acl - access control list, list of different permissions (unused?)
* civicrm_acl_cache - cache of permissions assigned to contacts (unused?)
* civicrm_acl_entity_role - assign permissions to a group or contact (unused?)
* civicrm_activity* - activities associated with or assigned to contacts (emails, meetings, etc.)
* civicrm_activity_assignment* - bridge table to associate activities with contacts
* civicrm_activity_target* - bridge table to assign activities to contacts
* civicrm_address* - address of a contact
* civicrm_cache - temporary menu items, contact lists, etc.
* civicrm_case - cases for case management (CiviCase component, unused)
* civicrm_case_activity - bridge table to associate a case with an activity (CiviCase component, unused)
* civicrm_case_contact - bridge table to associate a case with a contact (CiviCase component, unused)
* civicrm_component - CiviCRM components (CiviReport, CiviEvent, etc.)
* civicrm_contact* - contact records (name, demographic information, etc.)
* civicrm_contribution* - contribution records (date, amount, contact id, etc.) (CiviContribute component)
* civicrm_contribution_page - online contribution pages (CiviContribute component, unused)
* civicrm_contribution_product - (CiviContribute component, unused)
* civicrm_contribution_recur - recurring contributions (CiviContribute component, unused)
* civicrm_contribution_soft* - soft contributions (CiviContribute component)
* civicrm_contribution_type - types of contributions (CiviContribute component)
* civicrm_contribution_widget - settings for contribution widgets (CiviContribute component, unused)
* civicrm_country - countries and associated codes
* civicrm_county - counties (we only have 6, not sure what this is used for)
* civicrm_currency - currency types
* civicrm_custom_field - custom form fields (language for example)
* civicrm_custom_group - groups for custom fields
* civicrm_dedupe_rule - rules for deduping
* civicrm_dedupe_rule_group - groups for dedupe rules (Individual/Fuzzy, Organization/Strict, etc.)
* civicrm_discount - event early bird discounts (CiviEvent component, unused)
* civicrm_domain - site installation config info
* civicrm_email* - email addresses for contacts
* civicrm_entity_file - associate files with entities (we use only for activities)
* civicrm_entity_tag* - bridge table to associate tags with contacts
* civicrm_event - events (CiviEvent component?, unused)
* civicrm_file - files stored as BLOBs
* civicrm_financial_trxn - financial transactions (unused)
* civicrm_grant - grants (unused)
* civicrm_group - contact groups (office staff, vendors, admins, etc.)
* civicrm_group_contact* - bridge table associating contacts with groups
* civicrm_group_contact_cache* - cache of contact-group associations
* civicrm_group_nesting - assign child groups to parent groups (unused)
* civicrm_group_organization - bridge table associating organizations with groups (unused)
* civicrm_im* - instant messaging handles
* civicrm_import_job_... - imports
* civicrm_line_item - associate a line item (item, quality, price) with an entity (unused)
* civicrm_location_type - location types (Home, Work, etc.) (only one of each per contact)
* civicrm_loc_block - let's you associate a location (address, email, phone, etc.) with something other than a contact
* civicrm_log* - log of modifications and who made them
* civicrm_mailing** - emails created in CiviCRM (CiviMail component)
* civicrm_mailing_bounce_pattern - email bounce error codes (CiviMail component)
* civicrm_mailing_bounce_type - types for bounce error codes (CiviMail component)
* civicrm_mailing_component - reusable email templates (CiviMail component)
* civicrm_mailing_event_bounce - log of bounce events (CiviMail component)
* civicrm_mailing_event_confirm - log of email subscription confirmations (CiviMail component)
* civicrm_mailing_event_delivered - log of email deliveries (CiviMail component)
* civicrm_mailing_event_forward - log of email forwards (CiviMail component)
* civicrm_mailing_event_opened - log of email openings (CiviMail component)
* civicrm_mailing_event_queue* - queue for email events (CiviMail component)
* civicrm_mailing_event_reply - log of email replies (CiviMail component)
* civicrm_mailing_event_subscribe* - log of subscription events (CiviMail component)
* civicrm_mailing_event_trackable_url_open - log of opening trackable urls from emails (CiviMail component)
* civicrm_mailing_event_unsubscribe - log of email unsubscriptions (CiviMail component)
* civicrm_mailing_group - mailing groups (CiviMail component)
* civicrm_mailing_job - log of email sending jobs (CiviMail component)
* civicrm_mailing_spool - temporary spool of email jobs (CiviMail component)
* civicrm_mailing_trackable_url - trackable URLs for emails (CiviMail component)
* civicrm_mail_settings - installation settings for CiviMail (CiviMail component)
* civicrm_mapping - saved import/export mapping sets
* civicrm_mapping_field - specific field mappings for saved sets
* civicrm_membership - memberships in organization by contact (CiviMember component, unused)
* civicrm_membership_block - let's you associate membership with something other than a contact (CiviMember component, unused)
* civicrm_membership_log - log of membership events (CiviMember component, unused)
* civicrm_membership_payment - bridge table for membership payments (CiviMember component, unused)
* civicrm_membership_status - possible membership statuses (new, expired, etc.) (CiviMember component)
* civicrm_membership_type - membership types (fees, duration, renewal, etc.) (CiviMember component, unused)
* civicrm_menu - custom menus
* civicrm_msg_template - mass email templates (CiviMail component?)
* civicrm_note* - notes associated with entities (usually contacts)
* civicrm_openid* - openIDs associated with contacts
* civicrm_openid_associations - ? (unused)
* civicrm_openid_nonces - ? (unused)
* civicrm_option_group - configurable option groups
* civicrm_option_values - values for option groups
* civicrm_participant* - event participants (CiviEvent component?, unused)
* civicrm_participant_payment - contributions for event participation (CiviEvent component?, unused)
* civicrm_payment_processor - payment processors (unused)
* civicrm_payment_processor_type - payment processor types (PayPal Express, Google Checkout, etc.)
* civicrm_pcp* - personal campaign pages (currently unused, but might be useful for chapters)
* civicrm_pcp_block - allows you to associate a personal campaign page with something other than a contact (unused)
* civicrm_phone* - phone numbers associated with contacts
* civicrm_pledge* - pledges by contacts (unused)
* civicrm_pledge_block - allows you to associate a pledge with something other than a contact (unused)
* civicrm_pledge_payment - contributions paid towards a pledge (unused)
* civicrm_preferences - sitewide installation preferences
* civicrm_preferences_date - date format preferences
* civicrm_premiums - premiums information (unused)
* civicrm_premiums_product - bridge table associating premiums with products (unused)
* civicrm_price_field - price fields that can be associated with a set (unused)
* civicrm_price_set - sets of price fields (unused)
* civicrm_price_set_entity - bridge table associating price sets with entities (unused)
* civicrm_product - information for a product (unused)
* civicrm_project - projects (unused)
* civicrm_relationship* - relationships between contacts
* civicrm_relationship_types - types of relationships (child, spouse, etc.)
* civicrm_report_instance - saved reports (CiviReport component)
* civicrm_saved_search - saved searches
* civicrm_state_province - states and associated codes
* civicrm_subscription_history - log of contacts being added or removed from groups
* civicrm_tag - possible tags for contacts (needs review, major donor, etc.) (associated by civicrm_entity_tag)
* civicrm_task - tasks (unused)
* civicrm_task_status - the status of tasks (unused)
* civicrm_tell_friend - tell a friend messages (unused)
* civicrm_timezone - associate time zones with countries (unused)
* civicrm_uf_field - fields for user framework forms
* civicrm_uf_group - user framework forms
* civicrm_uf_join - join fields for user framework forms
* civicrm_uf_match* - user framework associations
* civicrm_uf_match_backup* - backup of user framework associations 
* civicrm_value_1_check_number_9 - Gift Information custom fieldset (check number, currency, etc. associated with contributions)
* civicrm_value_1_communication_4* - Communication custom fieldset (invalid info associated with contact or organization)
* civicrm_value_1_currency_3 - Thank you custom fieldset (thank you messages associated with contributions)
* civicrm_value_1_gift_data_7 - Gift Data custom fieldset (fund, campaign, etc. associated with contributions)
* civicrm_value_1_language - Language custom fieldset (languages associated with contact or organization)
* civicrm_value_1_note_11 - Donor comment custom fieldset (comments associated with contributions)
* civicrm_value_1_primary_contact_name_9*? - deprecated?
* civicrm_value_1_prospect_5 - Prospect custom fieldset (donor prospect information associated with contact or organization)
* civicrm_value_1_soft_credit_data_8 - Soft Credit Data custom fieldset (soft credit info associated with contributions)
* civicrm_value_1_solicitation_6 - Solicitor custom fieldset (solicitor level associated with relationships)
* civicrm_value_1_stock_information_10 - Stock Information custom fieldset (stock donations associated with contributions)
* civicrm_value_1_assistant_15* - Assistant custom fieldset (assistant contact info associated with contact)
* civicrm_value_1_organization_contact_14 - Organization contact custom fieldset (contact info associated with organization)
* civicrm_worldregion - regions of the world (Americas, Asia-Pacific, etc.)
* public_reporting* - reporting info for contributions (name, amount, etc.)
* = related to contacts
Category:Fundraising Archive