Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
civicrm_membership_block_fr_CA View new_text TEXT 65535 null
civicrm_pcp Table goal_amount DECIMAL 20 null

Goal amount of this Personal Campaign Page.

civicrm_county Table state_province_id INT UNSIGNED 10 null

ID of State/Province that County belongs

civicrm_contribution Table campaign_id INT UNSIGNED 10 null

The campaign for which this contribution has been triggered.

civicrm_group_contact Table email_id INT UNSIGNED 10 null

Optional email to associate with this membership

civicrm_membership_status_fr_CA View is_reserved TINYINT 3 0

Is this membership_status reserved.

civicrm_event Table confirm_from_email VARCHAR 255 null

FROM email address used for confirmation emails.

civicrm_batch_fr_CA View exported_date DATETIME 19 null
civicrm_entity_financial_account Table id INT UNSIGNED 10 null

ID

civicrm_cxn Table secret TEXT 65535 null

Shared secret

civicrm_batch Table created_date DATETIME 19 null

When was this item created

civicrm_uf_group_fr_CA View help_post TEXT 65535 null
civicrm_uf_group_en_US View limit_listings_group_id INT UNSIGNED 10 null

Group id, foriegn key from civicrm_group

civicrm_membership_type Table auto_renew TINYINT 3 0

0 = No auto-renew option; 1 = Give option, but not required; 2 = Auto-renew required;

civicrm_option_value Table is_active TINYINT 3 1

Is this option active?

civicrm_contribution_page Table is_allow_other_amount TINYINT 3 0

if true, page will include an input text field where user can enter their own amount

civicrm_acl Table acl_id INT UNSIGNED 10 null

ID of the ACL or ACL group being granted/revoked

civicrm_job Table api_action VARCHAR 255 null

Action of the job api call

civicrm_price_set Table help_post_en_US TEXT 65535 null
civicrm_relationship Table is_permission_a_b TINYINT 3 0

is contact a has permission to view / edit contact and related data for contact b ?

civicrm_contribution_recur Table amount DECIMAL 20 null

Amount to be contributed or charged each recurrence.

civicrm_contribution_page Table thankyou_footer_fr_CA TEXT 65535 null
civicrm_activity_contact Table contact_id INT UNSIGNED 10 null

Foreign key to the contact for this record.

civicrm_participant_status_type_en_US View class VARCHAR 8 null

the general group of status type this one belongs to

civicrm_payment_token Table email VARCHAR 255 null

Email at the time of token creation. Useful for fraud forensics

civicrm_mailing_abtest Table created_date DATETIME 19 null

When was this item created

civicrm_group Table title_fr_CA VARCHAR 64 null
civicrm_case_type Table weight INT 10 1

Ordering of the case types

civicrm_event_en_US View registration_start_date DATETIME 19 null

Date and time that online registration starts.

civicrm_price_set_en_US View help_pre TEXT 65535 null
civicrm_option_value_fr_CA View description TEXT 65535 null
civicrm_mailing_abtest Table name VARCHAR 128 null

Name of the A/B test

civicrm_option_group_en_US View is_reserved TINYINT 3 1

Is this a predefined system option group (i.e. it can not be deleted)?

civicrm_acl_contact_cache Table user_id INT UNSIGNED 10 null

FK to civicrm_contact (could be null for anon user)

civicrm_prevnext_cache Table id INT UNSIGNED 10 null
civicrm_acl Table is_active TINYINT 3 null

Is this property active?

civicrm_custom_field_fr_CA View custom_group_id INT UNSIGNED 10 null

FK to civicrm_custom_group.

civicrm_queue_item Table weight INT 10 null
civicrm_contribution Table receipt_date DATETIME 19 null

when (if) receipt was sent. populated automatically for online donations w/ automatic receipting

civicrm_acl_cache Table contact_id INT UNSIGNED 10 null

Foreign Key to Contact

civicrm_address Table postal_code VARCHAR 64 null
civicrm_event Table default_discount_fee_id INT UNSIGNED 10 null

FK to civicrm_option_value.

civicrm_entity_file Table file_id INT UNSIGNED 10 null

FK to civicrm_file

civicrm_payment_processor_type Table url_api_default VARCHAR 255 null
civicrm_membership_type Table relationship_type_id VARCHAR 64 null

FK to Relationship Type ID

civicrm_extension Table is_active TINYINT 3 1

Is this extension active?

civicrm_membership_type_en_US View description VARCHAR 255 null
civicrm_event_fr_CA View is_confirm_enabled TINYINT 3 1

If false, the event booking confirmation screen gets skipped

civicrm_contribution_page_fr_CA View is_partial_payment TINYINT 3 0

is partial payment enabled for this online contribution page

civicrm_participant Table event_id INT UNSIGNED 10 null

FK to Event ID

civicrm_price_field_en_US View label VARCHAR 255 null
civicrm_grant Table application_received_date DATE 10 null

Date on which grant application was received by donor.

civicrm_pcp_block Table is_approval_needed TINYINT 3 null

Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?

civicrm_survey_fr_CA View thankyou_title VARCHAR 255 null
civicrm_address Table name VARCHAR 255 null
civicrm_contribution_page Table created_date DATETIME 19 null

Date and time that contribution page was created.

civicrm_contribution_page Table footer_text_fr_CA TEXT 65535 null
civicrm_location_type_en_US View is_reserved TINYINT 3 null

Is this location type a predefined system location?

civicrm_uf_group Table help_pre_en_US TEXT 65535 null
civicrm_financial_trxn Table trxn_date DATETIME 19 null

date transaction occurred

civicrm_group_en_US View created_id INT UNSIGNED 10 null

FK to contact table.

civicrm_event_en_US View start_date DATETIME 19 null

Date and time that event starts.

civicrm_location_type_fr_CA View id INT UNSIGNED 10 0

Location Type ID

civicrm_membership_type_fr_CA View fixed_period_start_day INT 10 null

For fixed period memberships, month and day (mmdd) on which subscription/membership will start. Period start is back-dated unless after rollover day.

civicrm_membership_type Table relationship_direction VARCHAR 128 null
civicrm_survey_en_US View result_id INT UNSIGNED 10 null

Used to store option group id.

civicrm_pcp_block_fr_CA View target_entity_id INT UNSIGNED 10 null

The entity that this pcp targets

civicrm_event_fr_CA View allow_same_participant_emails TINYINT 3 0

if true - allows the user to register multiple registrations from same email address.

civicrm_premiums_en_US View premiums_display_min_contribution TINYINT 3 null

Boolean. Should we automatically display minimum contribution amount text after the premium descriptions.

civicrm_custom_group_en_US View is_public BIT 0 1

Is this property public?

civicrm_price_field_en_US View is_active TINYINT 3 1

Is this price field active

civicrm_mailing_component Table body_text TEXT 65535 null

Body of the component in text format.

civicrm_mailing_abtest Table winner_criteria VARCHAR 32 null
civicrm_batch_en_US View created_date DATETIME 19 null

When was this item created

civicrm_event_en_US View id INT UNSIGNED 10 0

Event

civicrm_job_log Table command VARCHAR 255 null

Full path to file containing job script

civicrm_case_type_en_US View name VARCHAR 64 null

Machine name for Case Type

civicrm_country Table region_id INT UNSIGNED 10 null

Foreign key to civicrm_worldregion.id.

civicrm_payment_processor_type Table url_button_default VARCHAR 255 null
civicrm_relationship_type Table label_a_b_en_US VARCHAR 64 null
civicrm_event Table min_initial_amount DECIMAL 20 null

Minimum initial amount for partial payment

civicrm_tell_friend_fr_CA View thankyou_title VARCHAR 255 null
civicrm_mapping_field Table mapping_id INT UNSIGNED 10 null

Mapping to which this field belongs

civicrm_mailing_recipients Table email_id INT UNSIGNED 10 null

FK to Email

civicrm_contribution_page_en_US View initial_amount_help_text TEXT 65535 null
civicrm_contribution_page_en_US View default_amount_id INT UNSIGNED 10 null

FK to civicrm_option_value.

civicrm_premiums_fr_CA View premiums_contact_phone VARCHAR 50 null

This phone number is included in receipts if it is populated and a premium has been selected.

civicrm_price_field_value_fr_CA View id INT UNSIGNED 10 0

Price Field Value

civicrm_group Table is_reserved TINYINT 3 0
civicrm_contribution_page_fr_CA View is_pay_later TINYINT 3 0

if true - allows the user to send payment directly to the org later

civicrm_dashboard_fr_CA View is_active TINYINT 3 0

Is this dashlet active?

civicrm_payment_token Table ip_address VARCHAR 255 null

IP used when creating the token. Useful for fraud forensics

civicrm_contribution_recur Table next_sched_contribution_date DATETIME 19 null

Next scheduled date

civicrm_financial_trxn Table check_number VARCHAR 255 null

Check number

civicrm_uf_field_en_US View phone_type_id INT UNSIGNED 10 null

Phone Type Id, if required

civicrm_price_field_value_en_US View visibility_id INT UNSIGNED 10 1

Implicit FK to civicrm_option_group with name = 'visibility'

civicrm_contribution_soft Table contact_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_price_field_value_fr_CA View is_active TINYINT 3 1

Is this price field value active

civicrm_relationship Table end_date DATE 10 null

date when the relationship ended

civicrm_contact_type_en_US View name VARCHAR 64 null

Internal name of Contact Type (or Subtype).

civicrm_uf_group_en_US View created_date DATETIME 19 null

Date and time this UF group was created.

civicrm_option_group_fr_CA View is_active TINYINT 3 null

Is this option group active?

civicrm_discount Table price_set_id INT UNSIGNED 10 null

FK to civicrm_price_set

civicrm_membership_block_fr_CA View id INT UNSIGNED 10 0

Membership Id

civicrm_uf_group_fr_CA View is_cms_user TINYINT 3 0

Should we create a cms user for this profile

civicrm_job_log Table data TEXT 65535 null

Potential extended data for specific job run (e.g. tracebacks).

civicrm_activity Table weight INT 10 null
civicrm_price_field Table name VARCHAR 255 null

Variable name/programmatic handle for this field.

civicrm_pledge Table frequency_interval INT UNSIGNED 10 1

Number of time units for recurrence of pledge payments.

civicrm_pcp_block_en_US View notify_email VARCHAR 255 null

If set, notification is automatically emailed to this email-address on create/update Personal Campaign Page

civicrm_print_label Table data LONGTEXT 2147483647 null

contains json encode configurations options

civicrm_contribution_widget Table about TEXT 65535 null

About description.

civicrm_participant Table fee_amount DECIMAL 20 null

actual processor fee if known - may be 0.

civicrm_relationship_type Table description_en_US VARCHAR 255 null
civicrm_event Table description_en_US TEXT 65535 null
civicrm_contribution_soft Table soft_credit_type_id INT UNSIGNED 10 null

Soft Credit Type ID.Implicit FK to civicrm_option_value where option_group = soft_credit_type.

civicrm_group_en_US View parents TEXT 65535 null

IDs of the parent(s)

civicrm_membership_type_en_US View fixed_period_rollover_day INT 10 null

For fixed period memberships, signups after this day (mmdd) rollover to next period.

civicrm_survey_en_US View release_frequency INT UNSIGNED 10 null

Number of days for recurrence of release.

civicrm_survey_en_US View campaign_id INT UNSIGNED 10 null

Foreign key to the Campaign.

civicrm_contact Table postal_greeting_display VARCHAR 255 null

Cache Postal greeting.

civicrm_dedupe_rule Table rule_length INT UNSIGNED 10 null

The lenght of the matching substring

civicrm_subscription_history Table tracking VARCHAR 255 null

IP address or other tracking info

civicrm_mailing Table subject VARCHAR 128 null

Subject of mailing

civicrm_membership_block_fr_CA View membership_type_default INT UNSIGNED 10 null

Optional foreign key to membership_type

civicrm_action_log Table entity_table VARCHAR 255 null

name of the entity table for the above id, e.g. civicrm_activity, civicrm_participant

civicrm_contribution_product Table contribution_id INT UNSIGNED 10 null
civicrm_event_fr_CA View initial_amount_help_text TEXT 65535 null
civicrm_location_type_en_US View display_name VARCHAR 64 null
civicrm_membership_type Table weight INT 10 null
civicrm_sms_provider Table is_default TINYINT 3 0
civicrm_custom_group Table help_pre_fr_CA TEXT 65535 null
civicrm_contribution_page Table thankyou_title_fr_CA VARCHAR 255 null
civicrm_survey Table created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this Survey.

civicrm_price_field_fr_CA View label VARCHAR 255 null
civicrm_price_set_en_US View is_quick_config TINYINT 3 0

Is set if edited on Contribution or Event Page rather than through Manage Price Sets

civicrm_event_fr_CA View event_full_text TEXT 65535 null
civicrm_group Table group_type VARCHAR 128 null

FK to group type

civicrm_contribution_page_en_US View intro_text TEXT 65535 null
civicrm_address_format Table id INT UNSIGNED 10 null

Address Format Id

civicrm_group_en_US View group_type VARCHAR 128 null

FK to group type

civicrm_cxn Table options TEXT 65535 null

Options for the service (JSON)

civicrm_custom_field_fr_CA View is_searchable TINYINT 3 null

Is this property searchable.

civicrm_grant Table amount_requested DECIMAL 20 null

Requested grant amount, in original currency (optional).

civicrm_survey_fr_CA View is_share TINYINT 3 1

Can people share the petition through social media?

civicrm_activity_contact Table id INT UNSIGNED 10 null

Activity contact id

civicrm_entity_file Table entity_table VARCHAR 64 null

physical tablename for entity being joined to file, e.g. civicrm_contact

civicrm_campaign Table title VARCHAR 255 null

Title of the Campaign.

civicrm_survey_fr_CA View release_frequency INT UNSIGNED 10 null

Number of days for recurrence of release.

civicrm_membership_status Table end_event VARCHAR 12 null

Event after which this status ends.

civicrm_mapping_field Table im_provider_id INT UNSIGNED 10 null

Which type of IM Provider does this name belong.

civicrm_batch Table status_id INT UNSIGNED 10 null

fk to Batch Status options in civicrm_option_values

civicrm_uf_group_fr_CA View add_captcha TINYINT 3 0

Should a CAPTCHA widget be included this Profile form.

civicrm_participant_payment Table contribution_id INT UNSIGNED 10 null

FK to contribution table.

civicrm_contribution_recur Table payment_token_id INT UNSIGNED 10 null

Optionally used to store a link to a payment token used for this recurring contribution.

civicrm_uf_group Table name VARCHAR 64 null

Name of the UF group for directly addressing it in the codebase

civicrm_mailing Table from_name VARCHAR 128 null

From Header of mailing

civicrm_campaign Table campaign_type_id INT UNSIGNED 10 null

Campaign Type ID.Implicit FK to civicrm_option_value where option_group = campaign_type

civicrm_sms_provider Table name VARCHAR 64 null

Provider internal name points to option_value of option_group sms_provider_name

civicrm_uf_group_en_US View cancel_button_text VARCHAR 64 null

Custom Text to display on the cancel button when used in create or edit mode

civicrm_option_group_fr_CA View name VARCHAR 64 null

Option group name. Used as selection key by class properties which lookup options in civicrm_option_value.

civicrm_menu Table component_id INT UNSIGNED 10 null

Component that this menu item belongs to

civicrm_uf_group_fr_CA View title VARCHAR 64 null
civicrm_price_field_en_US View html_type VARCHAR 12 null
civicrm_mailing Table modified_date TIMESTAMP 19 CURRENT_TIMESTAMP

When the mailing (or closely related entity) was created or modified or deleted.

civicrm_action_mapping Table entity VARCHAR 64 null

Entity for which the reminder is created

civicrm_custom_field_fr_CA View help_post TEXT 65535 null
civicrm_option_value_en_US View name VARCHAR 255 null

Stores a fixed (non-translated) name for this option value. Lookup functions should use the name as the key for the option value row.

civicrm_relationship Table is_permission_b_a TINYINT 3 0

is contact b has permission to view / edit contact and related data for contact a ?

civicrm_pcp Table intro_text TEXT 65535 null
civicrm_uf_field_en_US View is_searchable TINYINT 3 0

Is this field included search form of profile?

civicrm_mailing Table language VARCHAR 5 null

Language of the content of the mailing. Useful for tokens.

civicrm_price_field_value_fr_CA View weight INT 10 1

Order in which the field options should appear

civicrm_custom_group Table help_post_en_US TEXT 65535 null
civicrm_website Table website_type_id INT UNSIGNED 10 null

Which Website type does this website belong to.

civicrm_group_fr_CA View visibility VARCHAR 24 User and User Admin Only

In what context(s) is this field visible.

civicrm_price_field_value_fr_CA View help_post TEXT 65535 null

Price field option post help text.

civicrm_dedupe_exception Table contact_id1 INT UNSIGNED 10 null

FK to Contact ID

civicrm_batch_fr_CA View payment_instrument_id INT UNSIGNED 10 null

fk to Payment Instrument options in civicrm_option_values

civicrm_price_set Table help_post_fr_CA TEXT 65535 null
civicrm_msg_template Table workflow_id INT UNSIGNED 10 null

a pseudo-FK to civicrm_option_value

civicrm_membership_block_en_US View membership_type_default INT UNSIGNED 10 null

Optional foreign key to membership_type

civicrm_preferences_date Table time_format VARCHAR 64 null

time format

civicrm_managed Table module VARCHAR 127 null

Name of the module which declared this object

civicrm_option_value_en_US View domain_id INT UNSIGNED 10 null

Which Domain is this option value for

civicrm_phone Table is_primary TINYINT 3 0

Is this the primary phone for this contact and location.

civicrm_event_fr_CA View intro_text TEXT 65535 null
civicrm_pcp_block_en_US View id INT UNSIGNED 10 0

PCP block Id

civicrm_contribution Table cancel_date DATETIME 19 null

when was gift cancelled

civicrm_participant_status_type Table class VARCHAR 8 null

the general group of status type this one belongs to

civicrm_price_field_en_US View price_set_id INT UNSIGNED 10 null

FK to civicrm_price_set

civicrm_custom_field Table id INT UNSIGNED 10 null

Unique Custom Field ID

civicrm_event_fr_CA View payment_processor VARCHAR 128 null

Payment Processors configured for this Event (if is_monetary is true)

civicrm_managed Table cleanup VARCHAR 32 null

Policy on when to cleanup entity (always, never, unused)

civicrm_location_type Table is_active TINYINT 3 null

Is this property active?

civicrm_case_type Table name VARCHAR 64 null

Machine name for Case Type

civicrm_uf_field_en_US View is_required TINYINT 3 0

Is this field required when included in a user or registration form?

civicrm_custom_field_fr_CA View mask VARCHAR 64 null

Optional format instructions for specific field types, like date types.

civicrm_status_pref Table hush_until DATE 10 null

expires ignore_severity. NULL never hushes.

civicrm_price_field_value Table financial_type_id INT UNSIGNED 10 null

FK to Financial Type.

civicrm_contribution Table receive_date DATETIME 19 null

when was gift received

civicrm_relationship_type_fr_CA View contact_sub_type_a VARCHAR 64 null

If defined, contact_sub_type_a in a relationship of this type must be a specific contact_sub_type.

civicrm_batch_en_US View modified_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_event_fr_CA View is_multiple_registrations TINYINT 3 0

if true - allows the user to register multiple participants for event

civicrm_contribution_page_en_US View is_recur_installments TINYINT 3 0

if true - asks user for recurring installments

civicrm_address Table city VARCHAR 64 null

City, Town or Village Name.

civicrm_mailing_event_trackable_url_open Table id INT UNSIGNED 10 null
civicrm_setting Table name VARCHAR 255 null

Unique name for setting

civicrm_price_set Table is_quick_config TINYINT 3 0

Is set if edited on Contribution or Event Page rather than through Manage Price Sets

civicrm_financial_type Table name VARCHAR 64 null

Financial Type Name.

civicrm_contribution_page_fr_CA View is_active TINYINT 3 null

Is this property active?

civicrm_custom_field_en_US View option_group_id INT UNSIGNED 10 null

For elements with options, the option group id that is used

civicrm_loc_block Table email_id INT UNSIGNED 10 null
civicrm_contribution_page Table is_share TINYINT 3 1

Can people share the contribution page through social media?

civicrm_mailing_event_queue Table hash VARCHAR 255 null

Security hash

civicrm_membership_payment Table id INT UNSIGNED 10 null
civicrm_mailing_abtest Table group_percentage INT UNSIGNED 10 null
civicrm_setting Table component_id INT UNSIGNED 10 null

Component that this menu item belongs to

civicrm_status_pref Table check_info VARCHAR 255 null

These values are per-check, and can't be compared across checks.

civicrm_event_fr_CA View start_date DATETIME 19 null

Date and time that event starts.

civicrm_mailing_event_trackable_url_open Table time_stamp DATETIME 19 null

When this trackable URL open occurred.

civicrm_contact Table addressee_id INT UNSIGNED 10 null

FK to civicrm_option_value.id, that has to be valid registered Addressee.

civicrm_product_en_US View price DECIMAL 20 null

Sell price or market value for premiums. For tax-deductible contributions, this will be stored as non_deductible_amount in the contribution record.

civicrm_event Table is_confirm_enabled TINYINT 3 1

If false, the event booking confirmation screen gets skipped

civicrm_mailing_abtest Table created_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_contribution_page_fr_CA View is_recur_installments TINYINT 3 0

if true - asks user for recurring installments

civicrm_dashboard_fr_CA View cache_minutes INT UNSIGNED 10 60

Number of minutes to cache dashlet content in browser localStorage.

civicrm_price_field_value Table id INT UNSIGNED 10 null

Price Field Value

civicrm_navigation Table icon VARCHAR 255 null

CSS class name for an icon

civicrm_price_field_value Table name VARCHAR 255 null

Price field option name

civicrm_custom_field Table filter VARCHAR 255 null

Stores Contact Get API params contact reference custom fields. May be used for other filters in the future.

civicrm_phone Table mobile_provider_id INT UNSIGNED 10 null

Which Mobile Provider does this phone belong to.

civicrm_contribution_page_fr_CA View thankyou_text TEXT 65535 null
civicrm_payment_processor_type Table url_recur_test_default VARCHAR 255 null
civicrm_membership_block Table renewal_title_fr_CA VARCHAR 255 null
civicrm_pledge_block Table is_pledge_start_date_visible TINYINT 3 0

If true - recurring start date is shown.

civicrm_country Table iso_code CHAR 2 null

ISO Code

civicrm_tell_friend Table suggested_message_en_US TEXT 65535 null
civicrm_subscription_history Table group_id INT UNSIGNED 10 null

Group Id

civicrm_custom_field_en_US View help_post TEXT 65535 null
civicrm_premiums Table premiums_nothankyou_label_en_US VARCHAR 255 null
civicrm_financial_trxn Table is_payment TINYINT 3 0

Is this entry either a payment or a reversal of a payment?

civicrm_membership_block Table is_active TINYINT 3 1

Is this membership_block enabled

civicrm_custom_group Table max_multiple INT UNSIGNED 10 null

maximum number of multiple records, if 0 - no max

civicrm_loc_block Table email_2_id INT UNSIGNED 10 null
civicrm_price_field_en_US View help_pre TEXT 65535 null
civicrm_website Table id INT UNSIGNED 10 null

Unique Website ID

civicrm_action_log Table contact_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_persistent Table id INT UNSIGNED 10 null

Persistent Record Id

civicrm_contribution_product Table quantity INT 10 null
civicrm_pcp_block_en_US View target_entity_type VARCHAR 255 contribute

The type of entity that this pcp targets

civicrm_group_contact Table contact_id INT UNSIGNED 10 null

FK to civicrm_contact

civicrm_contribution Table financial_type_id INT UNSIGNED 10 null

FK to Financial Type for (total_amount - non_deductible_amount).

civicrm_mailing Table name VARCHAR 128 null

Mailing Name.

civicrm_contribution Table contribution_page_id INT UNSIGNED 10 null

The Contribution Page which triggered this contribution

civicrm_event_fr_CA View registration_end_date DATETIME 19 null

Date and time that online registration ends.

civicrm_cache Table path VARCHAR 255 null

Unique path name for cache element

civicrm_pcp_block Table is_tellfriend_enabled TINYINT 3 null

Does Personal Campaign Page allow using tell a friend?

civicrm_contribution_widget Table url_logo VARCHAR 255 null

URL to Widget logo

civicrm_contribution_page Table pay_later_text_en_US TEXT 65535 null
civicrm_mailing_spool Table id INT UNSIGNED 10 null
civicrm_contribution_page_fr_CA View initial_amount_label VARCHAR 255 null
civicrm_mail_settings Table is_ssl TINYINT 3 null

whether to use SSL or not

civicrm_event_fr_CA View min_initial_amount DECIMAL 20 null

Minimum initial amount for partial payment

civicrm_uf_group_fr_CA View add_to_group_id INT UNSIGNED 10 null

foreign key to civicrm_group_id

civicrm_financial_trxn Table status_id INT UNSIGNED 10 null

pseudo FK to civicrm_option_value of financial_item status option_group

civicrm_survey Table default_number_of_contacts INT UNSIGNED 10 null

Default number of contacts to allow for survey.

civicrm_uf_group_en_US View description TEXT 65535 null

Optional verbose description of the profile.

civicrm_option_value Table filter INT UNSIGNED 10 null

Bitwise logic can be used to create subsets of options within an option_group for different uses.

civicrm_menu Table skipBreadcrumb TINYINT 3 null

skip this url being exposed to breadcrumb

civicrm_contribution_page Table thankyou_text_fr_CA TEXT 65535 null
civicrm_participant Table discount_amount INT UNSIGNED 10 null

Discount Amount

civicrm_mailing_event_forward Table id INT UNSIGNED 10 null
civicrm_mailing_bounce_pattern Table pattern VARCHAR 255 null

A regexp to match a message to a bounce type

civicrm_tell_friend_en_US View entity_id INT UNSIGNED 10 null

Foreign key to the referenced item.

civicrm_file Table file_type_id INT UNSIGNED 10 null

Type of file (e.g. Transcript, Income Tax Return, etc). FK to civicrm_option_value.

civicrm_custom_field_fr_CA View label VARCHAR 255 null
civicrm_phone Table contact_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_contact Table modified_date TIMESTAMP 19 CURRENT_TIMESTAMP

When was the contact (or closely related entity) was created or modified or deleted.

civicrm_mapping_field Table grouping INT UNSIGNED 10 1

Used to group mapping_field records into related sets (e.g. for criteria sets in search builder mappings).

civicrm_tell_friend Table intro_en_US TEXT 65535 null
civicrm_contribution_page Table initial_amount_help_text_fr_CA TEXT 65535 null
civicrm_group_fr_CA View id INT UNSIGNED 10 0

Group ID

civicrm_survey_fr_CA View last_modified_date DATETIME 19 null

Date and time that Survey was edited last time.

civicrm_membership Table id INT UNSIGNED 10 null

Membership Id

civicrm_contribution_product Table start_date DATE 10 null

Actual start date for a time-delimited premium (subscription, service or membership)

civicrm_custom_group Table id INT UNSIGNED 10 null

Unique Custom Group ID

civicrm_preferences_date Table id INT UNSIGNED 10 null
civicrm_location_type_fr_CA View is_active TINYINT 3 null

Is this property active?

civicrm_website Table contact_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_custom_field_fr_CA View column_name VARCHAR 255 null

Name of the column that holds the values for this field.

civicrm_custom_field_en_US View mask VARCHAR 64 null

Optional format instructions for specific field types, like date types.

civicrm_uf_field_en_US View website_type_id INT UNSIGNED 10 null

Website Type Id, if required

civicrm_contribution_page_en_US View footer_text TEXT 65535 null
civicrm_membership_type_en_US View domain_id INT UNSIGNED 10 null

Which Domain is this match entry for

civicrm_log Table data TEXT 65535 null

Updates does to this object if any.

civicrm_price_set_entity Table entity_table VARCHAR 64 null

Table which uses this price set

civicrm_custom_group Table extends_entity_column_value VARCHAR 255 null

linking custom group for dynamic object

civicrm_pledge_block Table additional_reminder_day INT UNSIGNED 10 5

Send additional reminder this many days after last one sent, up to maximum number of reminders.

civicrm_uf_join Table weight INT 10 1

Controls display order when multiple user framework groups are setup for concurrent display.

civicrm_campaign_group Table campaign_id INT UNSIGNED 10 null

Foreign key to the activity Campaign.

civicrm_mapping_field Table value VARCHAR 255 null

SQL WHERE value for search-builder mapping fields.

civicrm_contribution_recur Table create_date DATETIME 19 null

When this recurring contribution record was created.

civicrm_case Table id INT UNSIGNED 10 null

Unique Case ID

civicrm_event Table confirm_from_name_en_US VARCHAR 255 null
civicrm_mailing_trackable_url Table id INT UNSIGNED 10 null
civicrm_membership_payment Table membership_id INT UNSIGNED 10 null

FK to Membership table

civicrm_uf_match Table uf_id INT UNSIGNED 10 null

UF ID

civicrm_tell_friend_fr_CA View is_active TINYINT 3 null
civicrm_option_group_en_US View title VARCHAR 255 null
civicrm_mailing_spool Table body TEXT 65535 null

The body of this mailing.

civicrm_participant_status_type Table is_counted TINYINT 3 null

whether this status type is counted against event size limit

civicrm_group_en_US View where_tables TEXT 65535 null

the tables to be included in the count statement

civicrm_contact Table preferred_language VARCHAR 5 null

Which language is preferred for communication. FK to languages in civicrm_option_value.

civicrm_mailing_event_delivered Table id INT UNSIGNED 10 null
civicrm_system_log Table id INT UNSIGNED 10 null

Primary key ID

civicrm_acl Table deny TINYINT 3 0

Is this ACL entry Allow (0) or Deny (1) ?

civicrm_contact_type_fr_CA View name VARCHAR 64 null

Internal name of Contact Type (or Subtype).

civicrm_group_en_US View refresh_date TIMESTAMP 19 null
civicrm_group_contact_cache Table contact_id INT UNSIGNED 10 null

FK to civicrm_contact

civicrm_event_en_US View description TEXT 65535 null
civicrm_contribution_recur Table cycle_day INT UNSIGNED 10 1

Day in the period when the payment should be charged e.g. 1st of month, 15th etc.

civicrm_contact Table sic_code VARCHAR 8 null

Standard Industry Classification Code.

civicrm_price_field_fr_CA View price_set_id INT UNSIGNED 10 null

FK to civicrm_price_set

civicrm_event_fr_CA View confirm_from_email VARCHAR 255 null

FROM email address used for confirmation emails.

civicrm_action_schedule Table end_frequency_interval INT UNSIGNED 10 null

Time interval till repeating the reminder.

civicrm_dashboard_contact Table weight INT 10 0

Ordering of the widgets.

civicrm_financial_account Table is_active TINYINT 3 null

Is this property active?

civicrm_uf_field_en_US View in_selector TINYINT 3 0

Is this field included as a column in the selector table?

civicrm_job Table name VARCHAR 255 null

Title of the job

civicrm_membership_type_en_US View weight INT 10 null
civicrm_case_type Table title_fr_CA VARCHAR 64 null
civicrm_mailing_event_confirm Table time_stamp DATETIME 19 null

When this confirmation event occurred.

civicrm_uf_match Table language VARCHAR 5 null

UI language preferred by the given user/contact

civicrm_line_item Table label VARCHAR 255 null

descriptive label for item - from price_field_value.label

civicrm_note Table id INT UNSIGNED 10 null

Note ID

civicrm_price_field_en_US View help_post TEXT 65535 null
civicrm_mailing Table forward_replies TINYINT 3 null

Should we forward replies back to the author?

civicrm_custom_group Table min_multiple INT UNSIGNED 10 null

minimum number of multiple records (typically 0?)

civicrm_timezone Table offset INT 10 null
civicrm_group_organization Table organization_id INT UNSIGNED 10 null

ID of the Organization Contact

civicrm_contribution_recur Table id INT UNSIGNED 10 null

Contribution Recur ID

civicrm_uf_field_en_US View id INT UNSIGNED 10 0

Unique table ID

civicrm_price_field_en_US View javascript VARCHAR 255 null

Optional scripting attributes for field

civicrm_campaign Table created_date DATETIME 19 null

Date and time that Campaign was created.

civicrm_uf_field Table help_post_fr_CA TEXT 65535 null
civicrm_address Table supplemental_address_1 VARCHAR 96 null

Supplemental Address Information, Line 1

civicrm_custom_field Table custom_group_id INT UNSIGNED 10 null

FK to civicrm_custom_group.

civicrm_action_log Table action_date_time DATETIME 19 null

date time that the action was performed on.

civicrm_pcp_block Table link_text_fr_CA VARCHAR 255 null
civicrm_option_value_en_US View is_default TINYINT 3 0

Is this the default option for the group?

civicrm_contribution_page_fr_CA View goal_amount DECIMAL 20 null

The target goal for this page, allows people to build a goal meter

civicrm_setting Table contact_id INT UNSIGNED 10 null

FK to Contact ID if the setting is localized to a contact

civicrm_menu Table breadcrumb TEXT 65535 null

Breadcrumb for the path.

civicrm_pledge_payment Table status_id INT UNSIGNED 10 null
civicrm_contribution Table total_amount DECIMAL 20 null

Total amount of this contribution. Use market value for non-monetary gifts.

civicrm_uf_field_fr_CA View field_type VARCHAR 255 null

This field saves field type (ie individual,household.. field etc).

civicrm_campaign Table id INT UNSIGNED 10 null

Unique Campaign ID.

civicrm_custom_field Table note_columns INT UNSIGNED 10 null

Number of columns in Note Field

civicrm_mailing Table body_html LONGTEXT 2147483647 null

Body of the mailing in html format.

civicrm_price_field_value_fr_CA View non_deductible_amount DECIMAL 20 0.00

Portion of total amount which is NOT tax deductible.

civicrm_custom_field Table note_rows INT UNSIGNED 10 null

Number of rows in Note Field

civicrm_job Table parameters TEXT 65535 null

List of parameters to the command.

civicrm_custom_field Table help_post_en_US TEXT 65535 null
civicrm_mail_settings Table localpart VARCHAR 255 null

optional local part (like civimail+ for addresses like civimail+s.1.2@example.com)

civicrm_menu Table path VARCHAR 255 null

Path Name

civicrm_contribution_page_en_US View pay_later_receipt TEXT 65535 null
civicrm_membership_type Table id INT UNSIGNED 10 null

Membership Id

civicrm_event_fr_CA View is_map TINYINT 3 0

Include a map block on the Event Information page when geocode info is available and a mapping provider has been specified?

civicrm_financial_type Table description VARCHAR 255 null

Financial Type Description.

civicrm_tell_friend_fr_CA View intro TEXT 65535 null
civicrm_contribution_page_fr_CA View default_amount_id INT UNSIGNED 10 null

FK to civicrm_option_value.

civicrm_pcp_block_en_US View entity_table VARCHAR 64 null
civicrm_contribution Table contribution_recur_id INT UNSIGNED 10 null

Conditional foreign key to civicrm_contribution_recur id. Each contribution made in connection with a recurring contribution carries a foreign key to the recurring contribution record. This assumes we can track these processor initiated events.

civicrm_prevnext_cache Table entity_id2 INT UNSIGNED 10 null

FK to entity table specified in entity_table column.

civicrm_membership_type_fr_CA View relationship_type_id VARCHAR 64 null

FK to Relationship Type ID

civicrm_contact_type_fr_CA View id INT UNSIGNED 10 0

Contact Type ID

civicrm_financial_account Table tax_rate DECIMAL 10 null

The percentage of the total_amount that is due for this tax.

civicrm_mailing_event_delivered Table event_queue_id INT UNSIGNED 10 null

FK to EventQueue

civicrm_group_en_US View name VARCHAR 64 null

Internal name of Group.

civicrm_tell_friend Table thankyou_text_en_US TEXT 65535 null
civicrm_contact Table image_URL TEXT 65535 null

optional URL for preferred image (photo, logo, etc.) to display for this contact.

civicrm_group_fr_CA View title VARCHAR 64 null
civicrm_contribution_page_en_US View receipt_text TEXT 65535 null
civicrm_contribution_page Table is_active TINYINT 3 null

Is this property active?

civicrm_custom_field_en_US View end_date_years INT 10 null

Date may be up to end_date_years years after the current date.

civicrm_contact Table do_not_sms TINYINT 3 0
civicrm_option_value_en_US View is_reserved TINYINT 3 0

Is this a predefined system object?

civicrm_contribution_page_fr_CA View pay_later_receipt TEXT 65535 null
civicrm_option_value_fr_CA View option_group_id INT UNSIGNED 10 null

Group which this option belongs to.

civicrm_pledge Table initial_reminder_day INT UNSIGNED 10 5

Send initial reminder this many days prior to the payment due date.

civicrm_im Table name VARCHAR 64 null

IM screen name

civicrm_custom_field_en_US View is_required TINYINT 3 null

Is a value required for this property.

civicrm_option_value Table name VARCHAR 255 null

Stores a fixed (non-translated) name for this option value. Lookup functions should use the name as the key for the option value row.

civicrm_payment_token Table contact_id INT UNSIGNED 10 null

FK to Contact ID for the owner of the token

civicrm_price_field_value_fr_CA View help_pre TEXT 65535 null

Price field option pre help text.

civicrm_contact Table birth_date DATE 10 null

Date of birth

civicrm_preferences_date Table description VARCHAR 255 null

Description of this date type.

civicrm_event_fr_CA View loc_block_id INT UNSIGNED 10 null

FK to Location Block ID

civicrm_membership_type Table fixed_period_rollover_day INT 10 null

For fixed period memberships, signups after this day (mmdd) rollover to next period.

civicrm_price_set_fr_CA View domain_id INT UNSIGNED 10 null

Which Domain is this price-set for

civicrm_price_field_fr_CA View expire_on DATETIME 19 null

If non-zero, do not show this field after the date specified

civicrm_subscription_history Table status VARCHAR 8 null

The state of the contact within the group

civicrm_membership_status_en_US View is_active TINYINT 3 1

Is this membership_status enabled.

civicrm_batch_fr_CA View status_id INT UNSIGNED 10 null

fk to Batch Status options in civicrm_option_values

civicrm_product_fr_CA View period_type VARCHAR 8 rolling

Rolling means we set start/end based on current day, fixed means we set start/end for current year or month (e.g. 1 year + fixed -> we would set start/end for 1/1/06 thru 12/31/06 for any premium chosen in 2006)

civicrm_price_set Table min_amount INT UNSIGNED 10 0

Minimum Amount required for this set.

civicrm_campaign_group Table id INT UNSIGNED 10 null

Campaign Group id.

civicrm_navigation Table name VARCHAR 255 null

Internal Name

civicrm_mailing Table from_email VARCHAR 128 null

From Email of mailing

civicrm_activity Table activity_date_time DATETIME 19 null

Date and time this activity is scheduled to occur. Formerly named scheduled_date_time.

civicrm_premiums_en_US View premiums_nothankyou_position INT UNSIGNED 10 1
civicrm_job_log Table description VARCHAR 255 null

Title line of log entry

civicrm_contact_type Table parent_id INT UNSIGNED 10 null

Optional FK to parent contact type.

civicrm_uf_group_en_US View help_post TEXT 65535 null
civicrm_event Table is_public TINYINT 3 1

Public events will be included in the iCal feeds. Access to private event information may be limited using ACLs.

civicrm_custom_group_en_US View help_pre TEXT 65535 null
civicrm_acl_entity_role Table acl_role_id INT UNSIGNED 10 null

Foreign Key to ACL Role (which is an option value pair and hence an implicit FK)

civicrm_dashboard Table cache_minutes INT UNSIGNED 10 60

Number of minutes to cache dashlet content in browser localStorage.

civicrm_membership_type_fr_CA View is_active TINYINT 3 1

Is this membership_type enabled

civicrm_membership_type_en_US View financial_type_id INT UNSIGNED 10 null

If membership is paid by a contribution - what financial type should be used. FK to civicrm_financial_type.id

civicrm_persistent Table name VARCHAR 255 null

Name of Context

civicrm_tell_friend Table intro_fr_CA TEXT 65535 null
civicrm_group Table children TEXT 65535 null

IDs of the child(ren)

civicrm_mailing_event_queue Table contact_id INT UNSIGNED 10 null

FK to Contact

civicrm_contribution_recur Table auto_renew TINYINT 3 0

Some systems allow contributor to set a number of installments - but then auto-renew the subscription or commitment if they do not cancel.

civicrm_contribution_page_fr_CA View start_date DATETIME 19 null

Date and time that this page starts.

civicrm_custom_field Table is_view TINYINT 3 null

Is this property set by PHP Code? A code field is viewable but not editable

civicrm_survey Table release_frequency INT UNSIGNED 10 null

Number of days for recurrence of release.

civicrm_survey_en_US View last_modified_id INT UNSIGNED 10 null

FK to civicrm_contact, who recently edited this Survey.

civicrm_tag Table id INT UNSIGNED 10 null

Tag ID

civicrm_case Table end_date DATE 10 null

Date on which given case ends.

civicrm_event Table default_fee_id INT UNSIGNED 10 null

FK to civicrm_option_value.

civicrm_action_log Table repetition_number INT UNSIGNED 10 null

Keeps track of the sequence number of this repetition.

civicrm_batch Table saved_search_id INT UNSIGNED 10 null

FK to Saved Search ID

civicrm_group_contact_cache Table id INT UNSIGNED 10 null

primary key

civicrm_pledge_block Table is_pledge_interval TINYINT 3 0

Is frequency interval exposed on the contribution form.

civicrm_event Table thankyou_title_fr_CA VARCHAR 255 null
civicrm_option_value_en_US View value VARCHAR 512 null

The actual value stored (as a foreign key) in the data record. Functions which need lookup option_value.title should use civicrm_option_value.option_group_id plus civicrm_option_value.value as the key.

civicrm_event_fr_CA View waitlist_text TEXT 65535 null
civicrm_status_pref Table name VARCHAR 255 null

Name of the status check this preference references.

civicrm_pcp Table is_thermometer INT UNSIGNED 10 0
civicrm_participant_status_type_en_US View name VARCHAR 64 null

non-localized name of the status type

civicrm_batch_fr_CA View title VARCHAR 255 null
civicrm_contact Table do_not_mail TINYINT 3 0
civicrm_mailing_event_bounce Table bounce_reason VARCHAR 255 null

The reason the email bounced.

civicrm_relationship_type Table label_b_a_fr_CA VARCHAR 64 null
civicrm_payment_processor Table is_active TINYINT 3 null

Is this processor active?

civicrm_price_field_value_en_US View max_value INT UNSIGNED 10 null

Max number of participants per field options

civicrm_persistent Table is_config TINYINT 3 0

Config Settings

civicrm_dashboard_fr_CA View permission_operator VARCHAR 3 null

Permission Operator

civicrm_grant Table amount_granted DECIMAL 20 null

Granted amount, in default currency.

civicrm_contribution_page_fr_CA View financial_type_id INT UNSIGNED 10 null

default financial type assigned to contributions submitted via this page, e.g. Contribution, Campaign Contribution

civicrm_uf_group_en_US View is_reserved TINYINT 3 null

Is this group reserved for use by some other CiviCRM functionality?

civicrm_contribution_soft Table pcp_id INT UNSIGNED 10 null

FK to civicrm_pcp.id

civicrm_event Table confirm_footer_text_fr_CA TEXT 65535 null
civicrm_event Table footer_text_en_US TEXT 65535 null
civicrm_financial_account Table name VARCHAR 255 null

Financial Account Name.

civicrm_membership_type Table duration_interval INT 10 null

Number of duration units in membership period (e.g. 1 year, 12 months).

civicrm_contribution_page_en_US View currency VARCHAR 3 null

3 character string, value from config setting or input via user.

civicrm_menu Table return_url VARCHAR 255 null

Url where a page should redirected to, if next url not known.

civicrm_custom_field_en_US View attributes VARCHAR 255 null

Store collection of type-appropriate attributes, e.g. textarea needs rows/cols attributes

civicrm_price_field_value_en_US View label VARCHAR 255 null
civicrm_case_type_fr_CA View title VARCHAR 64 null
civicrm_uf_field_fr_CA View visibility VARCHAR 32 User and User Admin Only

In what context(s) is this field visible.

civicrm_premiums_fr_CA View premiums_contact_email VARCHAR 100 null

This email address is included in receipts if it is populated and a premium has been selected.

civicrm_discount Table entity_id INT UNSIGNED 10 null

FK to entity table specified in entity_table column.

civicrm_address Table master_id INT UNSIGNED 10 null

FK to Address ID

civicrm_mailing_event_subscribe Table hash VARCHAR 255 null

Security hash

civicrm_mailing_group Table entity_id INT UNSIGNED 10 null

Foreign key to the referenced item.

civicrm_event_en_US View is_billing_required TINYINT 3 0

Billing block required for Event

civicrm_loc_block Table address_id INT UNSIGNED 10 null
civicrm_batch_fr_CA View id INT UNSIGNED 10 0

Unique Address ID

civicrm_participant_status_type_fr_CA View class VARCHAR 8 null

the general group of status type this one belongs to

civicrm_event_en_US View cc_confirm VARCHAR 255 null

comma-separated list of email addresses to cc each time a confirmation is sent

civicrm_contribution_page_fr_CA View is_monetary TINYINT 3 1

if true - allows real-time monetary transactions otherwise non-monetary transactions

civicrm_msg_template Table is_active TINYINT 3 1
civicrm_membership_status_en_US View id INT UNSIGNED 10 0

Membership Id

civicrm_contact Table external_identifier VARCHAR 64 null
civicrm_option_value_en_US View icon VARCHAR 255 null

crm-i icon class

civicrm_mailing_spool Table job_id INT UNSIGNED 10 null

The ID of the Job .

civicrm_membership_status Table is_current_member TINYINT 3 null

Does this status aggregate to current members (e.g. New, Renewed, Grace might all be TRUE... while Unrenewed, Lapsed, Inactive would be FALSE).

civicrm_premiums_product Table product_id INT UNSIGNED 10 null

Foreign key to each product object.

civicrm_membership_block Table membership_type_default INT UNSIGNED 10 null

Optional foreign key to membership_type

civicrm_case_type Table id INT UNSIGNED 10 null

Autoincremented type id

civicrm_uf_field Table is_required TINYINT 3 0

Is this field required when included in a user or registration form?

civicrm_contribution_page_en_US View id INT UNSIGNED 10 0

Contribution Id

civicrm_mapping_field Table relationship_direction VARCHAR 6 null
civicrm_mailing_job Table job_offset INT 10 0

Offset of the child job

civicrm_survey Table instructions_en_US TEXT 65535 null
civicrm_contact Table sort_name VARCHAR 128 null

Name used for sorting different contact types

civicrm_survey_en_US View is_share TINYINT 3 1

Can people share the petition through social media?

civicrm_job Table run_frequency VARCHAR 8 Daily

Scheduled job run frequency.

civicrm_payment_processor_type Table signature_label VARCHAR 255 null
civicrm_managed Table entity_id INT UNSIGNED 10 null

Foreign key to the referenced item.

civicrm_group_organization Table group_id INT UNSIGNED 10 null

ID of the group

civicrm_uf_field_en_US View location_type_id INT UNSIGNED 10 null

Location type of this mapping, if required

civicrm_product_en_US View min_contribution DECIMAL 20 null

Minimum contribution required to be eligible to select this premium.

civicrm_phone Table location_type_id INT UNSIGNED 10 null

Which Location does this phone belong to.

civicrm_uf_field Table website_type_id INT UNSIGNED 10 null

Website Type Id, if required

civicrm_uf_join Table module_data LONGTEXT 2147483647 null

Json serialized array of data used by the ufjoin.module

civicrm_option_value Table weight INT UNSIGNED 10 null

Controls display sort order.

civicrm_subscription_history Table date DATETIME 19 null

Date of the (un)subscription

civicrm_event_en_US View allow_selfcancelxfer TINYINT 3 0

Allow self service cancellation or transfer for event?

civicrm_event_fr_CA View id INT UNSIGNED 10 0

Event

civicrm_option_value_fr_CA View color VARCHAR 255 null

Hex color value e.g. #ffffff

civicrm_event Table parent_event_id INT UNSIGNED 10 null

Implicit FK to civicrm_event: parent event

civicrm_action_schedule Table title VARCHAR 64 null

Title of the action(reminder)

civicrm_contribution Table non_deductible_amount DECIMAL 20 0.00

Portion of total amount which is NOT tax deductible. Equal to total_amount for non-deductible financial types.

civicrm_contact Table legal_identifier VARCHAR 32 null

May be used for SSN, EIN/TIN, Household ID (census) or other applicable unique legal/government ID.

civicrm_group_contact Table location_id INT UNSIGNED 10 null

Optional location to associate with this membership

civicrm_report_instance Table navigation_id INT UNSIGNED 10 null

FK to navigation ID

civicrm_price_field_en_US View is_enter_qty TINYINT 3 0

Enter a quantity for this field?

civicrm_contribution_page_en_US View is_credit_card_only TINYINT 3 0

if true - processing logic must reject transaction at confirmation stage if pay method != credit card

civicrm_participant Table contact_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_grant Table amount_total DECIMAL 20 null

Requested grant amount, in default currency.

civicrm_mailing_abtest Table mailing_id_b INT UNSIGNED 10 null

The second experimental mailing ("B" condition)

civicrm_case Table start_date DATE 10 null

Date on which given case starts.

civicrm_membership Table is_test TINYINT 3 0
civicrm_product_fr_CA View min_contribution DECIMAL 20 null

Minimum contribution required to be eligible to select this premium.

civicrm_contribution_widget Table color_bar VARCHAR 10 null
civicrm_uf_group_fr_CA View group_type VARCHAR 255 null

This column will store a comma separated list of the type(s) of profile fields.

civicrm_currency Table id INT UNSIGNED 10 null

Currency Id

civicrm_entity_batch Table id INT UNSIGNED 10 null

primary key

civicrm_job_log Table domain_id INT UNSIGNED 10 null

Which Domain is this scheduled job for

civicrm_payment_processor_type Table class_name VARCHAR 255 null
civicrm_mailing_group Table search_id INT 10 null

The filtering search. custom search id or -1 for civicrm api search

civicrm_activity Table original_id INT UNSIGNED 10 null

Activity ID of the first activity record in versioning chain.

civicrm_product_en_US View period_type VARCHAR 8 rolling

Rolling means we set start/end based on current day, fixed means we set start/end for current year or month (e.g. 1 year + fixed -> we would set start/end for 1/1/06 thru 12/31/06 for any premium chosen in 2006)

civicrm_custom_field_en_US View note_columns INT UNSIGNED 10 null

Number of columns in Note Field

civicrm_uf_group Table is_proximity_search TINYINT 3 0

Should we include proximity search feature in this profile search form?

civicrm_uf_group_fr_CA View limit_listings_group_id INT UNSIGNED 10 null

Group id, foriegn key from civicrm_group

civicrm_contribution_page Table min_initial_amount DECIMAL 20 null

Minimum initial amount for partial payment

civicrm_price_field_value_en_US View price_field_id INT UNSIGNED 10 null

FK to civicrm_price_field

civicrm_pledge Table is_test TINYINT 3 0
civicrm_contribution_page_en_US View recur_frequency_unit VARCHAR 128 null

Supported recurring frequency units.

civicrm_report_instance Table owner_id INT UNSIGNED 10 null

FK to contact table.

civicrm_product Table fixed_period_start_day INT 10 101

Month and day (MMDD) that fixed period type subscription or membership starts.

civicrm_county Table id INT UNSIGNED 10 null

County ID

civicrm_campaign Table created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this Campaign.

civicrm_mailing_job Table status VARCHAR 12 null

The state of this job

civicrm_tell_friend Table suggested_message_fr_CA TEXT 65535 null
civicrm_dashboard_en_US View id INT UNSIGNED 10 0
civicrm_pcp_block Table target_entity_type VARCHAR 255 contribute

The type of entity that this pcp targets

civicrm_managed Table name VARCHAR 127 null

Symbolic name used by the module to identify the object

civicrm_product Table options_en_US TEXT 65535 null
civicrm_mailing_event_queue Table job_id INT UNSIGNED 10 null

FK to Job

civicrm_mailing Table auto_responder TINYINT 3 null

Should we enable the auto-responder?

civicrm_custom_field Table weight INT 10 1

Controls field display order within an extended property group.

civicrm_participant Table fee_currency VARCHAR 3 null

3 character string, value derived from config setting.

civicrm_mail_settings Table protocol VARCHAR 255 null

name of the protocol to use for polling (like IMAP, POP3 or Maildir)

civicrm_pcp_block_fr_CA View notify_email VARCHAR 255 null

If set, notification is automatically emailed to this email-address on create/update Personal Campaign Page

civicrm_financial_item Table status_id INT UNSIGNED 10 null

Payment status: test, paid, part_paid, unpaid (if empty assume unpaid)

civicrm_membership_type Table minimum_fee DECIMAL 18 0.000000000

Minimum fee for this membership (0 for free/complimentary memberships).

civicrm_mailing_event_opened Table event_queue_id INT UNSIGNED 10 null

FK to EventQueue

civicrm_location_type_en_US View is_active TINYINT 3 null

Is this property active?

civicrm_custom_field_fr_CA View date_format VARCHAR 64 null

date format for custom date

civicrm_tag Table is_reserved TINYINT 3 0
civicrm_dashboard_en_US View permission VARCHAR 255 null

Permission for the dashlet

civicrm_contribution_page_en_US View is_confirm_enabled TINYINT 3 1

if false, the confirm page in contribution pages gets skipped

civicrm_option_value Table color VARCHAR 255 null

Hex color value e.g. #ffffff

civicrm_survey_fr_CA View is_default TINYINT 3 0

Is this default survey?

civicrm_contribution_recur Table currency VARCHAR 3 null

3 character string, value from config setting or input via user.

civicrm_price_field_value_en_US View is_default TINYINT 3 0

Is this default price field option

civicrm_mailing Table approval_date DATETIME 19 null

Date and time this mailing was approved.

civicrm_membership_status_fr_CA View start_event VARCHAR 12 null

Event when this status starts.

civicrm_mailing_job Table id INT UNSIGNED 10 null
civicrm_word_replacement Table domain_id INT UNSIGNED 10 null

FK to Domain ID. This is for Domain specific word replacement

civicrm_participant_status_type Table weight INT UNSIGNED 10 null

controls sort order

civicrm_event_en_US View confirm_text TEXT 65535 null
civicrm_price_field_value_fr_CA View description TEXT 65535 null
civicrm_event_en_US View title VARCHAR 255 null
civicrm_menu Table is_ssl TINYINT 3 null

Should this menu be exposed via SSL if enabled?

civicrm_batch Table payment_instrument_id INT UNSIGNED 10 null

fk to Payment Instrument options in civicrm_option_values

civicrm_dashboard Table url VARCHAR 255 null

url in case of external dashlet

civicrm_contribution_recur Table campaign_id INT UNSIGNED 10 null

The campaign for which this contribution has been triggered.

civicrm_uf_field_fr_CA View is_view TINYINT 3 0

the field is view only and not editable in user forms.

civicrm_contact_type Table description_en_US TEXT 65535 null
civicrm_financial_account Table account_type_code VARCHAR 64 null

Optional value for mapping account types to accounting system account categories (QuickBooks Account Type Codes for example).

civicrm_pledge Table campaign_id INT UNSIGNED 10 null

The campaign for which this pledge has been initiated.

civicrm_grant Table status_id INT UNSIGNED 10 null

Id of Grant status.

civicrm_price_field Table options_per_line INT UNSIGNED 10 1

number of options per line for checkbox and radio

civicrm_price_field Table is_display_amounts TINYINT 3 1

Should the price be displayed next to the label for each option?

civicrm_contribution_page_fr_CA View title VARCHAR 255 null
civicrm_membership_block_fr_CA View entity_id INT UNSIGNED 10 null

FK to civicrm_contribution_page.id

civicrm_payment_token Table id INT UNSIGNED 10 null

Payment Token ID

civicrm_contribution_soft Table currency VARCHAR 3 null

3 character string, value from config setting or input via user.

civicrm_survey_en_US View thankyou_text TEXT 65535 null
civicrm_event Table selfcancelxfer_time INT UNSIGNED 10 0

Number of hours prior to event start date to allow self-service cancellation or transfer.

civicrm_event_en_US View waitlist_text TEXT 65535 null
civicrm_price_set_entity Table id INT UNSIGNED 10 null

Price Set Entity

civicrm_contact_type Table id INT UNSIGNED 10 null

Contact Type ID

civicrm_case_type_fr_CA View weight INT 10 1

Ordering of the case types

civicrm_contribution_page Table is_recur_installments TINYINT 3 0

if true - asks user for recurring installments

civicrm_relationship_type Table is_reserved TINYINT 3 null

Is this relationship type a predefined system type (can not be changed or de-activated)?

civicrm_mail_settings Table domain VARCHAR 255 null

email address domain (the part after @)

civicrm_uf_group_fr_CA View name VARCHAR 64 null

Name of the UF group for directly addressing it in the codebase

civicrm_price_field Table weight INT 10 1

Order in which the fields should appear

civicrm_event Table registration_end_date DATETIME 19 null

Date and time that online registration ends.

civicrm_batch Table name VARCHAR 64 null

Variable name/programmatic handle for this batch.

civicrm_address Table street_type VARCHAR 8 null

St, Rd, Dr, etc.

civicrm_contribution_widget Table id INT UNSIGNED 10 null

Contribution Id

civicrm_event Table start_date DATETIME 19 null

Date and time that event starts.

civicrm_financial_item Table currency VARCHAR 3 null

Currency for the amount

civicrm_price_set_fr_CA View help_pre TEXT 65535 null
civicrm_product_en_US View image VARCHAR 255 null

Full or relative URL to uploaded image - fullsize.

civicrm_address Table supplemental_address_3 VARCHAR 96 null

Supplemental Address Information, Line 3

civicrm_uf_group_en_US View is_update_dupe TINYINT 3 0

Should we update the contact record if we find a duplicate

civicrm_payment_processor_type Table user_name_label VARCHAR 255 null
civicrm_mailing Table campaign_id INT UNSIGNED 10 null

The campaign for which this mailing has been initiated.

civicrm_log Table modified_date DATETIME 19 null

When was the referenced entity created or modified or deleted.

civicrm_relationship_type_fr_CA View contact_type_b VARCHAR 12 null

If defined, contact_b in a relationship of this type must be a specific contact_type.

civicrm_custom_field Table options_per_line INT UNSIGNED 10 null

number of options per line for checkbox and radio

civicrm_survey_en_US View is_active TINYINT 3 1

Is this survey enabled or disabled/cancelled?

civicrm_membership_type_fr_CA View description VARCHAR 255 null
civicrm_event_fr_CA View pay_later_text TEXT 65535 null
civicrm_survey Table is_active TINYINT 3 1

Is this survey enabled or disabled/cancelled?

civicrm_contact_type_fr_CA View image_URL VARCHAR 255 null

URL of image if any.

civicrm_job_log Table id INT UNSIGNED 10 null

Job log entry Id

civicrm_persistent Table context VARCHAR 255 null

Context for which name data pair is to be stored

civicrm_batch Table title_en_US VARCHAR 255 null
civicrm_address Table id INT UNSIGNED 10 null

Unique Address ID

civicrm_case_type_en_US View is_active TINYINT 3 null

Is this entry active?

civicrm_membership_type_fr_CA View financial_type_id INT UNSIGNED 10 null

If membership is paid by a contribution - what financial type should be used. FK to civicrm_financial_type.id

civicrm_mailing Table scheduled_date DATETIME 19 null

Date and time this mailing was scheduled.

civicrm_survey_fr_CA View bypass_confirm TINYINT 3 0

Bypass the email verification.

civicrm_contribution_page_fr_CA View is_share TINYINT 3 1

Can people share the contribution page through social media?

civicrm_financial_account Table description VARCHAR 255 null

Financial Type Description.

civicrm_price_field_fr_CA View javascript VARCHAR 255 null

Optional scripting attributes for field

civicrm_price_field_value_fr_CA View membership_num_terms INT UNSIGNED 10 null

Number of terms for this membership

civicrm_custom_field_en_US View options_per_line INT UNSIGNED 10 null

number of options per line for checkbox and radio

civicrm_report_instance Table grouprole VARCHAR 1024 null

role required to be able to run this instance

civicrm_product Table description_fr_CA TEXT 65535 null
civicrm_price_set_en_US View is_reserved TINYINT 3 0

Is this a predefined system price set (i.e. it can not be deleted, edited)?

civicrm_price_set_fr_CA View javascript VARCHAR 64 null

Optional Javascript script function(s) included on the form with this price_set. Can be used for conditional

civicrm_payment_processor Table user_name VARCHAR 255 null
civicrm_price_field_en_US View name VARCHAR 255 null

Variable name/programmatic handle for this field.

civicrm_financial_account Table parent_id INT UNSIGNED 10 null

Parent ID in account hierarchy

civicrm_payment_processor Table accepted_credit_cards TEXT 65535 null

array of accepted credit card types

civicrm_event Table financial_type_id INT UNSIGNED 10 null

Financial type assigned to paid event registrations for this event. Required if is_monetary is true.

civicrm_dashboard_contact Table id INT UNSIGNED 10 null
civicrm_log Table modified_id INT UNSIGNED 10 null

FK to Contact ID of person under whose credentials this data modification was made.

civicrm_membership_status_en_US View end_event_adjust_interval INT 10 null

Status range ends this many units from end_event.

civicrm_contact Table postal_greeting_id INT UNSIGNED 10 null

FK to civicrm_option_value.id, that has to be valid registered Postal Greeting.

civicrm_event Table footer_text_fr_CA TEXT 65535 null
civicrm_batch Table modified_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_relationship Table start_date DATE 10 null

date when the relationship started

civicrm_option_value Table id INT UNSIGNED 10 null

Option ID

civicrm_activity Table created_date TIMESTAMP 19 null

When was the activity was created.

civicrm_dashboard Table domain_id INT UNSIGNED 10 null

Domain for dashboard

civicrm_custom_field_fr_CA View help_pre TEXT 65535 null
civicrm_openid Table contact_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_location_type Table id INT UNSIGNED 10 null

Location Type ID

civicrm_worldregion Table id INT UNSIGNED 10 null

Country Id

civicrm_group_en_US View is_active TINYINT 3 null

Is this entry active?

civicrm_membership_status Table is_active TINYINT 3 1

Is this membership_status enabled.

civicrm_contribution_page_fr_CA View currency VARCHAR 3 null

3 character string, value from config setting or input via user.

civicrm_membership_type_en_US View visibility VARCHAR 64 null
civicrm_membership_block_en_US View is_separate_payment TINYINT 3 1

Should membership transactions be processed separately

civicrm_membership_type Table max_related INT 10 null

Maximum number of related memberships.

civicrm_membership_status_fr_CA View start_event_adjust_interval INT 10 null

Status range begins this many units from start_event.

civicrm_case_type Table description_en_US VARCHAR 255 null
civicrm_location_type_fr_CA View display_name VARCHAR 64 null
civicrm_tell_friend Table is_active TINYINT 3 null
civicrm_line_item Table contribution_id INT UNSIGNED 10 null

FK to civicrm_contribution

civicrm_uf_field Table field_type VARCHAR 255 null

This field saves field type (ie individual,household.. field etc).

civicrm_event_fr_CA View confirm_email_text TEXT 65535 null
civicrm_product_en_US View cost DECIMAL 20 null

Actual cost of this product. Useful to determine net return from sale or using this as an incentive.

civicrm_premiums Table premiums_intro_title_en_US VARCHAR 255 null
civicrm_job Table description VARCHAR 255 null

Description of the job

civicrm_custom_group_en_US View extends_entity_column_id INT UNSIGNED 10 null

FK to civicrm_option_value.id (for option group custom_data_type.)

civicrm_contribution_recur Table payment_processor_id INT UNSIGNED 10 null

Foreign key to civicrm_payment_processor.id

civicrm_mailing_abtest Table mailing_id_a INT UNSIGNED 10 null

The first experimental mailing ("A" condition)

civicrm_event_en_US View participant_listing_id INT UNSIGNED 10 0

Should we expose the participant list? Implicit FK to civicrm_option_value where option_group = participant_listing.

civicrm_pcp_block_en_US View target_entity_id INT UNSIGNED 10 null

The entity that this pcp targets

civicrm_membership_block Table entity_table VARCHAR 64 null

Name for Membership Status

civicrm_membership_type Table receipt_text_signup VARCHAR 255 null

Receipt Text for membership signup

civicrm_custom_group_fr_CA View style VARCHAR 15 null

Visual relationship between this form and its parent.

civicrm_custom_group Table extends VARCHAR 255 Contact

Type of object this group extends (can add other options later e.g. contact_address, etc.).

civicrm_survey_fr_CA View recontact_interval TEXT 65535 null

Recontact intervals for each status.

civicrm_im Table is_billing TINYINT 3 0

Is this the billing?

civicrm_price_field Table is_active TINYINT 3 1

Is this price field active

civicrm_contribution_widget Table color_about_link VARCHAR 10 null
civicrm_event_fr_CA View title VARCHAR 255 null
civicrm_price_field Table is_enter_qty TINYINT 3 0

Enter a quantity for this field?

civicrm_payment_processor_type Table subject_label VARCHAR 255 null
civicrm_entity_financial_trxn Table amount DECIMAL 20 null

allocated amount of transaction to this entity

civicrm_contribution_recur Table contact_id INT UNSIGNED 10 null

Foreign key to civicrm_contact.id .

civicrm_managed Table id INT UNSIGNED 10 null

Surrogate Key

civicrm_membership_type_fr_CA View max_related INT 10 null

Maximum number of related memberships.

civicrm_custom_field Table name VARCHAR 64 null

Variable name/programmatic handle for this group.

civicrm_group_organization Table id INT UNSIGNED 10 null

Relationship ID

civicrm_activity Table is_current_revision TINYINT 3 1
civicrm_location_type_fr_CA View is_reserved TINYINT 3 null

Is this location type a predefined system location?

civicrm_uf_group_en_US View notify TEXT 65535 null
civicrm_case_type_fr_CA View is_active TINYINT 3 null

Is this entry active?

civicrm_case_type Table definition BLOB 65535 null

xml definition of case type

civicrm_contribution_product Table comment TEXT 65535 null
civicrm_membership Table contact_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_participant_status_type_fr_CA View is_active TINYINT 3 1

whether this status type is active

civicrm_mail_settings Table port INT UNSIGNED 10 null

port to use when polling

civicrm_survey Table id INT UNSIGNED 10 null

Survey id.

civicrm_event_en_US View slot_label_id INT UNSIGNED 10 null

Subevent slot label. Implicit FK to civicrm_option_value where option_group = conference_slot.

civicrm_custom_group Table title_en_US VARCHAR 64 null
civicrm_membership_type_en_US View fixed_period_start_day INT 10 null

For fixed period memberships, month and day (mmdd) on which subscription/membership will start. Period start is back-dated unless after rollover day.

civicrm_relationship_type_fr_CA View name_b_a VARCHAR 64 null

Optional name for relationship of contact_b to contact_a.

civicrm_option_group Table title_fr_CA VARCHAR 255 null
civicrm_report_instance Table name VARCHAR 255 null

when combined with report_id/template uniquely identifies the instance

civicrm_contact Table primary_contact_id INT UNSIGNED 10 null

Optional FK to Primary Contact for this household.

civicrm_line_item Table id INT UNSIGNED 10 null

Line Item

civicrm_contact Table postal_greeting_custom VARCHAR 128 null

Custom Postal greeting.

civicrm_contribution_page_en_US View min_amount DECIMAL 20 null

if other amounts allowed, user can configure minimum allowed.

civicrm_mailing Table unsubscribe_id INT UNSIGNED 10 null

FK to the unsubscribe component.

civicrm_membership_type_fr_CA View auto_renew TINYINT 3 0

0 = No auto-renew option; 1 = Give option, but not required; 2 = Auto-renew required;

civicrm_contribution_page_fr_CA View created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this contribution page

civicrm_event Table slot_label_id INT UNSIGNED 10 null

Subevent slot label. Implicit FK to civicrm_option_value where option_group = conference_slot.

civicrm_case Table subject VARCHAR 128 null

Short name of the case.

civicrm_batch Table item_count INT UNSIGNED 10 null

Number of items in a batch.

civicrm_custom_group Table table_name VARCHAR 255 null

Name of the table that holds the values for this group.

civicrm_event Table initial_amount_help_text_en_US TEXT 65535 null
civicrm_membership_status_en_US View label VARCHAR 128 null
civicrm_membership_block Table id INT UNSIGNED 10 null

Membership Id

civicrm_participant_status_type_en_US View weight INT UNSIGNED 10 null

controls sort order

civicrm_survey Table activity_type_id INT UNSIGNED 10 null

Implicit FK to civicrm_option_value where option_group = activity_type

civicrm_product Table description_en_US TEXT 65535 null
civicrm_custom_group_en_US View id INT UNSIGNED 10 0

Unique Custom Group ID

civicrm_price_set_en_US View is_active TINYINT 3 1

Is this price set active

civicrm_premiums_product Table premiums_id INT UNSIGNED 10 null

Foreign key to premiums settings record.

civicrm_uf_group_en_US View title VARCHAR 64 null
civicrm_recurring_entity Table mode TINYINT 3 1

1-this entity, 2-this and the following entities, 3-all the entities

civicrm_option_group_fr_CA View title VARCHAR 255 null
civicrm_dashboard_en_US View label VARCHAR 255 null
civicrm_membership_type_en_US View receipt_text_signup VARCHAR 255 null

Receipt Text for membership signup

civicrm_mailing_abtest Table id INT UNSIGNED 10 null
civicrm_contribution_page Table campaign_id INT UNSIGNED 10 null

The campaign for which we are collecting contributions with this page.

civicrm_mailing Table email_selection_method VARCHAR 20 automatic

With location_type_id, determine how to choose the email address to use.

civicrm_payment_processor_type Table url_site_default VARCHAR 255 null
civicrm_pcp Table contact_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_mailing_component Table body_html TEXT 65535 null

Body of the component in html format.

civicrm_pcp_block_fr_CA View tellfriend_limit INT UNSIGNED 10 null

Maximum recipient fields allowed in tell a friend

civicrm_mailing_recipients Table phone_id INT UNSIGNED 10 null

FK to Phone

civicrm_mailing Table url_tracking TINYINT 3 null

Should we track URL click-throughs for this mailing?

civicrm_loc_block Table address_2_id INT UNSIGNED 10 null
civicrm_uf_group Table limit_listings_group_id INT UNSIGNED 10 null

Group id, foriegn key from civicrm_group

civicrm_mailing Table body_text LONGTEXT 2147483647 null

Body of the mailing in text format.

civicrm_membership_block_en_US View new_title VARCHAR 255 null
civicrm_mapping_field Table operator VARCHAR 16 null

SQL WHERE operator for search-builder mapping fields (search criteria).

civicrm_event Table max_additional_participants INT UNSIGNED 10 0

Maximum number of additional participants that can be registered on a single booking

civicrm_event_en_US View dedupe_rule_group_id INT UNSIGNED 10 null

Rule to use when matching registrations for this event

civicrm_event Table registration_start_date DATETIME 19 null

Date and time that online registration starts.

civicrm_option_group_fr_CA View data_type VARCHAR 128 null

Data Type of Option Group.

civicrm_saved_search Table id INT UNSIGNED 10 null

Saved search ID

civicrm_extension Table type VARCHAR 8 null
civicrm_contact Table addressee_display VARCHAR 255 null

Cache Addressee.

civicrm_menu Table return_url_args VARCHAR 255 null

Arguments to pass to return_url

civicrm_tag Table is_selectable TINYINT 3 1

Is this tag selectable / displayed

civicrm_contribution Table trxn_id VARCHAR 255 null

unique transaction id. may be processor id, bank id + trans id, or account number + check number... depending on payment_method

civicrm_membership_status Table end_event_adjust_interval INT 10 null

Status range ends this many units from end_event.

civicrm_option_value Table icon VARCHAR 255 null

crm-i icon class

civicrm_option_value Table visibility_id INT UNSIGNED 10 null
civicrm_event Table is_monetary TINYINT 3 0

If true, one or more fee amounts must be set and a Payment Processor must be configured for Online Event Registration.

civicrm_membership_block_en_US View entity_id INT UNSIGNED 10 null

FK to civicrm_contribution_page.id

civicrm_contribution_widget Table color_main_text VARCHAR 10 null
civicrm_contact Table do_not_email TINYINT 3 0
civicrm_membership_block_fr_CA View is_active TINYINT 3 1

Is this membership_block enabled

civicrm_survey_fr_CA View instructions TEXT 65535 null
civicrm_relationship_type_en_US View is_reserved TINYINT 3 null

Is this relationship type a predefined system type (can not be changed or de-activated)?

civicrm_mailing_event_subscribe Table time_stamp DATETIME 19 null

When this subscription event occurred.

civicrm_uf_group Table add_to_group_id INT UNSIGNED 10 null

foreign key to civicrm_group_id

civicrm_product_en_US View is_active TINYINT 3 null

Disabling premium removes it from the premiums_premium join table below.

civicrm_action_log Table message TEXT 65535 null

Description / text in case there was an error encountered.

civicrm_address Table location_type_id INT UNSIGNED 10 null

Which Location does this address belong to.

civicrm_membership_type_en_US View period_type VARCHAR 8 null

Rolling membership period starts on signup date. Fixed membership periods start on fixed_period_start_day.

civicrm_action_schedule Table sms_body_text LONGTEXT 2147483647 null

Body of the mailing in html format.

civicrm_activity Table subject VARCHAR 255 null

The subject/purpose/short description of the activity.

civicrm_uf_group Table notify TEXT 65535 null
civicrm_line_item Table price_field_value_id INT UNSIGNED 10 null

FK to civicrm_price_field_value

civicrm_contact_type_fr_CA View parent_id INT UNSIGNED 10 null

Optional FK to parent contact type.

civicrm_mailing Table template_options LONGTEXT 2147483647 null

Advanced options used by the email templating system. (JSON encoded)

civicrm_menu Table access_arguments TEXT 65535 null

Arguments to pass to access callback

civicrm_price_field_fr_CA View is_required TINYINT 3 1

Is this price field required (value must be > 1)

civicrm_setting Table created_date DATETIME 19 null

When was the setting created

civicrm_event Table is_pay_later TINYINT 3 0

if true - allows the user to send payment directly to the org later

civicrm_acl_contact_cache Table contact_id INT UNSIGNED 10 null

FK to civicrm_contact

civicrm_price_field_value_fr_CA View max_value INT UNSIGNED 10 null

Max number of participants per field options

civicrm_custom_field_en_US View text_length INT UNSIGNED 10 null

field length if alphanumeric

civicrm_custom_field_en_US View is_active TINYINT 3 null

Is this property active?

civicrm_event Table registration_link_text_en_US VARCHAR 255 null
civicrm_job_log Table run_time TIMESTAMP 19 CURRENT_TIMESTAMP

Log entry date

civicrm_relationship_type_fr_CA View contact_sub_type_b VARCHAR 64 null

If defined, contact_sub_type_b in a relationship of this type must be a specific contact_sub_type.

civicrm_product_fr_CA View currency VARCHAR 3 null

3 character string, value from config setting or input via user.

civicrm_custom_field_fr_CA View javascript VARCHAR 255 null

Optional scripting attributes for field.

civicrm_domain Table name VARCHAR 64 null

Name of Domain / Organization

civicrm_batch Table created_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_custom_field_fr_CA View name VARCHAR 64 null

Variable name/programmatic handle for this group.

civicrm_extension Table schema_version VARCHAR 63 null

Revision code of the database schema; the format is module-defined

civicrm_action_schedule Table sms_provider_id INT UNSIGNED 10 null
civicrm_tell_friend_en_US View thankyou_title VARCHAR 255 null
civicrm_price_set_en_US View title VARCHAR 255 null
civicrm_acl_cache Table acl_id INT UNSIGNED 10 null

Foreign Key to ACL

civicrm_membership_type Table is_active TINYINT 3 1

Is this membership_type enabled

civicrm_payment_processor_type Table is_default TINYINT 3 null

Is this processor the default?

civicrm_option_group_fr_CA View is_locked TINYINT 3 null

A lock to remove the ability to add new options via the UI.

civicrm_location_type_en_US View description VARCHAR 255 null

Location Type Description.

civicrm_option_group_en_US View is_active TINYINT 3 null

Is this option group active?

civicrm_price_set_en_US View id INT UNSIGNED 10 0

Price Set

civicrm_acl Table acl_table VARCHAR 64 null

If this is a grant/revoke entry, what table are we granting?

civicrm_membership_status_en_US View name VARCHAR 128 null

Name for Membership Status

civicrm_address_format Table format TEXT 65535 null

The format of an address

civicrm_action_schedule Table body_text LONGTEXT 2147483647 null

Body of the mailing in text format.

civicrm_financial_item Table transaction_date DATETIME 19 null

Date and time of the source transaction

civicrm_contribution_page_en_US View receipt_from_name VARCHAR 255 null
civicrm_price_field_value_en_US View help_post TEXT 65535 null

Price field option post help text.

civicrm_case_type_fr_CA View is_reserved TINYINT 3 null

Is this case type a predefined system type?

civicrm_event_en_US View is_partial_payment TINYINT 3 0

is partial payment enabled for this event

civicrm_participant_status_type_en_US View is_reserved TINYINT 3 null

whether this is a status type required by the system

civicrm_address Table street_number INT 10 null

Numeric portion of address number on the street, e.g. For 112A Main St, the street_number = 112.

civicrm_payment_processor Table url_button VARCHAR 255 null
civicrm_product_fr_CA View duration_interval INT 10 null

Number of units for total duration of subscription, service, membership (e.g. 12 Months).

civicrm_relationship_type_en_US View name_b_a VARCHAR 64 null

Optional name for relationship of contact_b to contact_a.

civicrm_custom_group_en_US View style VARCHAR 15 null

Visual relationship between this form and its parent.

civicrm_survey Table is_share TINYINT 3 1

Can people share the petition through social media?

civicrm_contact Table first_name VARCHAR 64 null

First Name.

civicrm_contribution_recur Table failure_retry_date DATETIME 19 null

Date to retry failed attempt

civicrm_tell_friend_en_US View suggested_message TEXT 65535 null
civicrm_mail_settings Table is_default TINYINT 3 null

whether this is the default set of settings for this domain

civicrm_price_field Table label_en_US VARCHAR 255 null
civicrm_group_fr_CA View description TEXT 65535 null

Optional verbose description of the group.

civicrm_payment_processor_type Table is_recur TINYINT 3 null

Can process recurring contributions

civicrm_survey_fr_CA View result_id INT UNSIGNED 10 null

Used to store option group id.

civicrm_membership Table contribution_recur_id INT UNSIGNED 10 null

Conditional foreign key to civicrm_contribution_recur id. Each membership in connection with a recurring contribution carries a foreign key to the recurring contribution record. This assumes we can track these processor initiated events.

civicrm_custom_field Table help_post_fr_CA TEXT 65535 null
civicrm_currency Table numeric_code VARCHAR 3 null

Numeric currency code

civicrm_mailing_component Table is_default TINYINT 3 0

Is this the default component for this component_type?

civicrm_managed Table entity_type VARCHAR 64 null

API entity type

civicrm_event_en_US View confirm_from_email VARCHAR 255 null

FROM email address used for confirmation emails.

civicrm_uf_group_en_US View add_captcha TINYINT 3 0

Should a CAPTCHA widget be included this Profile form.

civicrm_event Table confirm_email_text_en_US TEXT 65535 null
civicrm_contact Table household_name VARCHAR 128 null

Household Name.

civicrm_report_instance Table is_reserved TINYINT 3 0
civicrm_option_group_en_US View id INT UNSIGNED 10 0

Option Group ID

civicrm_contribution_page Table amount_block_is_active TINYINT 3 1

Is this property active?

civicrm_mailing_event_queue Table id INT UNSIGNED 10 null
civicrm_pledge Table frequency_day INT UNSIGNED 10 3

Day in the period when the pledge payment is due e.g. 1st of month, 15th etc. Use this to set the scheduled dates for pledge payments.

civicrm_custom_field_fr_CA View attributes VARCHAR 255 null

Store collection of type-appropriate attributes, e.g. textarea needs rows/cols attributes

civicrm_uf_field_fr_CA View weight INT 10 1

Controls field display order when user framework fields are displayed in registration and account editing forms.

civicrm_product_en_US View currency VARCHAR 3 null

3 character string, value from config setting or input via user.

civicrm_im Table location_type_id INT UNSIGNED 10 null

Which Location does this email belong to.

civicrm_custom_group_en_US View min_multiple INT UNSIGNED 10 null

minimum number of multiple records (typically 0?)

civicrm_product Table name_fr_CA VARCHAR 255 null
civicrm_address Table street_name VARCHAR 64 null

Actual street name, excluding St, Dr, Rd, Ave, e.g. For 112 Main St, the street_name = Main.

civicrm_case_type_fr_CA View description VARCHAR 255 null
civicrm_custom_group_fr_CA View help_post TEXT 65535 null
civicrm_pcp_block Table supporter_profile_id INT UNSIGNED 10 null

FK to civicrm_uf_group.id. Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?

civicrm_uf_group Table id INT UNSIGNED 10 null

Unique table ID

civicrm_price_set Table is_active TINYINT 3 1

Is this price set active

civicrm_mailing_group Table search_args TEXT 65535 null

The arguments to be sent to the search function

civicrm_mailing Table location_type_id INT UNSIGNED 10 null

With email_selection_method, determines which email address to use

civicrm_job Table id INT UNSIGNED 10 null

Job Id

civicrm_custom_field_en_US View label VARCHAR 255 null
civicrm_pledge_block Table entity_table VARCHAR 64 null

physical tablename for entity being joined to pledge, e.g. civicrm_contact

civicrm_uf_field_en_US View is_multi_summary TINYINT 3 0

Include in multi-record listing?

civicrm_contact Table api_key VARCHAR 32 null

API Key for validating requests related to this contact.

civicrm_event Table confirm_from_name_fr_CA VARCHAR 255 null
civicrm_print_label Table label_format_name VARCHAR 255 null

This refers to name column of civicrm_option_value row in name_badge option group

civicrm_membership_status_fr_CA View start_event_adjust_unit VARCHAR 8 null

Unit used for adjusting from start_event.

civicrm_word_replacement Table find_word VARCHAR 255 null

Word which need to be replaced

civicrm_survey_fr_CA View activity_type_id INT UNSIGNED 10 null

Implicit FK to civicrm_option_value where option_group = activity_type

civicrm_payment_processor Table url_site VARCHAR 255 null
civicrm_contact_type_en_US View is_reserved TINYINT 3 null

Is this contact type a predefined system type

civicrm_address Table contact_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_acl Table name VARCHAR 64 null

ACL Name.

civicrm_participant_status_type_en_US View id INT UNSIGNED 10 0

unique participant status type id

civicrm_group_fr_CA View cache_date TIMESTAMP 19 null
civicrm_uf_group_fr_CA View cancel_URL VARCHAR 255 null

Redirect to URL when Cancle button clik .

civicrm_pledge Table max_reminders INT UNSIGNED 10 1

The maximum number of payment reminders to send for any given payment.

civicrm_uf_group Table created_date DATETIME 19 null

Date and time this UF group was created.

civicrm_action_mapping Table entity_status VARCHAR 64 null

Entity status

civicrm_custom_group_fr_CA View is_active TINYINT 3 null

Is this property active?

civicrm_premiums_fr_CA View premiums_intro_title VARCHAR 255 null
civicrm_queue_item Table queue_name VARCHAR 64 null

Name of the queue which includes this item

civicrm_contribution_page_fr_CA View id INT UNSIGNED 10 0

Contribution Id

civicrm_custom_group Table extends_entity_column_id INT UNSIGNED 10 null

FK to civicrm_option_value.id (for option group custom_data_type.)

civicrm_event Table event_type_id INT UNSIGNED 10 0

Event Type ID.Implicit FK to civicrm_option_value where option_group = event_type.

civicrm_action_schedule Table used_for VARCHAR 64 null

Used for repeating entity

civicrm_relationship_type_en_US View id INT UNSIGNED 10 0

Primary key

civicrm_report_instance Table domain_id INT UNSIGNED 10 null

Which Domain is this instance for

civicrm_contribution_page_fr_CA View is_email_receipt TINYINT 3 0

if true, receipt is automatically emailed to contact on success

civicrm_financial_trxn Table id INT UNSIGNED 10 null
civicrm_custom_group_en_US View name VARCHAR 64 null

Variable name/programmatic handle for this group.

civicrm_membership_status Table start_event_adjust_unit VARCHAR 8 null

Unit used for adjusting from start_event.

civicrm_contribution_product Table fulfilled_date DATE 10 null

Optional. Can be used to record the date this product was fulfilled or shipped.

civicrm_membership_type_en_US View is_active TINYINT 3 1

Is this membership_type enabled

civicrm_activity_contact Table activity_id INT UNSIGNED 10 null

Foreign key to the activity for this record.

civicrm_option_value Table is_reserved TINYINT 3 0

Is this a predefined system object?

civicrm_event_en_US View intro_text TEXT 65535 null
civicrm_event Table waitlist_text_en_US TEXT 65535 null
civicrm_contribution Table net_amount DECIMAL 20 null

actual funds transfer amount. total less fees. if processor does not report actual fee during transaction, this is set to total_amount.

civicrm_contact_type_fr_CA View description TEXT 65535 null
civicrm_event_carts Table completed TINYINT 3 0
civicrm_mail_settings Table return_path VARCHAR 255 null

contents of the Return-Path header

civicrm_address Table country_id INT UNSIGNED 10 null

Which Country does this address belong to.

civicrm_state_province Table name VARCHAR 64 null

Name of State/Province

civicrm_group_fr_CA View refresh_date TIMESTAMP 19 null
civicrm_prevnext_cache Table data LONGTEXT 2147483647 null

cached snapshot of the serialized data

civicrm_price_set Table title_fr_CA VARCHAR 255 null
civicrm_contribution_widget Table color_main_bg VARCHAR 10 null
civicrm_uf_group_fr_CA View help_pre TEXT 65535 null
civicrm_mailing Table optout_id INT UNSIGNED 10 null

FK to the opt-out component.

civicrm_event Table pay_later_receipt_en_US TEXT 65535 null
civicrm_line_item Table financial_type_id INT UNSIGNED 10 null

FK to Financial Type.

civicrm_phone Table phone VARCHAR 32 null

Complete phone number.

civicrm_mailing_event_bounce Table time_stamp DATETIME 19 null

When this bounce event occurred.

civicrm_price_field_value_fr_CA View financial_type_id INT UNSIGNED 10 null

FK to Financial Type.

civicrm_premiums_en_US View premiums_nothankyou_label VARCHAR 255 null
civicrm_survey_en_US View default_number_of_contacts INT UNSIGNED 10 null

Default number of contacts to allow for survey.

civicrm_product_en_US View description TEXT 65535 null
civicrm_file Table document MEDIUMBLOB 16777215 null

contents of the document

civicrm_saved_search Table where_clause TEXT 65535 null

the sql where clause if a saved search acl

civicrm_pcp_block Table is_active TINYINT 3 1

Is Personal Campaign Page Block enabled/active?

civicrm_participant_status_type_en_US View label VARCHAR 255 null
civicrm_financial_item Table entity_table VARCHAR 64 null

The table providing the source of this item such as civicrm_line_item

civicrm_premiums_fr_CA View premiums_display_min_contribution TINYINT 3 null

Boolean. Should we automatically display minimum contribution amount text after the premium descriptions.

civicrm_custom_group_en_US View collapse_adv_display INT UNSIGNED 10 0

Will this group be in collapsed or expanded mode on advanced search display ?

civicrm_uf_field_fr_CA View is_multi_summary TINYINT 3 0

Include in multi-record listing?

civicrm_contribution_page_fr_CA View thankyou_footer TEXT 65535 null
civicrm_contribution_page_en_US View financial_type_id INT UNSIGNED 10 null

default financial type assigned to contributions submitted via this page, e.g. Contribution, Campaign Contribution

civicrm_participant_status_type Table is_reserved TINYINT 3 null

whether this is a status type required by the system

civicrm_pledge_payment Table contribution_id INT UNSIGNED 10 null

FK to contribution table.

civicrm_price_field_value_en_US View amount DECIMAL 18 null

Price field option amount

civicrm_price_field_value_en_US View weight INT 10 1

Order in which the field options should appear

civicrm_menu Table is_active TINYINT 3 null

Is this menu item active?

civicrm_activity Table duration INT UNSIGNED 10 null

Planned or actual duration of activity expressed in minutes. Conglomerate of former duration_hours and duration_minutes.

civicrm_membership_type Table description_en_US VARCHAR 255 null
civicrm_grant Table financial_type_id INT UNSIGNED 10 null

FK to Financial Type.

civicrm_pledge Table acknowledge_date DATETIME 19 null

When a pledge acknowledgement message was sent to the contributor.

civicrm_event_fr_CA View is_share TINYINT 3 1

Can people share the event through social media?

civicrm_membership_block_en_US View id INT UNSIGNED 10 0

Membership Id

civicrm_contact Table hash VARCHAR 32 null

Key for validating requests related to this contact.

civicrm_payment_processor Table password VARCHAR 255 null
civicrm_mailing_job Table end_date DATETIME 19 null

date on which this job ended.

civicrm_action_schedule Table start_action_condition VARCHAR 64 null

Reminder Action

civicrm_custom_group_fr_CA View is_public BIT 0 1

Is this property public?

civicrm_participant Table is_pay_later TINYINT 3 0
civicrm_product_fr_CA View is_active TINYINT 3 null

Disabling premium removes it from the premiums_premium join table below.

civicrm_action_mapping Table entity_date_end VARCHAR 64 null

Entity date

civicrm_line_item Table non_deductible_amount DECIMAL 20 0.00

Portion of total amount which is NOT tax deductible.

civicrm_uf_group_en_US View add_to_group_id INT UNSIGNED 10 null

foreign key to civicrm_group_id

civicrm_custom_field_en_US View default_value VARCHAR 255 null

Use form_options.is_default for field_types which use options.

civicrm_action_log Table entity_id INT UNSIGNED 10 null

FK to id of the entity that the action was performed on. Pseudo - FK.

civicrm_prevnext_cache Table is_selected TINYINT 3 0
civicrm_mailing_component Table subject VARCHAR 255 null
civicrm_membership_status_en_US View is_default TINYINT 3 null

Assign this status to a membership record if no other status match is found.

civicrm_event_en_US View is_map TINYINT 3 0

Include a map block on the Event Information page when geocode info is available and a mapping provider has been specified?

civicrm_queue_item Table data TEXT 65535 null

Serialized queue

civicrm_group_en_US View where_clause TEXT 65535 null

the sql where clause if a saved search acl

civicrm_activity Table parent_id INT UNSIGNED 10 null

Parent meeting ID (if this is a follow-up item). This is not currently implemented

civicrm_contribution_page_en_US View end_date DATETIME 19 null

Date and time that this page ends. May be NULL if no defined end date/time

civicrm_custom_field_fr_CA View default_value VARCHAR 255 null

Use form_options.is_default for field_types which use options.

civicrm_discount Table id INT UNSIGNED 10 null

primary key

civicrm_event Table is_email_confirm TINYINT 3 0

If true, confirmation is automatically emailed to contact on successful registration.

civicrm_event_en_US View max_additional_participants INT UNSIGNED 10 0

Maximum number of additional participants that can be registered on a single booking

civicrm_cxn Table perm TEXT 65535 null

Permissions approved for the service (JSON)

civicrm_currency Table full_name VARCHAR 64 null

Full currency name

civicrm_country Table idd_prefix VARCHAR 4 null

International direct dialing prefix from within the country TO another country

civicrm_event_fr_CA View participant_listing_id INT UNSIGNED 10 0

Should we expose the participant list? Implicit FK to civicrm_option_value where option_group = participant_listing.

civicrm_uf_join Table is_active TINYINT 3 1

Is this join currently active?

civicrm_activity Table phone_id INT UNSIGNED 10 null

Phone ID of the number called (optional - used if an existing phone number is selected).

civicrm_dedupe_exception Table contact_id2 INT UNSIGNED 10 null

FK to Contact ID

civicrm_mailing_bounce_type Table id INT UNSIGNED 10 null
civicrm_custom_group_en_US View help_post TEXT 65535 null
civicrm_tell_friend_en_US View general_link VARCHAR 255 null

URL for general info about the organization - included in the email sent to friends.

civicrm_location_type Table is_default TINYINT 3 null

Is this location type the default?

civicrm_loc_block Table phone_2_id INT UNSIGNED 10 null
civicrm_contribution_page_en_US View is_monetary TINYINT 3 1

if true - allows real-time monetary transactions otherwise non-monetary transactions

civicrm_financial_account Table id INT UNSIGNED 10 null

ID

civicrm_event Table confirm_title_fr_CA VARCHAR 255 null
civicrm_product_en_US View duration_interval INT 10 null

Number of units for total duration of subscription, service, membership (e.g. 12 Months).

civicrm_contribution_page_en_US View is_billing_required TINYINT 3 0

Billing block required for Contribution Page

civicrm_event Table registration_link_text_fr_CA VARCHAR 255 null
civicrm_sms_provider Table domain_id INT UNSIGNED 10 null

Which Domain is this sms provier for

civicrm_price_field Table id INT UNSIGNED 10 null

Price Field

civicrm_premiums_product Table financial_type_id INT UNSIGNED 10 null

FK to Financial Type.

civicrm_relationship_type Table contact_type_a VARCHAR 12 null

If defined, contact_a in a relationship of this type must be a specific contact_type.

civicrm_premiums_fr_CA View premiums_nothankyou_position INT UNSIGNED 10 1
civicrm_domain Table contact_id INT UNSIGNED 10 null

FK to Contact ID. This is specifically not an FK to avoid circular constraints

civicrm_address Table supplemental_address_2 VARCHAR 96 null

Supplemental Address Information, Line 2

civicrm_contribution_page_en_US View thankyou_title VARCHAR 255 null
civicrm_uf_group_en_US View is_uf_link TINYINT 3 0

Should we display a link to the website profile in profile selector

civicrm_uf_group_fr_CA View cancel_button_text VARCHAR 64 null

Custom Text to display on the cancel button when used in create or edit mode

civicrm_action_schedule Table subject VARCHAR 128 null

Subject of mailing

civicrm_location_type Table is_reserved TINYINT 3 null

Is this location type a predefined system location?

civicrm_custom_field_fr_CA View end_date_years INT 10 null

Date may be up to end_date_years years after the current date.

civicrm_contribution_page Table thankyou_footer_en_US TEXT 65535 null
civicrm_contribution_page_en_US View created_date DATETIME 19 null

Date and time that contribution page was created.

civicrm_tell_friend Table id INT UNSIGNED 10 null

Friend ID

civicrm_event_en_US View financial_type_id INT UNSIGNED 10 null

Financial type assigned to paid event registrations for this event. Required if is_monetary is true.

civicrm_membership_block_fr_CA View membership_types VARCHAR 1024 null

Membership types to be exposed by this block.

civicrm_group_fr_CA View children TEXT 65535 null

IDs of the child(ren)

civicrm_option_group_fr_CA View description VARCHAR 255 null
civicrm_line_item Table entity_table VARCHAR 64 null

table which has the transaction

civicrm_event_en_US View approval_req_text TEXT 65535 null
civicrm_financial_account Table contact_id INT UNSIGNED 10 null

FK to Contact ID that is responsible for the funds in this account

civicrm_price_field_fr_CA View help_post TEXT 65535 null
civicrm_premiums Table premiums_nothankyou_label_fr_CA VARCHAR 255 null
civicrm_batch_en_US View exported_date DATETIME 19 null
civicrm_grant Table grant_type_id INT UNSIGNED 10 null

Type of grant. Implicit FK to civicrm_option_value in grant_type option_group.

civicrm_tell_friend Table thankyou_title_fr_CA VARCHAR 255 null
civicrm_group Table cache_date TIMESTAMP 19 null
civicrm_custom_group_en_US View weight INT 10 1

Controls display order when multiple extended property groups are setup for the same class.

civicrm_mail_settings Table id INT UNSIGNED 10 null

primary key

civicrm_pcp Table id INT UNSIGNED 10 null

Personal Campaign Page ID

civicrm_group_en_US View visibility VARCHAR 24 User and User Admin Only

In what context(s) is this field visible.

civicrm_uf_field_fr_CA View field_name VARCHAR 64 null

Name for CiviCRM field which is being exposed for sharing.

civicrm_tag Table created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this tag

civicrm_contribution_page_fr_CA View recur_frequency_unit VARCHAR 128 null

Supported recurring frequency units.

civicrm_uf_group_en_US View id INT UNSIGNED 10 0

Unique table ID

civicrm_mailing_bounce_pattern Table id INT UNSIGNED 10 null
civicrm_group_en_US View cache_date TIMESTAMP 19 null
civicrm_entity_financial_trxn Table financial_trxn_id INT UNSIGNED 10 null
civicrm_mailing_group Table mailing_id INT UNSIGNED 10 null

The ID of a previous mailing to include/exclude recipients.

civicrm_price_set_fr_CA View is_active TINYINT 3 1

Is this price set active

civicrm_custom_group_fr_CA View is_reserved TINYINT 3 0

Is this a reserved Custom Group?

civicrm_contribution_page Table goal_amount DECIMAL 20 null

The target goal for this page, allows people to build a goal meter

civicrm_email Table is_billing TINYINT 3 0

Is this the billing?

civicrm_prevnext_cache Table cacheKey VARCHAR 255 null

Unique path name for cache element of the searched item

civicrm_dashboard_fr_CA View permission VARCHAR 255 null

Permission for the dashlet

civicrm_custom_group_fr_CA View collapse_display INT UNSIGNED 10 0

Will this group be in collapsed or expanded mode on initial display ?

civicrm_state_province Table country_id INT UNSIGNED 10 null

ID of Country that State/Province belong

civicrm_uf_field_fr_CA View label VARCHAR 255 null
civicrm_survey Table last_modified_id INT UNSIGNED 10 null

FK to civicrm_contact, who recently edited this Survey.

civicrm_event_en_US View thankyou_title VARCHAR 255 null
civicrm_membership_block_en_US View is_required TINYINT 3 0

Is membership sign up optional

civicrm_premiums Table entity_table VARCHAR 64 null

Joins these premium settings to another object. Always civicrm_contribution_page for now.

civicrm_contribution_page_en_US View adjust_recur_start_date TINYINT 3 0

If true - user is able to adjust payment start date.

civicrm_contribution_product Table end_date DATE 10 null

Actual end date for a time-delimited premium (subscription, service or membership)

civicrm_survey_en_US View is_default TINYINT 3 0

Is this default survey?

civicrm_dashboard_contact Table contact_id INT UNSIGNED 10 null

Contact ID

civicrm_pcp_block Table id INT UNSIGNED 10 null

PCP block Id

civicrm_option_value Table component_id INT UNSIGNED 10 null

Component that this option value belongs/caters to.

civicrm_premiums Table premiums_display_min_contribution TINYINT 3 null

Boolean. Should we automatically display minimum contribution amount text after the premium descriptions.

civicrm_product_en_US View frequency_unit VARCHAR 8 month

Frequency unit and interval allow option to store actual delivery frequency for a subscription or service.

civicrm_events_in_carts Table event_id INT UNSIGNED 10 null

FK to Event ID

civicrm_action_mapping Table id INT UNSIGNED 10 null
civicrm_option_value_fr_CA View name VARCHAR 255 null

Stores a fixed (non-translated) name for this option value. Lookup functions should use the name as the key for the option value row.

civicrm_group_en_US View children TEXT 65535 null

IDs of the child(ren)

civicrm_extension Table full_name VARCHAR 255 null

Fully qualified extension name

civicrm_action_log Table action_schedule_id INT UNSIGNED 10 null

FK to the action schedule that this action originated from.

civicrm_contribution_recur Table processor_id VARCHAR 255 null

Possibly needed to store a unique identifier for this recurring payment order - if this is available from the processor??

civicrm_product_fr_CA View description TEXT 65535 null
civicrm_contribution_soft Table contribution_id INT UNSIGNED 10 null

FK to contribution table.

civicrm_pledge Table additional_reminder_day INT UNSIGNED 10 5

Send additional reminder this many days after last one sent, up to maximum number of reminders.

civicrm_acl_entity_role Table entity_table VARCHAR 64 null

Table of the object joined to the ACL Role (Contact or Group)

civicrm_extension Table label VARCHAR 255 null

Short, printable name

civicrm_event_fr_CA View pay_later_receipt TEXT 65535 null
civicrm_survey_en_US View thankyou_title VARCHAR 255 null
civicrm_uf_match Table id INT UNSIGNED 10 null

System generated ID.

civicrm_premiums Table premiums_intro_title_fr_CA VARCHAR 255 null
civicrm_custom_group_en_US View created_date DATETIME 19 null

Date and time this custom group was created.

civicrm_relationship_type Table label_b_a_en_US VARCHAR 64 null
civicrm_extension Table name VARCHAR 255 null

Short name

civicrm_contact Table deceased_date DATE 10 null

Date of deceased

civicrm_mapping Table name VARCHAR 64 null

Name of Mapping

civicrm_membership_type_fr_CA View weight INT 10 null
civicrm_batch_fr_CA View data LONGTEXT 2147483647 null

cache entered data

civicrm_membership_status_en_US View is_reserved TINYINT 3 0

Is this membership_status reserved.

civicrm_contribution_page Table receipt_from_email VARCHAR 255 null

FROM email address used for receipts generated by contributions to this contribution page.

civicrm_membership Table source VARCHAR 128 null
civicrm_price_field_value_fr_CA View membership_type_id INT UNSIGNED 10 null

FK to Membership Type

civicrm_line_item Table participant_count INT UNSIGNED 10 null

Participant count for field

civicrm_contribution Table cancel_reason TEXT 65535 null
civicrm_group Table title_en_US VARCHAR 64 null
civicrm_dashboard_en_US View url VARCHAR 255 null

url in case of external dashlet

civicrm_mailing_abtest Table declare_winning_time DATETIME 19 null

In how much time to declare winner

civicrm_custom_field_fr_CA View option_group_id INT UNSIGNED 10 null

For elements with options, the option group id that is used

civicrm_event Table fee_label_fr_CA VARCHAR 255 null
civicrm_tag Table parent_id INT UNSIGNED 10 null

Optional parent id for this tag.

civicrm_option_value Table value VARCHAR 512 null

The actual value stored (as a foreign key) in the data record. Functions which need lookup option_value.title should use civicrm_option_value.option_group_id plus civicrm_option_value.value as the key.

civicrm_option_group Table is_reserved TINYINT 3 1

Is this a predefined system option group (i.e. it can not be deleted)?

civicrm_system_log Table context LONGTEXT 2147483647 null

JSON encoded data

civicrm_premiums_en_US View premiums_active TINYINT 3 0

Is the Premiums feature enabled for this page?

civicrm_mailing_event_bounce Table event_queue_id INT UNSIGNED 10 null

FK to EventQueue

civicrm_uf_group_en_US View help_pre TEXT 65535 null
civicrm_participant_status_type_fr_CA View is_reserved TINYINT 3 null

whether this is a status type required by the system

civicrm_contribution_recur Table payment_instrument_id INT UNSIGNED 10 null

FK to Payment Instrument

civicrm_grant Table rationale TEXT 65535 null

Grant rationale.

civicrm_membership_type_en_US View relationship_type_id VARCHAR 64 null

FK to Relationship Type ID

civicrm_premiums_en_US View premiums_contact_email VARCHAR 100 null

This email address is included in receipts if it is populated and a premium has been selected.

civicrm_option_value_fr_CA View weight INT UNSIGNED 10 null

Controls display sort order.

civicrm_custom_field_fr_CA View is_active TINYINT 3 null

Is this property active?

civicrm_membership_type_en_US View name VARCHAR 128 null
civicrm_event_en_US View parent_event_id INT UNSIGNED 10 null

Implicit FK to civicrm_event: parent event

civicrm_contribution_page_fr_CA View receipt_text TEXT 65535 null
civicrm_pcp_block_fr_CA View entity_id INT UNSIGNED 10 null

FK to civicrm_contribution_page.id OR civicrm_event.id

civicrm_membership_type_fr_CA View duration_unit VARCHAR 8 null

Unit in which membership period is expressed.

civicrm_pcp_block_en_US View tellfriend_limit INT UNSIGNED 10 null

Maximum recipient fields allowed in tell a friend

civicrm_financial_trxn Table currency VARCHAR 3 null

3 character string, value from config setting or input via user.

civicrm_location_type_fr_CA View is_default TINYINT 3 null

Is this location type the default?

civicrm_survey Table thankyou_text_en_US TEXT 65535 null
civicrm_contribution_page Table cc_receipt VARCHAR 255 null

comma-separated list of email addresses to cc each time a receipt is sent

civicrm_premiums_fr_CA View entity_id INT UNSIGNED 10 null
civicrm_contribution_page_fr_CA View is_recur_interval TINYINT 3 0

if true - supports recurring intervals

civicrm_membership_block Table renewal_text_en_US TEXT 65535 null
civicrm_contribution_page_en_US View is_active TINYINT 3 null

Is this property active?

civicrm_product Table frequency_unit VARCHAR 8 month

Frequency unit and interval allow option to store actual delivery frequency for a subscription or service.

civicrm_pledge Table create_date DATETIME 19 null

When this pledge record was created.

civicrm_campaign_group Table entity_id INT UNSIGNED 10 null

Entity id of referenced table.

civicrm_uf_group Table is_reserved TINYINT 3 null

Is this group reserved for use by some other CiviCRM functionality?

civicrm_pcp Table is_notify INT 10 0
civicrm_contact Table display_name VARCHAR 128 null

Formatted name representing preferred format for display/print/other output.

civicrm_event_fr_CA View is_monetary TINYINT 3 0

If true, one or more fee amounts must be set and a Payment Processor must be configured for Online Event Registration.

civicrm_price_set Table id INT UNSIGNED 10 null

Price Set

civicrm_survey Table instructions_fr_CA TEXT 65535 null
civicrm_pledge_payment Table pledge_id INT UNSIGNED 10 null

FK to Pledge table

civicrm_job Table scheduled_run_date TIMESTAMP 19 null

When is this cron entry scheduled to run

civicrm_group_en_US View title VARCHAR 64 null
civicrm_financial_item Table id INT UNSIGNED 10 null
civicrm_dashboard_en_US View name VARCHAR 64 null

Internal name of dashlet.

civicrm_contribution_page Table pay_later_text_fr_CA TEXT 65535 null
civicrm_email Table signature_text TEXT 65535 null

Text formatted signature for the email.

civicrm_custom_group_fr_CA View help_pre TEXT 65535 null
civicrm_uf_group_fr_CA View is_update_dupe TINYINT 3 0

Should we update the contact record if we find a duplicate

civicrm_contribution_recur Table end_date DATETIME 19 null

Date this recurring contribution finished successfully

civicrm_action_mapping Table entity_value VARCHAR 64 null

Entity value

civicrm_contribution_page Table start_date DATETIME 19 null

Date and time that this page starts.

civicrm_tell_friend_fr_CA View thankyou_text TEXT 65535 null
civicrm_price_field_value_fr_CA View name VARCHAR 255 null

Price field option name

civicrm_custom_field_en_US View html_type VARCHAR 32 null

HTML types plus several built-in extended types.

civicrm_word_replacement Table match_type VARCHAR 16 wildcardMatch
civicrm_membership_block Table display_min_fee TINYINT 3 1

Display minimum membership fee

civicrm_case_type_fr_CA View definition BLOB 65535 null

xml definition of case type

civicrm_price_set_entity Table entity_id INT UNSIGNED 10 null

Item in table

civicrm_financial_trxn Table fee_amount DECIMAL 20 null

actual processor fee if known - may be 0.

civicrm_custom_group Table created_date DATETIME 19 null

Date and time this custom group was created.

civicrm_option_value Table description_en_US TEXT 65535 null
civicrm_pledge Table cancel_date DATETIME 19 null

Date this pledge was cancelled by contributor.

civicrm_event Table is_share TINYINT 3 1

Can people share the event through social media?

civicrm_relationship_type Table contact_sub_type_a VARCHAR 64 null

If defined, contact_sub_type_a in a relationship of this type must be a specific contact_sub_type.

civicrm_dashboard_fr_CA View domain_id INT UNSIGNED 10 null

Domain for dashboard

civicrm_event_en_US View end_date DATETIME 19 null

Date and time that event ends. May be NULL if no defined end date/time

civicrm_dashboard_fr_CA View is_reserved TINYINT 3 0

Is this dashlet reserved?

civicrm_payment_token Table expiry_date DATETIME 19 null

Date this token expires

civicrm_component Table name VARCHAR 64 null

Name of the component.

civicrm_price_set_fr_CA View extends VARCHAR 255 null

What components are using this price set?

civicrm_event_fr_CA View description TEXT 65535 null
civicrm_custom_group_fr_CA View extends_entity_column_id INT UNSIGNED 10 null

FK to civicrm_option_value.id (for option group custom_data_type.)

civicrm_pcp_block Table entity_id INT UNSIGNED 10 null

FK to civicrm_contribution_page.id OR civicrm_event.id

civicrm_report_instance Table is_active TINYINT 3 null

Is this entry active?

civicrm_dedupe_exception Table id INT UNSIGNED 10 null

Unique dedupe exception id

civicrm_event Table confirm_text_en_US TEXT 65535 null
civicrm_payment_processor Table domain_id INT UNSIGNED 10 null

Which Domain is this match entry for

civicrm_premiums_en_US View id INT UNSIGNED 10 0
civicrm_financial_item Table contact_id INT UNSIGNED 10 null

FK to Contact ID of contact the item is from

civicrm_group_nesting Table id INT UNSIGNED 10 null

Relationship ID

civicrm_price_set Table help_pre_en_US TEXT 65535 null
civicrm_mailing Table reply_id INT UNSIGNED 10 null

FK to the auto-responder component.

civicrm_survey_en_US View activity_type_id INT UNSIGNED 10 null

Implicit FK to civicrm_option_value where option_group = activity_type

civicrm_price_field Table help_post_fr_CA TEXT 65535 null
civicrm_pledge_payment Table id INT UNSIGNED 10 null
civicrm_price_field_en_US View is_required TINYINT 3 1

Is this price field required (value must be > 1)

civicrm_participant Table must_wait INT 10 null

On Waiting List

civicrm_case Table modified_date TIMESTAMP 19 CURRENT_TIMESTAMP

When was the case (or closely related entity) was created or modified or deleted.

civicrm_mailing_job Table scheduled_date DATETIME 19 null

date on which this job was scheduled.

civicrm_contact_type Table description_fr_CA TEXT 65535 null
civicrm_menu Table module_data TEXT 65535 null

All other menu metadata not stored in other fields

civicrm_contribution_recur Table contribution_status_id INT UNSIGNED 10 1
civicrm_contribution_page_en_US View is_allow_other_amount TINYINT 3 0

if true, page will include an input text field where user can enter their own amount

civicrm_msg_template Table msg_text LONGTEXT 2147483647 null

Text formatted message

civicrm_mailing_event_reply Table id INT UNSIGNED 10 null
civicrm_membership Table start_date DATE 10 null

Beginning of current uninterrupted membership period.

civicrm_line_item Table tax_amount DECIMAL 20 null

tax of each item

civicrm_uf_field Table is_searchable TINYINT 3 0

Is this field included search form of profile?

civicrm_batch_en_US View name VARCHAR 64 null

Variable name/programmatic handle for this batch.

civicrm_membership_status_fr_CA View id INT UNSIGNED 10 0

Membership Id

civicrm_action_schedule Table body_html LONGTEXT 2147483647 null

Body of the mailing in html format.

civicrm_mailing_group Table id INT UNSIGNED 10 null
civicrm_membership_status_fr_CA View is_default TINYINT 3 null

Assign this status to a membership record if no other status match is found.

civicrm_survey Table campaign_id INT UNSIGNED 10 null

Foreign key to the Campaign.

civicrm_event Table created_date DATETIME 19 null

Date and time that event was created.

civicrm_custom_field_en_US View help_pre TEXT 65535 null
civicrm_product Table duration_unit VARCHAR 8 year
civicrm_pcp_block_fr_CA View entity_table VARCHAR 64 null
civicrm_setting Table is_domain TINYINT 3 null

Is this setting a contact specific or site wide setting?

civicrm_pcp_block_fr_CA View link_text VARCHAR 255 null
civicrm_im Table id INT UNSIGNED 10 null

Unique IM ID

civicrm_mailing_component Table is_active TINYINT 3 null

Is this property active?

civicrm_contribution_page_fr_CA View receipt_from_email VARCHAR 255 null

FROM email address used for receipts generated by contributions to this contribution page.

civicrm_menu Table id INT UNSIGNED 10 null
civicrm_print_label Table description TEXT 65535 null

Description of this label layout

civicrm_price_field_value Table label_fr_CA VARCHAR 255 null
civicrm_pcp Table page_type VARCHAR 64 contribute

The type of PCP this is: contribute or event

civicrm_contribution_page Table intro_text_fr_CA TEXT 65535 null
civicrm_membership_type_en_US View minimum_fee DECIMAL 18 0.000000000

Minimum fee for this membership (0 for free/complimentary memberships).

civicrm_option_group Table is_locked TINYINT 3 null

A lock to remove the ability to add new options via the UI.

civicrm_im Table provider_id INT UNSIGNED 10 null

Which IM Provider does this screen name belong to.

civicrm_group_fr_CA View source VARCHAR 64 null

Module or process which created this group.

civicrm_relationship_type_en_US View description VARCHAR 255 null
civicrm_uf_field_en_US View help_post TEXT 65535 null
civicrm_country Table name VARCHAR 64 null

Country Name

civicrm_relationship_type Table name_b_a VARCHAR 64 null

Optional name for relationship of contact_b to contact_a.

civicrm_activity Table phone_number VARCHAR 64 null

Phone number in case the number does not exist in the civicrm_phone table.

civicrm_contribution_page Table pay_later_receipt_fr_CA TEXT 65535 null
civicrm_log Table id INT UNSIGNED 10 null

Log ID

civicrm_contact_type Table label_fr_CA VARCHAR 64 null
civicrm_tell_friend_en_US View id INT UNSIGNED 10 0

Friend ID

civicrm_contribution_page Table footer_text_en_US TEXT 65535 null
civicrm_mailing_event_trackable_url_open Table event_queue_id INT UNSIGNED 10 null

FK to EventQueue

civicrm_acl_entity_role Table entity_id INT UNSIGNED 10 null

ID of the group/contact object being joined

civicrm_contribution_page_fr_CA View end_date DATETIME 19 null

Date and time that this page ends. May be NULL if no defined end date/time

civicrm_batch_en_US View modified_date DATETIME 19 null

When was this item created

civicrm_group_fr_CA View saved_search_id INT UNSIGNED 10 null

FK to saved search table.

civicrm_custom_field_fr_CA View start_date_years INT 10 null

Date may be up to start_date_years years prior to the current date.

civicrm_group_en_US View select_tables TEXT 65535 null

the tables to be included in a select data

civicrm_line_item Table price_field_id INT UNSIGNED 10 null

FK to civicrm_price_field

civicrm_batch Table id INT UNSIGNED 10 null

Unique Address ID

civicrm_payment_token Table payment_processor_id INT UNSIGNED 10 null
civicrm_price_field Table visibility_id INT UNSIGNED 10 1

Implicit FK to civicrm_option_group with name = \'visibility\'

civicrm_contribution_page Table payment_processor VARCHAR 128 null

Payment Processors configured for this contribution Page

civicrm_uf_field_en_US View field_type VARCHAR 255 null

This field saves field type (ie individual,household.. field etc).

civicrm_mailing_event_opened Table time_stamp DATETIME 19 null

When this open event occurred.

civicrm_price_field_value_en_US View membership_type_id INT UNSIGNED 10 null

FK to Membership Type

civicrm_price_field_value Table description_fr_CA TEXT 65535 null
civicrm_survey_en_US View instructions TEXT 65535 null
civicrm_entity_batch Table entity_table VARCHAR 64 null

physical tablename for entity being joined to file, e.g. civicrm_contact

civicrm_case Table case_type_id INT UNSIGNED 10 null

FK to civicrm_case_type.id

civicrm_batch Table mode_id INT UNSIGNED 10 null

fk to Batch mode options in civicrm_option_values

civicrm_address Table street_number_postdirectional VARCHAR 8 null

Directional prefix, e.g. Main St S, S is the suffix.

civicrm_membership Table is_override TINYINT 3 null

Admin users may set a manual status which overrides the calculated status. When this flag is true, automated status update scripts should NOT modify status for the record.

civicrm_membership_type Table visibility VARCHAR 64 null
civicrm_event Table bcc_confirm VARCHAR 255 null

comma-separated list of email addresses to bcc each time a confirmation is sent

civicrm_loc_block Table id INT UNSIGNED 10 null

Unique ID

civicrm_worldregion Table name VARCHAR 128 null

Region name to be associated with countries

civicrm_contribution_page Table thankyou_text_en_US TEXT 65535 null
civicrm_contribution_recur Table cancel_date DATETIME 19 null

Date this recurring contribution was cancelled by contributor- if we can get access to it

civicrm_contribution_page Table receipt_from_name_fr_CA VARCHAR 255 null
civicrm_custom_group Table is_multiple TINYINT 3 null

Does this group hold multiple values?

civicrm_price_field_value Table visibility_id INT UNSIGNED 10 1

Implicit FK to civicrm_option_group with name = 'visibility'

civicrm_custom_group_fr_CA View created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this custom group

civicrm_membership_type_en_US View member_of_contact_id INT UNSIGNED 10 null

Owner organization for this membership type. FK to Contact ID

civicrm_phone Table phone_numeric VARCHAR 32 null

Phone number stripped of all whitespace, letters, and punctuation.

civicrm_uf_field Table phone_type_id INT UNSIGNED 10 null

Phone Type Id, if required

civicrm_file Table uri VARCHAR 255 null

uri of the file on disk

civicrm_dashboard_contact Table is_active TINYINT 3 0

Is this widget active?

civicrm_product_fr_CA View frequency_unit VARCHAR 8 month

Frequency unit and interval allow option to store actual delivery frequency for a subscription or service.

civicrm_group_contact Table id INT UNSIGNED 10 null

primary key

civicrm_contribution_page_fr_CA View payment_processor VARCHAR 128 null

Payment Processors configured for this contribution Page

civicrm_contribution_recur Table trxn_id VARCHAR 255 null

unique transaction id. may be processor id, bank id + trans id, or account number + check number... depending on payment_method

civicrm_contact Table legal_name VARCHAR 128 null

Legal Name.

civicrm_location_type_fr_CA View description VARCHAR 255 null

Location Type Description.

civicrm_pcp_block_fr_CA View supporter_profile_id INT UNSIGNED 10 null

FK to civicrm_uf_group.id. Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?

civicrm_membership_log Table id INT UNSIGNED 10 null
civicrm_batch_en_US View status_id INT UNSIGNED 10 null

fk to Batch Status options in civicrm_option_values

civicrm_tag Table name VARCHAR 64 null

Name of Tag.

civicrm_membership_block_fr_CA View entity_table VARCHAR 64 null

Name for Membership Status

civicrm_contact_type_en_US View image_URL VARCHAR 255 null

URL of image if any.

civicrm_custom_group_en_US View is_active TINYINT 3 null

Is this property active?

civicrm_mailing Table resubscribe_id INT UNSIGNED 10 null
civicrm_event_en_US View is_email_confirm TINYINT 3 0

If true, confirmation is automatically emailed to contact on successful registration.

civicrm_navigation Table permission_operator VARCHAR 3 null

Permission Operator

civicrm_address Table street_unit VARCHAR 16 null

Secondary unit designator, e.g. Apt 3 or Unit # 14, or Bldg 1200

civicrm_contribution_page_en_US View title VARCHAR 255 null
civicrm_batch_en_US View type_id INT UNSIGNED 10 null

fk to Batch Type options in civicrm_option_values

civicrm_contribution_page Table receipt_from_name_en_US VARCHAR 255 null
civicrm_grant Table contact_id INT UNSIGNED 10 null

Contact ID of contact record given grant belongs to.

civicrm_saved_search Table select_tables TEXT 65535 null

the tables to be included in a select data

civicrm_mapping_field Table relationship_type_id INT UNSIGNED 10 null

Relationship type, if required

civicrm_membership_type Table name_fr_CA VARCHAR 128 null
civicrm_membership_type_fr_CA View receipt_text_renewal VARCHAR 255 null

Receipt Text for membership renewal

civicrm_navigation Table url VARCHAR 255 null

url in case of custom navigation link

civicrm_uf_match Table domain_id INT UNSIGNED 10 null

Which Domain is this match entry for

civicrm_event_fr_CA View created_date DATETIME 19 null

Date and time that event was created.

civicrm_participant Table status_id INT UNSIGNED 10 1

Participant status ID. FK to civicrm_participant_status_type. Default of 1 should map to status = Registered.

civicrm_price_set Table javascript VARCHAR 64 null

Optional Javascript script function(s) included on the form with this price_set. Can be used for conditional

civicrm_action_schedule Table sms_template_id INT UNSIGNED 10 null

SMS Reminder Template. FK to id in civicrm_msg_template.

civicrm_sms_provider Table api_type INT UNSIGNED 10 null

points to value in civicrm_option_value for group sms_api_type

civicrm_status_pref Table ignore_severity INT UNSIGNED 10 1

Hush messages up to and including this severity.

civicrm_price_field Table help_pre_en_US TEXT 65535 null
civicrm_mapping_field Table location_type_id INT UNSIGNED 10 null

Location type of this mapping, if required

civicrm_activity Table source_record_id INT UNSIGNED 10 null

Artificial FK to original transaction (e.g. contribution) IF it is not an Activity. Table can be figured out through activity_type_id, and further through component registry.

civicrm_relationship Table contact_id_a INT UNSIGNED 10 null

id of the first contact

civicrm_event_en_US View is_template TINYINT 3 0

whether the event has template

civicrm_custom_group Table name VARCHAR 64 null

Variable name/programmatic handle for this group.

civicrm_pledge Table original_installment_amount DECIMAL 20 null

Original amount for each of the installments.

civicrm_pledge_block Table pledge_frequency_unit VARCHAR 128 null

Delimited list of supported frequency units

civicrm_custom_field_fr_CA View data_type VARCHAR 16 null

Controls location of data storage in extended_data table.

civicrm_event_fr_CA View is_online_registration TINYINT 3 0

If true, include registration link on Event Info page.

civicrm_mapping_field Table phone_type_id INT UNSIGNED 10 null

Which type of phone does this number belongs.

civicrm_dashboard_fr_CA View fullscreen_url VARCHAR 255 null

fullscreen url for dashlet

civicrm_event Table waitlist_text_fr_CA TEXT 65535 null
civicrm_menu Table page_type INT 10 1

CiviCRM menu type.

civicrm_cache Table component_id INT UNSIGNED 10 null

Component that this menu item belongs to

civicrm_mailing Table replyto_email VARCHAR 128 null

Reply-To Email of mailing

civicrm_survey_fr_CA View max_number_of_contacts INT UNSIGNED 10 null

Maximum number of contacts to allow for survey.

civicrm_membership_block Table new_text_en_US TEXT 65535 null
civicrm_price_field_en_US View active_on DATETIME 19 null

If non-zero, do not show this field before the date specified

civicrm_price_field Table expire_on DATETIME 19 null

If non-zero, do not show this field after the date specified

civicrm_product Table cost DECIMAL 20 null

Actual cost of this product. Useful to determine net return from sale or using this as an incentive.

civicrm_event_en_US View is_public TINYINT 3 1

Public events will be included in the iCal feeds. Access to private event information may be limited using ACLs.

civicrm_event Table confirm_text_fr_CA TEXT 65535 null
civicrm_price_field_value_en_US View description TEXT 65535 null
civicrm_product_fr_CA View fixed_period_start_day INT 10 101

Month and day (MMDD) that fixed period type subscription or membership starts.

civicrm_uf_field_fr_CA View help_post TEXT 65535 null
civicrm_contact Table id INT UNSIGNED 10 null

Unique Contact ID

civicrm_contribution_page_fr_CA View is_allow_other_amount TINYINT 3 0

if true, page will include an input text field where user can enter their own amount

civicrm_membership_type_en_US View duration_interval INT 10 null

Number of duration units in membership period (e.g. 1 year, 12 months).

civicrm_mailing Table visibility VARCHAR 40 Public Pages

In what context(s) is the mailing contents visible (online viewing)

civicrm_mailing Table is_completed TINYINT 3 null

Has at least one job associated with this mailing finished?

civicrm_uf_field_fr_CA View id INT UNSIGNED 10 0

Unique table ID

civicrm_contact Table created_date TIMESTAMP 19 null

When was the contact was created.

civicrm_word_replacement Table is_active TINYINT 3 1

Is this entry active?

civicrm_uf_field_en_US View uf_group_id INT UNSIGNED 10 null

Which form does this field belong to.

civicrm_event_fr_CA View has_waitlist TINYINT 3 null

Whether the event has waitlist support.

civicrm_uf_field Table uf_group_id INT UNSIGNED 10 null

Which form does this field belong to.

civicrm_cxn Table cxn_guid VARCHAR 128 null

Connection GUID

civicrm_menu Table path_arguments TEXT 65535 null

Arguments to pass to the url

civicrm_price_set_en_US View domain_id INT UNSIGNED 10 null

Which Domain is this price-set for

civicrm_navigation Table weight INT 10 null

Ordering of the navigation items in various blocks.

civicrm_mailing_event_unsubscribe Table org_unsubscribe TINYINT 3 null

Unsubscribe at org- or group-level

civicrm_payment_processor_type Table name VARCHAR 64 null

Payment Processor Name.

civicrm_uf_field_fr_CA View location_type_id INT UNSIGNED 10 null

Location type of this mapping, if required

civicrm_event_fr_CA View thankyou_text TEXT 65535 null
civicrm_tell_friend Table entity_id INT UNSIGNED 10 null

Foreign key to the referenced item.

civicrm_pledge_block Table is_pledge_start_date_editable TINYINT 3 0

If true - recurring start date is editable.

civicrm_membership_block_en_US View renewal_title VARCHAR 255 null
civicrm_relationship_type_en_US View contact_type_b VARCHAR 12 null

If defined, contact_b in a relationship of this type must be a specific contact_type.

civicrm_cache Table group_name VARCHAR 32 null

group name for cache element, useful in cleaning cache elements

civicrm_mailing_spool Table headers TEXT 65535 null

The header information of this mailing .

civicrm_mail_settings Table activity_status VARCHAR 255 null

Name of status to use when creating email to activity.

civicrm_address Table street_address VARCHAR 96 null

Concatenation of all routable street address components (prefix, street number, street name, suffix, unit number OR P.O. Box). Apps should be able to determine physical location with this data (for mapping, mail delivery, etc.).

civicrm_openid Table id INT UNSIGNED 10 null

Unique OpenID ID

civicrm_contribution_widget Table color_bg VARCHAR 10 null
civicrm_price_field_fr_CA View name VARCHAR 255 null

Variable name/programmatic handle for this field.

civicrm_case Table is_deleted TINYINT 3 0
civicrm_contribution_widget Table button_title VARCHAR 255 null

Button title.

civicrm_participant_status_type_en_US View is_active TINYINT 3 1

whether this status type is active

civicrm_custom_group Table help_post_fr_CA TEXT 65535 null
civicrm_premiums Table premiums_nothankyou_position INT UNSIGNED 10 1
civicrm_custom_field_en_US View is_search_range TINYINT 3 0

Is this property range searchable.

civicrm_group_fr_CA View is_hidden TINYINT 3 0

Is this group hidden?

civicrm_membership_status_en_US View weight INT 10 null
civicrm_participant_status_type_fr_CA View weight INT UNSIGNED 10 null

controls sort order

civicrm_membership_type Table description_fr_CA VARCHAR 255 null
civicrm_membership_type Table financial_type_id INT UNSIGNED 10 null

If membership is paid by a contribution - what financial type should be used. FK to civicrm_financial_type.id

civicrm_event Table summary_en_US TEXT 65535 null
civicrm_preferences_date Table end INT 10 null

The end offset relative to current year, can be negative

civicrm_mailing Table id INT UNSIGNED 10 null
civicrm_custom_field Table help_pre_fr_CA TEXT 65535 null
civicrm_membership_status Table id INT UNSIGNED 10 null

Membership Id

civicrm_membership_block_en_US View entity_table VARCHAR 64 null

Name for Membership Status

civicrm_mailing_job Table is_test TINYINT 3 0

Is this job for a test mail?

civicrm_event_en_US View campaign_id INT UNSIGNED 10 null

The campaign for which this event has been created.

civicrm_tag Table color VARCHAR 255 null

Hex color value e.g. #ffffff

civicrm_mail_settings Table source VARCHAR 255 null

folder to poll from when using IMAP, path to poll from when using Maildir, etc.

civicrm_financial_type Table is_active TINYINT 3 null

Is this property active?

civicrm_custom_field_en_US View is_searchable TINYINT 3 null

Is this property searchable.

civicrm_membership_log Table end_date DATE 10 null

New membership period expiration date.

civicrm_report_instance Table footer TEXT 65535 null

comma-separated list of email addresses to send the report to

civicrm_location_type Table display_name_fr_CA VARCHAR 64 null
civicrm_contribution_page_en_US View initial_amount_label VARCHAR 255 null
civicrm_campaign Table status_id INT UNSIGNED 10 null

Campaign status ID.Implicit FK to civicrm_option_value where option_group = campaign_status

civicrm_uf_field_fr_CA View uf_group_id INT UNSIGNED 10 null

Which form does this field belong to.

civicrm_pledge Table frequency_unit VARCHAR 8 month

Time units for recurrence of pledge payments.

civicrm_price_field_value Table is_active TINYINT 3 1

Is this price field value active

civicrm_activity Table is_star TINYINT 3 0

Activity marked as favorite.

civicrm_entity_file Table id INT UNSIGNED 10 null

primary key

civicrm_price_field_value_en_US View help_pre TEXT 65535 null

Price field option pre help text.

civicrm_dedupe_rule Table id INT UNSIGNED 10 null

Unique dedupe rule id

civicrm_uf_field_en_US View is_view TINYINT 3 0

the field is view only and not editable in user forms.

civicrm_contribution_page_fr_CA View bcc_receipt VARCHAR 255 null

comma-separated list of email addresses to bcc each time a receipt is sent

civicrm_dashboard Table name VARCHAR 64 null

Internal name of dashlet.

civicrm_premiums Table id INT UNSIGNED 10 null
civicrm_action_mapping Table entity_status_label VARCHAR 64 null

Entity status label

civicrm_membership_status_en_US View is_current_member TINYINT 3 null

Does this status aggregate to current members (e.g. New, Renewed, Grace might all be TRUE... while Unrenewed, Lapsed, Inactive would be FALSE).

civicrm_financial_account Table is_default TINYINT 3 null

Is this account the default one (or default tax one) for its financial_account_type?

civicrm_contribution_page_en_US View bcc_receipt VARCHAR 255 null

comma-separated list of email addresses to bcc each time a receipt is sent

civicrm_print_label Table label_type_id INT UNSIGNED 10 null

Implicit FK to civicrm_option_value row in NEW label_type option group

civicrm_action_schedule Table limit_to TINYINT 3 null
civicrm_job Table api_entity VARCHAR 255 null

Entity of the job api call

civicrm_event Table is_billing_required TINYINT 3 0

Billing block required for Event

civicrm_saved_search Table search_custom_id INT UNSIGNED 10 null

Foreign key to civicrm_option value table used for saved custom searches.

civicrm_event_en_US View max_participants INT UNSIGNED 10 null

Maximum number of registered participants to allow. After max is reached, a custom Event Full message is displayed. If NULL, allow unlimited number of participants.

civicrm_uf_group_fr_CA View is_reserved TINYINT 3 null

Is this group reserved for use by some other CiviCRM functionality?

civicrm_activity Table is_auto TINYINT 3 0
civicrm_participant_status_type Table label_fr_CA VARCHAR 255 null
civicrm_mapping Table description VARCHAR 255 null

Description of Mapping.

civicrm_dashboard Table id INT UNSIGNED 10 null
civicrm_membership_log Table modified_date DATE 10 null

Date this membership modification action was logged.

civicrm_mailing_abtest Table specific_url VARCHAR 255 null

What specific url to track

civicrm_event Table allow_selfcancelxfer TINYINT 3 0

Allow self service cancellation or transfer for event?

civicrm_custom_field_fr_CA View html_type VARCHAR 32 null

HTML types plus several built-in extended types.

civicrm_mailing_event_reply Table event_queue_id INT UNSIGNED 10 null

FK to EventQueue

civicrm_entity_financial_account Table financial_account_id INT UNSIGNED 10 null

FK to the financial_account_id

civicrm_option_value_fr_CA View domain_id INT UNSIGNED 10 null

Which Domain is this option value for

civicrm_product_fr_CA View name VARCHAR 255 null
civicrm_group_en_US View modified_id INT UNSIGNED 10 null

FK to contact table.

civicrm_event_carts Table id INT UNSIGNED 10 null

Cart Id

civicrm_job Table last_run DATETIME 19 null

When was this cron entry last run

civicrm_tell_friend_en_US View is_active TINYINT 3 null
civicrm_price_field Table label_fr_CA VARCHAR 255 null
civicrm_membership_status_fr_CA View weight INT 10 null
civicrm_cxn Table fetched_date TIMESTAMP 19 null

The last time the application metadata was fetched.

civicrm_batch_fr_CA View total DECIMAL 20 null

Total amount for this batch.

civicrm_survey_fr_CA View thankyou_text TEXT 65535 null
civicrm_uf_join Table entity_table VARCHAR 64 null

Name of table where item being referenced is stored. Modules which only need a single collection of uf_join instances may choose not to populate entity_table and entity_id.

civicrm_cache Table expired_date DATETIME 19 null

When should the cache item expire

civicrm_pledge Table status_id INT UNSIGNED 10 null

Implicit foreign key to civicrm_option_values in the contribution_status option group.

civicrm_contribution Table invoice_number VARCHAR 255 null

Human readable invoice number

civicrm_membership Table status_id INT UNSIGNED 10 null

FK to Membership Status

civicrm_survey_en_US View max_number_of_contacts INT UNSIGNED 10 null

Maximum number of contacts to allow for survey.

civicrm_events_in_carts Table id INT UNSIGNED 10 null

Event In Cart Id

civicrm_survey_fr_CA View campaign_id INT UNSIGNED 10 null

Foreign key to the Campaign.

civicrm_event_en_US View allow_same_participant_emails TINYINT 3 0

if true - allows the user to register multiple registrations from same email address.

civicrm_mailing_event_forward Table dest_queue_id INT UNSIGNED 10 null

FK to EventQueue for destination

civicrm_uf_group Table help_post_en_US TEXT 65535 null
civicrm_event_en_US View expiration_time INT UNSIGNED 10 null

Expire pending but unconfirmed registrations after this many hours.

civicrm_mailing_event_reply Table time_stamp DATETIME 19 null

When this reply event occurred.

civicrm_system_log Table timestamp TIMESTAMP 19 CURRENT_TIMESTAMP

Timestamp of when event occurred.

civicrm_event Table event_full_text_fr_CA TEXT 65535 null
civicrm_case_type_en_US View title VARCHAR 64 null
civicrm_case_type_fr_CA View name VARCHAR 64 null

Machine name for Case Type

civicrm_event_fr_CA View campaign_id INT UNSIGNED 10 null

The campaign for which this event has been created.

civicrm_action_schedule Table start_action_offset INT UNSIGNED 10 null

Reminder Interval.

civicrm_contact Table formal_title VARCHAR 64 null

Formal (academic or similar) title in front of name. (Prof., Dr. etc.)

civicrm_action_mapping Table entity_date_start VARCHAR 64 null

Entity date

civicrm_event_fr_CA View confirm_from_name VARCHAR 255 null
civicrm_payment_processor_type Table url_recur_default VARCHAR 255 null
civicrm_contribution_page_en_US View amount_block_is_active TINYINT 3 1

Is this property active?

civicrm_event_fr_CA View approval_req_text TEXT 65535 null
civicrm_grant Table currency VARCHAR 3 null

3 character string, value from config setting or input via user.

civicrm_custom_group_fr_CA View extends VARCHAR 255 Contact

Type of object this group extends (can add other options later e.g. contact_address, etc.).

civicrm_event Table intro_text_fr_CA TEXT 65535 null
civicrm_custom_field Table time_format INT UNSIGNED 10 null

time format for custom date

civicrm_acl Table id INT UNSIGNED 10 null

Unique table ID

civicrm_price_field_en_US View options_per_line INT UNSIGNED 10 1

number of options per line for checkbox and radio

civicrm_contact Table user_unique_id VARCHAR 255 null

the OpenID (or OpenID-style http://username.domain/) unique identifier for this contact mainly used for logging in to CiviCRM

civicrm_price_field_en_US View visibility_id INT UNSIGNED 10 1

Implicit FK to civicrm_option_group with name = \'visibility\'

civicrm_menu Table page_arguments TEXT 65535 null

Arguments to pass to page callback

civicrm_product Table is_active TINYINT 3 null

Disabling premium removes it from the premiums_premium join table below.

civicrm_timezone Table abbreviation CHAR 3 null

ISO Code for timezone abbreviation

civicrm_uf_group_fr_CA View created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this UF group

civicrm_uf_field Table id INT UNSIGNED 10 null

Unique table ID

civicrm_uf_field Table label_fr_CA VARCHAR 255 null
civicrm_batch Table description_fr_CA TEXT 65535 null
civicrm_event Table max_participants INT UNSIGNED 10 null

Maximum number of registered participants to allow. After max is reached, a custom Event Full message is displayed. If NULL, allow unlimited number of participants.

civicrm_financial_account Table is_tax TINYINT 3 0

Is this account for taxes?

civicrm_action_schedule Table communication_language VARCHAR 8 null

Used for multilingual installation

civicrm_premiums Table premiums_contact_email VARCHAR 100 null

This email address is included in receipts if it is populated and a premium has been selected.

civicrm_payment_processor_type Table id INT UNSIGNED 10 null

Payment Processor Type ID

civicrm_relationship_type Table description_fr_CA VARCHAR 255 null
civicrm_group Table is_active TINYINT 3 null

Is this entry active?

civicrm_mailing_job Table job_limit INT 10 0

Queue size limit for each child job

civicrm_membership_type Table member_of_contact_id INT UNSIGNED 10 null

Owner organization for this membership type. FK to Contact ID

civicrm_contribution_page Table initial_amount_label_en_US VARCHAR 255 null
civicrm_uf_group Table is_uf_link TINYINT 3 0

Should we display a link to the website profile in profile selector

civicrm_uf_group Table submit_button_text_fr_CA VARCHAR 64 null

Custom Text to display on the submit button on profile edit/create screens

civicrm_uf_field Table visibility VARCHAR 32 User and User Admin Only

In what context(s) is this field visible.

civicrm_membership_block Table membership_types VARCHAR 1024 null

Membership types to be exposed by this block.

civicrm_batch_en_US View id INT UNSIGNED 10 0

Unique Address ID

civicrm_price_field_value Table price_field_id INT UNSIGNED 10 null

FK to civicrm_price_field

civicrm_address Table street_number_suffix VARCHAR 8 null

Non-numeric portion of address number on the street, e.g. For 112A Main St, the street_number_suffix = A

civicrm_membership_block_fr_CA View new_title VARCHAR 255 null
civicrm_membership_status Table start_event VARCHAR 12 null

Event when this status starts.

civicrm_report_instance Table title VARCHAR 255 null

Report Instance Title.

civicrm_contribution_page_fr_CA View is_confirm_enabled TINYINT 3 1

if false, the confirm page in contribution pages gets skipped

civicrm_financial_account Table financial_account_type_id INT UNSIGNED 10 3

pseudo FK into civicrm_option_value.

civicrm_mailing_event_unsubscribe Table id INT UNSIGNED 10 null
civicrm_mailing_job Table parent_id INT UNSIGNED 10 null

Parent job id

civicrm_option_value_fr_CA View value VARCHAR 512 null

The actual value stored (as a foreign key) in the data record. Functions which need lookup option_value.title should use civicrm_option_value.option_group_id plus civicrm_option_value.value as the key.

civicrm_survey_en_US View last_modified_date DATETIME 19 null

Date and time that Survey was edited last time.

civicrm_contribution_product Table product_id INT UNSIGNED 10 null
civicrm_queue_item Table release_time DATETIME 19 null

date on which this job becomes available; null if ASAP

civicrm_preferences_date Table name VARCHAR 64 null

The meta name for this date (fixed in code)

civicrm_tell_friend Table general_link VARCHAR 255 null

URL for general info about the organization - included in the email sent to friends.

civicrm_custom_field Table help_pre_en_US TEXT 65535 null
civicrm_premiums_fr_CA View entity_table VARCHAR 64 null

Joins these premium settings to another object. Always civicrm_contribution_page for now.

civicrm_tell_friend Table title_en_US VARCHAR 255 null
civicrm_state_province Table abbreviation VARCHAR 4 null

2-4 Character Abbreviation of State/Province

civicrm_option_group Table description_en_US VARCHAR 255 null
civicrm_mailing_recipients Table contact_id INT UNSIGNED 10 null

FK to Contact

civicrm_contact Table do_not_phone TINYINT 3 0
civicrm_im Table is_primary TINYINT 3 0

Is this the primary IM for this contact and location.

civicrm_relationship_type_en_US View contact_sub_type_a VARCHAR 64 null

If defined, contact_sub_type_a in a relationship of this type must be a specific contact_sub_type.

civicrm_product_fr_CA View duration_unit VARCHAR 8 year
civicrm_group Table created_id INT UNSIGNED 10 null

FK to contact table.

civicrm_group_en_US View is_hidden TINYINT 3 0

Is this group hidden?

civicrm_contribution Table thankyou_date DATETIME 19 null

when (if) was donor thanked

civicrm_contact Table employer_id INT UNSIGNED 10 null

OPTIONAL FK to civicrm_contact record.

civicrm_option_value Table label_en_US VARCHAR 512 null
civicrm_contribution_page Table min_amount DECIMAL 20 null

if other amounts allowed, user can configure minimum allowed.

civicrm_event Table summary_fr_CA TEXT 65535 null
civicrm_dedupe_rule_group Table title VARCHAR 255 null

Label of the rule group

civicrm_pcp Table pcp_block_id INT UNSIGNED 10 null

The pcp block that this pcp page was created from

civicrm_campaign Table parent_id INT UNSIGNED 10 null

Optional parent id for this Campaign.

civicrm_price_field_value_en_US View is_active TINYINT 3 1

Is this price field value active

civicrm_report_instance Table drilldown_id INT UNSIGNED 10 null

FK to instance ID drilldown to

civicrm_survey_fr_CA View is_active TINYINT 3 1

Is this survey enabled or disabled/cancelled?

civicrm_event Table is_template TINYINT 3 0

whether the event has template

civicrm_custom_group Table created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this custom group

civicrm_custom_field Table data_type VARCHAR 16 null

Controls location of data storage in extended_data table.

civicrm_payment_processor Table payment_instrument_id INT UNSIGNED 10 1

Payment Instrument ID

civicrm_campaign Table last_modified_date DATETIME 19 null

Date and time that Campaign was edited last time.

civicrm_msg_template Table is_sms TINYINT 3 0

Is this message template used for sms?

civicrm_price_field_value_en_US View membership_num_terms INT UNSIGNED 10 null

Number of terms for this membership

civicrm_membership_status_en_US View start_event VARCHAR 12 null

Event when this status starts.

civicrm_dashboard_contact Table dashboard_id INT UNSIGNED 10 null

Dashboard ID

civicrm_product_en_US View name VARCHAR 255 null
civicrm_event_en_US View thankyou_footer_text TEXT 65535 null
civicrm_custom_group_en_US View created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this custom group

civicrm_custom_group_fr_CA View collapse_adv_display INT UNSIGNED 10 0

Will this group be in collapsed or expanded mode on advanced search display ?

civicrm_membership_type_fr_CA View fixed_period_rollover_day INT 10 null

For fixed period memberships, signups after this day (mmdd) rollover to next period.

civicrm_contribution_widget Table is_active TINYINT 3 null

Is this property active?

civicrm_action_schedule Table entity_status VARCHAR 64 null

Entity status

civicrm_navigation Table label VARCHAR 255 null

Navigation Title

civicrm_payment_processor_type Table payment_type INT UNSIGNED 10 1

Payment Type: Credit or Debit

civicrm_survey_en_US View recontact_interval TEXT 65535 null

Recontact intervals for each status.

civicrm_membership_block Table new_title_fr_CA VARCHAR 255 null
civicrm_component Table id INT UNSIGNED 10 null

Component ID

civicrm_uf_field_en_US View is_reserved TINYINT 3 null

Is this field reserved for use by some other CiviCRM functionality?

civicrm_domain Table locale_custom_strings TEXT 65535 null

Locale specific string overrides

civicrm_event_fr_CA View allow_selfcancelxfer TINYINT 3 0

Allow self service cancellation or transfer for event?

civicrm_mapping_field Table name VARCHAR 255 null

Mapping field key

civicrm_action_schedule Table record_activity TINYINT 3 null

Record Activity for this reminder?

civicrm_pcp_block Table link_text_en_US VARCHAR 255 null
civicrm_pledge Table modified_date DATETIME 19 null

Last updated date for this pledge record.

civicrm_payment_processor Table is_test TINYINT 3 null

Is this processor for a test site?

civicrm_mailing_component Table name VARCHAR 64 null

The name of this component

civicrm_contribution Table is_test TINYINT 3 0
civicrm_custom_field Table javascript VARCHAR 255 null

Optional scripting attributes for field.

civicrm_mailing_event_forward Table event_queue_id INT UNSIGNED 10 null

FK to EventQueue

civicrm_subscription_history Table contact_id INT UNSIGNED 10 null

Contact Id

civicrm_custom_group_en_US View is_multiple TINYINT 3 null

Does this group hold multiple values?

civicrm_recurring_entity Table parent_id INT UNSIGNED 10 null

recurring entity parent id

civicrm_survey_fr_CA View id INT UNSIGNED 10 0

Survey id.

civicrm_event Table campaign_id INT UNSIGNED 10 null

The campaign for which this event has been created.

civicrm_price_set_en_US View min_amount INT UNSIGNED 10 0

Minimum Amount required for this set.

civicrm_mailing_abtest Table mailing_id_c INT UNSIGNED 10 null

The final, general mailing (derived from A or B)

civicrm_contribution_recur Table invoice_id VARCHAR 255 null

unique invoice id, system generated or passed in

civicrm_survey Table max_number_of_contacts INT UNSIGNED 10 null

Maximum number of contacts to allow for survey.

civicrm_membership_type_fr_CA View relationship_direction VARCHAR 128 null
civicrm_relationship_type_fr_CA View label_b_a VARCHAR 64 null
civicrm_price_field_fr_CA View help_pre TEXT 65535 null
civicrm_uf_field Table label_en_US VARCHAR 255 null
civicrm_custom_field_fr_CA View filter VARCHAR 255 null

Stores Contact Get API params contact reference custom fields. May be used for other filters in the future.

civicrm_contribution_recur Table frequency_interval INT UNSIGNED 10 null

Number of time units for recurrence of payment.

civicrm_price_field_en_US View weight INT 10 1

Order in which the fields should appear

civicrm_participant Table cart_id INT UNSIGNED 10 null

FK to civicrm_event_carts

civicrm_price_set_en_US View help_post TEXT 65535 null
civicrm_email Table signature_html TEXT 65535 null

HTML formatted signature for the email.

civicrm_event_carts Table user_id INT UNSIGNED 10 null

FK to civicrm_contact who created this cart

civicrm_mailing_event_subscribe Table group_id INT UNSIGNED 10 null

FK to Group

civicrm_contact Table communication_style_id INT UNSIGNED 10 null

Communication style (e.g. formal vs. familiar) to use with this contact. FK to communication styles in civicrm_option_value.

civicrm_event_en_US View thankyou_text TEXT 65535 null
civicrm_contact Table addressee_custom VARCHAR 128 null

Custom Addressee.

civicrm_batch_fr_CA View name VARCHAR 64 null

Variable name/programmatic handle for this batch.

civicrm_membership_status_fr_CA View is_admin TINYINT 3 null

Is this status for admin/manual assignment only.

civicrm_print_label Table created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this label layout

civicrm_price_field_value Table membership_num_terms INT UNSIGNED 10 null

Number of terms for this membership

civicrm_custom_field_en_US View note_rows INT UNSIGNED 10 null

Number of rows in Note Field

civicrm_dedupe_rule_group Table used VARCHAR 12 null

Whether the rule should be used for cases where usage is Unsupervised, Supervised OR General(programatically)

civicrm_price_field_value_fr_CA View label VARCHAR 255 null
civicrm_membership_status_en_US View start_event_adjust_interval INT 10 null

Status range begins this many units from start_event.

civicrm_membership_type_en_US View auto_renew TINYINT 3 0

0 = No auto-renew option; 1 = Give option, but not required; 2 = Auto-renew required;

civicrm_campaign Table last_modified_id INT UNSIGNED 10 null

FK to civicrm_contact, who recently edited this Campaign.

civicrm_option_value_fr_CA View component_id INT UNSIGNED 10 null

Component that this option value belongs/caters to.

civicrm_custom_field_en_US View data_type VARCHAR 16 null

Controls location of data storage in extended_data table.

civicrm_contribution_page_fr_CA View campaign_id INT UNSIGNED 10 null

The campaign for which we are collecting contributions with this page.

civicrm_participant_status_type_fr_CA View visibility_id INT UNSIGNED 10 null

whether the status type is visible to the public, an implicit foreign key to option_value.value related to the visibility option_group

civicrm_survey Table thankyou_text_fr_CA TEXT 65535 null
civicrm_participant Table is_test TINYINT 3 0
civicrm_mailing_bounce_pattern Table bounce_type_id INT UNSIGNED 10 null

Type of bounce

civicrm_event Table title_fr_CA VARCHAR 255 null
civicrm_participant Table registered_by_id INT UNSIGNED 10 null

FK to Participant ID

civicrm_email Table hold_date DATETIME 19 null

When the address went on bounce hold

civicrm_event_fr_CA View currency VARCHAR 3 null

3 character string, value from config setting or input via user.

civicrm_uf_field Table help_pre_en_US TEXT 65535 null
civicrm_group_en_US View saved_search_id INT UNSIGNED 10 null

FK to saved search table.

civicrm_campaign Table start_date DATETIME 19 null

Date and time that Campaign starts.

civicrm_contact Table is_deleted TINYINT 3 0
civicrm_price_field_fr_CA View weight INT 10 1

Order in which the fields should appear

civicrm_uf_group Table is_active TINYINT 3 1

Is this form currently active? If false, hide all related fields for all sharing contexts.

civicrm_event Table thankyou_text_fr_CA TEXT 65535 null
civicrm_product_en_US View financial_type_id INT UNSIGNED 10 null

FK to Financial Type.

civicrm_uf_group_en_US View is_active TINYINT 3 1

Is this form currently active? If false, hide all related fields for all sharing contexts.

civicrm_option_value_en_US View filter INT UNSIGNED 10 null

Bitwise logic can be used to create subsets of options within an option_group for different uses.

civicrm_payment_token Table billing_last_name VARCHAR 255 null

Billing last name at the time of token creation. Useful for fraud forensics

civicrm_event Table is_show_location TINYINT 3 1

If true, show event location.

civicrm_contribution_widget Table title VARCHAR 255 null

Widget title.

civicrm_domain Table id INT UNSIGNED 10 null

Domain ID

civicrm_uf_field_fr_CA View is_required TINYINT 3 0

Is this field required when included in a user or registration form?

civicrm_event Table confirm_title_en_US VARCHAR 255 null
civicrm_action_schedule Table start_action_unit VARCHAR 8 null

Time units for reminder.

civicrm_action_schedule Table repetition_frequency_interval INT UNSIGNED 10 null

Time interval for repeating the reminder.

civicrm_event_en_US View event_full_text TEXT 65535 null
civicrm_membership_block_en_US View renewal_text TEXT 65535 null
civicrm_membership_type_en_US View receipt_text_renewal VARCHAR 255 null

Receipt Text for membership renewal

civicrm_dashboard_contact Table column_no TINYINT 3 0

column no for this widget

civicrm_entity_batch Table entity_id INT UNSIGNED 10 null

FK to entity table specified in entity_table column.

civicrm_contribution_widget Table color_main VARCHAR 10 null
civicrm_option_group_en_US View data_type VARCHAR 128 null

Data Type of Option Group.

civicrm_pledge_payment Table currency VARCHAR 3 null

3 character string, value from config setting or input via user.

civicrm_option_value_en_US View option_group_id INT UNSIGNED 10 null

Group which this option belongs to.

civicrm_contribution_page_en_US View start_date DATETIME 19 null

Date and time that this page starts.

civicrm_custom_field Table text_length INT UNSIGNED 10 null

field length if alphanumeric

civicrm_contribution_page Table is_recur TINYINT 3 0

if true - allows recurring contributions, valid only for PayPal_Standard

civicrm_event_en_US View default_discount_fee_id INT UNSIGNED 10 null

FK to civicrm_option_value.

civicrm_report_instance Table report_id VARCHAR 512 null

FK to civicrm_option_value for the report template

civicrm_custom_group_fr_CA View extends_entity_column_value VARCHAR 255 null

linking custom group for dynamic object

civicrm_option_value_fr_CA View label VARCHAR 512 null
civicrm_payment_processor_type Table title VARCHAR 127 null

Payment Processor Name.

civicrm_option_group_en_US View is_locked TINYINT 3 null

A lock to remove the ability to add new options via the UI.

civicrm_action_schedule Table id INT UNSIGNED 10 null
civicrm_contribution_widget Table color_title VARCHAR 10 null
civicrm_contact Table middle_name VARCHAR 64 null

Middle Name.

civicrm_uf_field Table field_name VARCHAR 64 null

Name for CiviCRM field which is being exposed for sharing.

civicrm_uf_match Table contact_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_participant_status_type_fr_CA View is_counted TINYINT 3 null

whether this status type is counted against event size limit

civicrm_uf_group Table is_cms_user TINYINT 3 0

Should we create a cms user for this profile

civicrm_option_value_en_US View is_optgroup TINYINT 3 0

Is this row simply a display header? Expected usage is to render these as OPTGROUP tags within a SELECT field list of options?

civicrm_event_fr_CA View initial_amount_label VARCHAR 255 null
civicrm_website Table url VARCHAR 128 null

Website

civicrm_price_field_value Table label_en_US VARCHAR 255 null
civicrm_contribution_page Table end_date DATETIME 19 null

Date and time that this page ends. May be NULL if no defined end date/time

civicrm_mapping Table mapping_type_id INT UNSIGNED 10 null

Mapping Type

civicrm_option_value_fr_CA View visibility_id INT UNSIGNED 10 null
civicrm_relationship_type_en_US View label_a_b VARCHAR 64 null
civicrm_financial_item Table financial_account_id INT UNSIGNED 10 null

FK to civicrm_financial_account

civicrm_event_fr_CA View selfcancelxfer_time INT UNSIGNED 10 0

Number of hours prior to event start date to allow self-service cancellation or transfer.

civicrm_option_group Table description_fr_CA VARCHAR 255 null
civicrm_grant Table money_transfer_date DATE 10 null

Date on which grant money transfer was made.

civicrm_membership Table end_date DATE 10 null

Current membership period expire date.

civicrm_membership_type_fr_CA View id INT UNSIGNED 10 0

Membership Id

civicrm_pledge Table financial_type_id INT UNSIGNED 10 null

FK to Financial Type

civicrm_mailing Table header_id INT UNSIGNED 10 null

FK to the header component.

civicrm_payment_token Table billing_first_name VARCHAR 255 null

Billing first name at the time of token creation. Useful for fraud forensics

civicrm_tell_friend Table thankyou_title_en_US VARCHAR 255 null
civicrm_uf_group_fr_CA View notify TEXT 65535 null
civicrm_option_group_fr_CA View id INT UNSIGNED 10 0

Option Group ID

civicrm_custom_group Table help_pre_en_US TEXT 65535 null
civicrm_timezone Table country_id INT UNSIGNED 10 null

Country Id

civicrm_survey Table title_fr_CA VARCHAR 255 null
civicrm_batch_en_US View title VARCHAR 255 null
civicrm_event Table participant_listing_id INT UNSIGNED 10 0

Should we expose the participant list? Implicit FK to civicrm_option_value where option_group = participant_listing.

civicrm_membership_type_fr_CA View period_type VARCHAR 8 null

Rolling membership period starts on signup date. Fixed membership periods start on fixed_period_start_day.

civicrm_contribution Table id INT UNSIGNED 10 null

Contribution ID

civicrm_event Table thankyou_footer_text_en_US TEXT 65535 null
civicrm_price_field Table help_post_en_US TEXT 65535 null
civicrm_address Table county_id INT UNSIGNED 10 null

Which County does this address belong to.

civicrm_premiums_product Table id INT UNSIGNED 10 null

Contribution ID

civicrm_group Table refresh_date TIMESTAMP 19 null
civicrm_uf_group Table cancel_URL VARCHAR 255 null

Redirect to URL when Cancle button clik .

civicrm_action_log Table reference_date DATE 10 null

Stores the date from the entity which triggered this reminder action (e.g. membership.end_date for most membership renewal reminders)

civicrm_price_field_value Table max_value INT UNSIGNED 10 null

Max number of participants per field options

civicrm_event_en_US View confirm_footer_text TEXT 65535 null
civicrm_menu Table is_public TINYINT 3 null

Is this menu accessible to the public?

civicrm_custom_field_fr_CA View note_rows INT UNSIGNED 10 null

Number of rows in Note Field

civicrm_survey_fr_CA View default_number_of_contacts INT UNSIGNED 10 null

Default number of contacts to allow for survey.

civicrm_contribution Table tax_amount DECIMAL 20 null

Total tax amount of this contribution.

civicrm_extension Table file VARCHAR 255 null

Primary PHP file

civicrm_state_province Table id INT UNSIGNED 10 null

State/Province ID

civicrm_activity Table location VARCHAR 255 null

Location of the activity (optional, open text).

civicrm_email Table reset_date DATETIME 19 null

When the address bounce status was last reset

civicrm_tell_friend_fr_CA View general_link VARCHAR 255 null

URL for general info about the organization - included in the email sent to friends.

civicrm_contact Table source VARCHAR 255 null

where contact come from, e.g. import, donate module insert...

civicrm_mailing Table approval_note LONGTEXT 2147483647 null

Note behind the decision.

civicrm_contribution_product Table financial_type_id INT UNSIGNED 10 null

FK to Financial Type(for membership price sets only).

civicrm_contribution Table source VARCHAR 255 null

Origin of this Contribution.

civicrm_group Table source VARCHAR 64 null

Module or process which created this group.

civicrm_case Table status_id INT UNSIGNED 10 null

Id of case status.

civicrm_option_value_fr_CA View is_optgroup TINYINT 3 0

Is this row simply a display header? Expected usage is to render these as OPTGROUP tags within a SELECT field list of options?

civicrm_group_contact Table group_id INT UNSIGNED 10 null

FK to civicrm_group

civicrm_contribution_page_en_US View min_initial_amount DECIMAL 20 null

Minimum initial amount for partial payment

civicrm_event_fr_CA View confirm_text TEXT 65535 null
civicrm_event Table id INT UNSIGNED 10 null

Event

civicrm_batch Table description_en_US TEXT 65535 null
civicrm_event_en_US View loc_block_id INT UNSIGNED 10 null

FK to Location Block ID

civicrm_mailing_abtest Table testing_criteria VARCHAR 32 null
civicrm_membership_log Table membership_type_id INT UNSIGNED 10 null

FK to Membership Type.

civicrm_line_item Table entity_id INT UNSIGNED 10 null

entry in table

civicrm_participant Table source VARCHAR 128 null

Source of this event registration.

civicrm_option_value_fr_CA View filter INT UNSIGNED 10 null

Bitwise logic can be used to create subsets of options within an option_group for different uses.

civicrm_event_en_US View initial_amount_label VARCHAR 255 null
civicrm_membership_block Table new_text_fr_CA TEXT 65535 null
civicrm_contribution_page_en_US View max_amount DECIMAL 20 null

if other amounts allowed, user can configure maximum allowed.

civicrm_contribution_page Table created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this contribution page

civicrm_discount Table end_date DATE 10 null

Date when discount ends.

civicrm_option_value_en_US View label VARCHAR 512 null
civicrm_survey Table result_id INT UNSIGNED 10 null

Used to store option group id.

civicrm_option_value Table description_fr_CA TEXT 65535 null
civicrm_event_fr_CA View dedupe_rule_group_id INT UNSIGNED 10 null

Rule to use when matching registrations for this event

civicrm_membership_type_fr_CA View member_of_contact_id INT UNSIGNED 10 null

Owner organization for this membership type. FK to Contact ID

civicrm_event_en_US View bcc_confirm VARCHAR 255 null

comma-separated list of email addresses to bcc each time a confirmation is sent

civicrm_activity Table result VARCHAR 255 null

Currently being used to store result id for survey activity, FK to option value.

civicrm_action_log Table id INT UNSIGNED 10 null
civicrm_event Table template_title_en_US VARCHAR 255 null
civicrm_membership_type Table receipt_text_renewal VARCHAR 255 null

Receipt Text for membership renewal

civicrm_contribution Table payment_instrument_id INT UNSIGNED 10 null

FK to Payment Instrument

civicrm_group Table saved_search_id INT UNSIGNED 10 null

FK to saved search table.

civicrm_premiums Table premiums_active TINYINT 3 0

Is the Premiums feature enabled for this page?

civicrm_uf_group Table is_map TINYINT 3 0

Do we want to map results from this profile.

civicrm_custom_field Table column_name VARCHAR 255 null

Name of the column that holds the values for this field.

civicrm_recurring_entity Table entity_id INT UNSIGNED 10 null

recurring entity child id

civicrm_mapping_field Table id INT UNSIGNED 10 null

Mapping Field ID

civicrm_survey_fr_CA View created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this Survey.

civicrm_custom_field_fr_CA View is_search_range TINYINT 3 0

Is this property range searchable.

civicrm_relationship_type_en_US View contact_sub_type_b VARCHAR 64 null

If defined, contact_sub_type_b in a relationship of this type must be a specific contact_sub_type.

civicrm_queue_item Table id INT UNSIGNED 10 null
civicrm_email Table is_primary TINYINT 3 0

Is this the primary?

civicrm_event_en_US View event_type_id INT UNSIGNED 10 0

Event Type ID.Implicit FK to civicrm_option_value where option_group = event_type.

civicrm_relationship_type_en_US View is_active TINYINT 3 1

Is this relationship type currently active (i.e. can be used when creating or editing relationships)?

civicrm_queue_item Table submit_time DATETIME 19 null

date on which this item was submitted to the queue

civicrm_openid Table openid VARCHAR 255 null

the OpenID (or OpenID-style http://username.domain/) unique identifier for this contact mainly used for logging in to CiviCRM

civicrm_price_field_value Table description_en_US TEXT 65535 null
civicrm_contribution_recur Table modified_date DATETIME 19 null

Last updated date for this record. mostly the last time a payment was received

civicrm_sms_provider Table id INT UNSIGNED 10 null

SMS Provider ID

civicrm_uf_group Table created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this UF group

civicrm_contact_type_en_US View description TEXT 65535 null
civicrm_mailing_group Table entity_table VARCHAR 64 null

Name of table where item being referenced is stored.

civicrm_address Table geo_code_2 DOUBLE 22 null

Longitude

civicrm_payment_processor Table name VARCHAR 64 null

Payment Processor Name.

civicrm_payment_processor Table payment_type INT UNSIGNED 10 1

Payment Type: Credit or Debit

civicrm_custom_field_en_US View custom_group_id INT UNSIGNED 10 null

FK to civicrm_custom_group.

civicrm_price_field Table is_required TINYINT 3 1

Is this price field required (value must be > 1)

civicrm_mailing_event_confirm Table event_subscribe_id INT UNSIGNED 10 null

FK to civicrm_mailing_event_subscribe

civicrm_acl_entity_role Table is_active TINYINT 3 null

Is this property active?

civicrm_mailing_event_unsubscribe Table time_stamp DATETIME 19 null

When this delivery event occurred.

civicrm_action_schedule Table end_action VARCHAR 32 null

Reminder Action till repeating the reminder.

civicrm_contribution_page_fr_CA View is_billing_required TINYINT 3 0

Billing block required for Contribution Page

civicrm_event Table requires_approval TINYINT 3 null

Whether participants require approval before they can finish registering.

civicrm_email Table is_bulkmail TINYINT 3 0

Is this address for bulk mail ?

civicrm_contribution_page Table is_email_receipt TINYINT 3 0

if true, receipt is automatically emailed to contact on success

civicrm_price_field_value Table help_pre_fr_CA TEXT 65535 null

Price field option pre help text.

civicrm_price_set Table title_en_US VARCHAR 255 null
civicrm_contribution_page Table currency VARCHAR 3 null

3 character string, value from config setting or input via user.

civicrm_membership_status Table label_en_US VARCHAR 128 null
civicrm_payment_processor Table url_recur VARCHAR 255 null
civicrm_custom_field_fr_CA View in_selector TINYINT 3 0

Should the multi-record custom field values be displayed in tab table listing

civicrm_location_type_en_US View name VARCHAR 64 null

Location Type Name.

civicrm_batch Table type_id INT UNSIGNED 10 null

fk to Batch Type options in civicrm_option_values

civicrm_event_en_US View currency VARCHAR 3 null

3 character string, value from config setting or input via user.

civicrm_print_label Table id INT UNSIGNED 10 null
civicrm_mapping_field Table column_number INT UNSIGNED 10 null

Column number for mapping set

civicrm_pcp_block_fr_CA View id INT UNSIGNED 10 0

PCP block Id

civicrm_event_en_US View selfcancelxfer_time INT UNSIGNED 10 0

Number of hours prior to event start date to allow self-service cancellation or transfer.

civicrm_address Table postal_code_suffix VARCHAR 12 null

Store the suffix, like the +4 part in the USPS system.

civicrm_pledge_block Table entity_id INT UNSIGNED 10 null

FK to entity table specified in entity_table column.

civicrm_msg_template Table msg_html LONGTEXT 2147483647 null

HTML formatted message

civicrm_price_set Table financial_type_id INT UNSIGNED 10 null

FK to Financial Type(for membership price sets only).

civicrm_price_field_en_US View is_display_amounts TINYINT 3 1

Should the price be displayed next to the label for each option?

civicrm_payment_token Table created_date TIMESTAMP 19 CURRENT_TIMESTAMP

Date created

civicrm_mailing Table created_id INT UNSIGNED 10 null

FK to Contact ID who first created this mailing

civicrm_pcp Table page_text TEXT 65535 null
civicrm_uf_group Table help_pre_fr_CA TEXT 65535 null
civicrm_mailing_trackable_url Table url TEXT 65535 null

The URL to be tracked.

civicrm_price_field_fr_CA View is_active TINYINT 3 1

Is this price field active

civicrm_membership_block Table is_separate_payment TINYINT 3 1

Should membership transactions be processed separately

civicrm_extension Table id INT UNSIGNED 10 null

Local Extension ID

civicrm_group_fr_CA View select_tables TEXT 65535 null

the tables to be included in a select data

civicrm_product Table id INT UNSIGNED 10 null
civicrm_pcp_block_en_US View is_active TINYINT 3 1

Is Personal Campaign Page Block enabled/active?

civicrm_mailing_event_queue Table email_id INT UNSIGNED 10 null

FK to Email

civicrm_membership_block_fr_CA View renewal_title VARCHAR 255 null
civicrm_email Table on_hold TINYINT 3 0

Is this address on bounce hold?

civicrm_financial_item Table entity_id INT UNSIGNED 10 null

The specific source item that is responsible for the creation of this financial_item

civicrm_persistent Table data LONGTEXT 2147483647 null

data associated with name

civicrm_contribution_page Table intro_text_en_US TEXT 65535 null
civicrm_group_nesting Table child_group_id INT UNSIGNED 10 null

ID of the child group

civicrm_premiums Table premiums_contact_phone VARCHAR 50 null

This phone number is included in receipts if it is populated and a premium has been selected.

civicrm_product Table price DECIMAL 20 null

Sell price or market value for premiums. For tax-deductible contributions, this will be stored as non_deductible_amount in the contribution record.

civicrm_survey_en_US View created_date DATETIME 19 null

Date and time that Survey was created.

civicrm_contribution Table creditnote_id VARCHAR 255 null

unique credit note id, system generated or passed in

civicrm_batch_en_US View data LONGTEXT 2147483647 null

cache entered data

civicrm_contribution_product Table id INT UNSIGNED 10 null
civicrm_uf_group_en_US View created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this UF group

civicrm_uf_field_en_US View field_name VARCHAR 64 null

Name for CiviCRM field which is being exposed for sharing.

civicrm_contribution_widget Table color_homepage_link VARCHAR 10 null
civicrm_batch Table data LONGTEXT 2147483647 null

cache entered data

civicrm_action_schedule Table filter_contact_language VARCHAR 128 null

Used for multilingual installation

civicrm_relationship_type Table contact_sub_type_b VARCHAR 64 null

If defined, contact_sub_type_b in a relationship of this type must be a specific contact_sub_type.

civicrm_custom_field_en_US View time_format INT UNSIGNED 10 null

time format for custom date

civicrm_event Table thankyou_title_en_US VARCHAR 255 null
civicrm_uf_join Table module VARCHAR 64 null

Module which owns this uf_join instance, e.g. User Registration, CiviDonate, etc.

civicrm_contribution_page_fr_CA View amount_block_is_active TINYINT 3 1

Is this property active?

civicrm_event Table is_map TINYINT 3 0

Include a map block on the Event Information page when geocode info is available and a mapping provider has been specified?

civicrm_setting Table value TEXT 65535 null

data associated with this group / name combo

civicrm_event_fr_CA View expiration_time INT UNSIGNED 10 null

Expire pending but unconfirmed registrations after this many hours.

civicrm_action_schedule Table is_active TINYINT 3 1

Is this option active?

civicrm_contribution_page_fr_CA View min_initial_amount DECIMAL 20 null

Minimum initial amount for partial payment

civicrm_financial_trxn Table card_type_id INT UNSIGNED 10 null

FK to accept_creditcard option group values

civicrm_custom_group_fr_CA View min_multiple INT UNSIGNED 10 null

minimum number of multiple records (typically 0?)

civicrm_group_fr_CA View where_clause TEXT 65535 null

the sql where clause if a saved search acl

civicrm_membership_status_fr_CA View label VARCHAR 128 null
civicrm_pledge_payment Table scheduled_amount DECIMAL 20 null

Pledged amount for this payment (the actual contribution amount might be different).

civicrm_address Table manual_geo_code TINYINT 3 0

Is this a manually entered geo code

civicrm_contribution_page Table max_amount DECIMAL 20 null

if other amounts allowed, user can configure maximum allowed.

civicrm_group_fr_CA View is_active TINYINT 3 null

Is this entry active?

civicrm_event_en_US View min_initial_amount DECIMAL 20 null

Minimum initial amount for partial payment

civicrm_group Table parents TEXT 65535 null

IDs of the parent(s)

civicrm_membership_status Table is_admin TINYINT 3 null

Is this status for admin/manual assignment only.

civicrm_contribution_page Table thankyou_title_en_US VARCHAR 255 null
civicrm_event_fr_CA View is_pay_later TINYINT 3 0

if true - allows the user to send payment directly to the org later

civicrm_membership_status_fr_CA View end_event_adjust_interval INT 10 null

Status range ends this many units from end_event.

civicrm_report_instance Table email_to TEXT 65535 null

comma-separated list of email addresses to send the report to

civicrm_payment_token Table masked_account_number VARCHAR 255 null

Holds the part of the card number or account details that may be retained or displayed

civicrm_event_fr_CA View max_additional_participants INT UNSIGNED 10 0

Maximum number of additional participants that can be registered on a single booking

civicrm_membership_block Table renewal_text_fr_CA TEXT 65535 null
civicrm_group_en_US View source VARCHAR 64 null

Module or process which created this group.

civicrm_payment_token Table created_id INT UNSIGNED 10 null

Contact ID of token creator

civicrm_uf_field_en_US View visibility VARCHAR 32 User and User Admin Only

In what context(s) is this field visible.

civicrm_custom_group Table title_fr_CA VARCHAR 64 null
civicrm_contribution_page_fr_CA View cc_receipt VARCHAR 255 null

comma-separated list of email addresses to cc each time a receipt is sent

civicrm_contact Table preferred_communication_method VARCHAR 255 null

What is the preferred mode of communication.

civicrm_print_label Table name VARCHAR 255 null

variable name/programmatic handle for this field.

civicrm_uf_join Table uf_group_id INT UNSIGNED 10 null

Which form does this field belong to.

civicrm_entity_file Table entity_id INT UNSIGNED 10 null

FK to entity table specified in entity_table column.

civicrm_custom_group Table is_reserved TINYINT 3 0

Is this a reserved Custom Group?

civicrm_participant_status_type Table is_active TINYINT 3 1

whether this status type is active

civicrm_uf_group_fr_CA View is_active TINYINT 3 1

Is this form currently active? If false, hide all related fields for all sharing contexts.

civicrm_participant_status_type Table name VARCHAR 64 null

non-localized name of the status type

civicrm_domain Table version VARCHAR 32 null

The civicrm version this instance is running

civicrm_group_contact_cache Table group_id INT UNSIGNED 10 null

FK to civicrm_group

civicrm_campaign Table external_identifier VARCHAR 32 null

Unique trusted external ID (generally from a legacy app/datasource). Particularly useful for deduping operations.

civicrm_batch Table exported_date DATETIME 19 null
civicrm_tag Table description VARCHAR 255 null

Optional verbose description of the tag.

civicrm_premiums_fr_CA View premiums_nothankyou_label VARCHAR 255 null
civicrm_membership_type_fr_CA View domain_id INT UNSIGNED 10 null

Which Domain is this match entry for

civicrm_custom_group Table collapse_display INT UNSIGNED 10 0

Will this group be in collapsed or expanded mode on initial display ?

civicrm_pledge_payment Table actual_amount DECIMAL 20 null

Actual amount that is paid as the Pledged installment amount.

civicrm_survey_fr_CA View title VARCHAR 255 null
civicrm_membership_type_en_US View id INT UNSIGNED 10 0

Membership Id

civicrm_currency Table symbol VARCHAR 8 null

Currency Symbol

civicrm_financial_account Table is_header_account TINYINT 3 0

Is this a header account which does not allow transactions to be posted against it directly, but only to its sub-accounts?

civicrm_price_field_fr_CA View html_type VARCHAR 12 null
civicrm_contribution_page Table pay_later_receipt_en_US TEXT 65535 null
civicrm_contribution_page Table default_amount_id INT UNSIGNED 10 null

FK to civicrm_option_value.

civicrm_membership_status_fr_CA View end_event VARCHAR 12 null

Event after which this status ends.

civicrm_membership_block_en_US View membership_types VARCHAR 1024 null

Membership types to be exposed by this block.

civicrm_entity_financial_account Table entity_table VARCHAR 64 null

Links to an entity_table like civicrm_financial_type

civicrm_option_value_en_US View grouping VARCHAR 255 null

Use to sort and/or set display properties for sub-set(s) of options within an option group. EXAMPLE: Use for college_interest field, to differentiate partners from non-partners.

civicrm_product Table currency VARCHAR 3 null

3 character string, value from config setting or input via user.

civicrm_uf_group_en_US View group_type VARCHAR 255 null

This column will store a comma separated list of the type(s) of profile fields.

civicrm_event_en_US View summary TEXT 65535 null
civicrm_uf_group_fr_CA View is_proximity_search TINYINT 3 0

Should we include proximity search feature in this profile search form?

civicrm_case_type Table title_en_US VARCHAR 64 null
civicrm_pledge_payment Table scheduled_date DATETIME 19 null

The date the pledge payment is supposed to happen.

civicrm_contribution_page Table recur_frequency_unit VARCHAR 128 null

Supported recurring frequency units.

civicrm_address Table state_province_id INT UNSIGNED 10 null

Which State_Province does this address belong to.

civicrm_relationship_type Table contact_type_b VARCHAR 12 null

If defined, contact_b in a relationship of this type must be a specific contact_type.

civicrm_event_fr_CA View registration_link_text VARCHAR 255 null
civicrm_contact Table email_greeting_custom VARCHAR 128 null

Custom Email Greeting.

civicrm_dashboard Table permission_operator VARCHAR 3 null

Permission Operator

civicrm_custom_field_en_US View id INT UNSIGNED 10 0

Unique Custom Field ID

civicrm_custom_field_en_US View filter VARCHAR 255 null

Stores Contact Get API params contact reference custom fields. May be used for other filters in the future.

civicrm_event Table is_multiple_registrations TINYINT 3 0

if true - allows the user to register multiple participants for event

civicrm_action_schedule Table absolute_date DATE 10 null

Date on which the reminder be sent.

civicrm_price_set Table extends VARCHAR 255 null

What components are using this price set?

civicrm_event Table approval_req_text_en_US TEXT 65535 null
civicrm_contribution_product Table product_option VARCHAR 255 null

Option value selected if applicable - e.g. color, size etc.

civicrm_survey Table bypass_confirm TINYINT 3 0

Bypass the email verification.

civicrm_navigation Table permission VARCHAR 255 null

Permission for menu item

civicrm_mailing_bounce_type Table hold_threshold INT UNSIGNED 10 null

Number of bounces of this type required before the email address is put on bounce hold

civicrm_custom_group_fr_CA View name VARCHAR 64 null

Variable name/programmatic handle for this group.

civicrm_acl_cache Table modified_date TIMESTAMP 19 null
civicrm_case_type Table description_fr_CA VARCHAR 255 null
civicrm_tell_friend Table entity_table VARCHAR 64 null

Name of table where item being referenced is stored.

civicrm_contribution_page Table title_fr_CA VARCHAR 255 null
civicrm_mapping_field Table website_type_id INT UNSIGNED 10 null

Which type of website does this site belong

civicrm_membership_type Table duration_unit VARCHAR 8 null

Unit in which membership period is expressed.

civicrm_contact_type_en_US View label VARCHAR 64 null
civicrm_currency Table name VARCHAR 64 null

Currency Name

civicrm_participant_payment Table participant_id INT UNSIGNED 10 null

Participant Id (FK)

civicrm_option_value Table grouping VARCHAR 255 null

Use to sort and/or set display properties for sub-set(s) of options within an option group. EXAMPLE: Use for college_interest field, to differentiate partners from non-partners.

civicrm_dashboard_en_US View permission_operator VARCHAR 3 null

Permission Operator

civicrm_entity_financial_account Table account_relationship INT UNSIGNED 10 null

FK to a new civicrm_option_value (account_relationship)

civicrm_cache Table created_date DATETIME 19 null

When was the cache item created

civicrm_contribution_page_fr_CA View intro_text TEXT 65535 null
civicrm_event_fr_CA View parent_event_id INT UNSIGNED 10 null

Implicit FK to civicrm_event: parent event

civicrm_payment_processor Table url_api VARCHAR 255 null
civicrm_note Table privacy VARCHAR 255 null

Foreign Key to Note Privacy Level (which is an option value pair and hence an implicit FK)

civicrm_sms_provider Table api_url VARCHAR 128 null
civicrm_membership_log Table modified_id INT UNSIGNED 10 null

FK to Contact ID of person under whose credentials this data modification was made.

civicrm_dedupe_rule Table rule_field VARCHAR 64 null

The name of the field of the table referenced in rule_table

civicrm_mailing_event_bounce Table id INT UNSIGNED 10 null
civicrm_price_field_fr_CA View active_on DATETIME 19 null

If non-zero, do not show this field before the date specified

civicrm_event_fr_CA View is_email_confirm TINYINT 3 0

If true, confirmation is automatically emailed to contact on successful registration.

civicrm_uf_field_fr_CA View help_pre TEXT 65535 null
civicrm_participant_status_type_fr_CA View id INT UNSIGNED 10 0

unique participant status type id

civicrm_address Table street_number_predirectional VARCHAR 8 null

Directional prefix, e.g. SE Main St, SE is the prefix.

civicrm_contribution Table is_pay_later TINYINT 3 0
civicrm_event Table fee_label_en_US VARCHAR 255 null
civicrm_contribution_page_en_US View is_partial_payment TINYINT 3 0

is partial payment enabled for this online contribution page

civicrm_membership_status_fr_CA View is_current_member TINYINT 3 null

Does this status aggregate to current members (e.g. New, Renewed, Grace might all be TRUE... while Unrenewed, Lapsed, Inactive would be FALSE).

civicrm_activity Table priority_id INT UNSIGNED 10 null

ID of the priority given to this activity. Foreign key to civicrm_option_value.

civicrm_contribution_soft Table id INT UNSIGNED 10 null

Soft Contribution ID

civicrm_event_fr_CA View is_public TINYINT 3 1

Public events will be included in the iCal feeds. Access to private event information may be limited using ACLs.

civicrm_msg_template Table msg_subject TEXT 65535 null

Subject for email message.

civicrm_event Table is_online_registration TINYINT 3 0

If true, include registration link on Event Info page.

civicrm_batch_en_US View mode_id INT UNSIGNED 10 null

fk to Batch mode options in civicrm_option_values

civicrm_pcp_block Table notify_email VARCHAR 255 null

If set, notification is automatically emailed to this email-address on create/update Personal Campaign Page

civicrm_product Table sku VARCHAR 50 null

Optional product sku or code.

civicrm_prevnext_cache Table entity_id1 INT UNSIGNED 10 null

FK to entity table specified in entity_table column.

civicrm_custom_field_en_US View in_selector TINYINT 3 0

Should the multi-record custom field values be displayed in tab table listing

civicrm_batch_fr_CA View saved_search_id INT UNSIGNED 10 null

FK to Saved Search ID

civicrm_mailing_recipients Table mailing_id INT UNSIGNED 10 null

The ID of the mailing this Job will send.

civicrm_event_fr_CA View event_type_id INT UNSIGNED 10 0

Event Type ID.Implicit FK to civicrm_option_value where option_group = event_type.

civicrm_relationship Table case_id INT UNSIGNED 10 null

FK to civicrm_case

civicrm_contribution_recur Table financial_type_id INT UNSIGNED 10 null

FK to Financial Type

civicrm_custom_group_fr_CA View max_multiple INT UNSIGNED 10 null

maximum number of multiple records, if 0 - no max

civicrm_event_en_US View is_online_registration TINYINT 3 0

If true, include registration link on Event Info page.

civicrm_event_en_US View confirm_email_text TEXT 65535 null
civicrm_dashboard Table label_en_US VARCHAR 255 null
civicrm_pcp Table page_id INT UNSIGNED 10 null

The Contribution or Event Page which triggered this pcp

civicrm_option_group_fr_CA View is_reserved TINYINT 3 1

Is this a predefined system option group (i.e. it can not be deleted)?

civicrm_custom_field Table is_search_range TINYINT 3 0

Is this property range searchable.

civicrm_mailing_trackable_url Table mailing_id INT UNSIGNED 10 null

FK to the mailing

civicrm_campaign Table description TEXT 65535 null

Full description of Campaign.

civicrm_price_field_value_en_US View count INT UNSIGNED 10 null

Number of participants per field option

civicrm_uf_group_fr_CA View created_date DATETIME 19 null

Date and time this UF group was created.

civicrm_financial_type Table is_deductible TINYINT 3 1

Is this financial type tax-deductible? If true, contributions of this type may be fully OR partially deductible - non-deductible amount is stored in the Contribution record.

civicrm_contribution_page_fr_CA View max_amount DECIMAL 20 null

if other amounts allowed, user can configure maximum allowed.

civicrm_event_fr_CA View template_title VARCHAR 255 null
civicrm_price_field_value Table help_post_fr_CA TEXT 65535 null

Price field option post help text.

civicrm_contact_type_en_US View id INT UNSIGNED 10 0

Contact Type ID

civicrm_group Table where_tables TEXT 65535 null

the tables to be included in the count statement

civicrm_event_fr_CA View is_partial_payment TINYINT 3 0

is partial payment enabled for this event

civicrm_financial_trxn Table payment_processor_id INT UNSIGNED 10 null

Payment Processor for this financial transaction

civicrm_price_field_value_en_US View name VARCHAR 255 null

Price field option name

civicrm_pcp_block_fr_CA View owner_notify_id INT 10 null

FK to option_value where option_group = pcp_owner_notification

civicrm_grant Table grant_report_received TINYINT 3 null

Yes/No field stating whether grant report was received by donor.

civicrm_price_field_value Table count INT UNSIGNED 10 null

Number of participants per field option

civicrm_event_fr_CA View is_active TINYINT 3 0

Is this Event enabled or disabled/cancelled?

civicrm_system_log Table level VARCHAR 9 info

error level per PSR3

civicrm_membership_status Table end_event_adjust_unit VARCHAR 8 null

Unit used for adjusting from the ending event.

civicrm_mailing_event_forward Table time_stamp DATETIME 19 null

When this forward event occurred.

civicrm_contribution Table contribution_status_id INT UNSIGNED 10 1
civicrm_address Table usps_adc VARCHAR 32 null

USPS Bulk mailing code.

civicrm_uf_field_en_US View help_pre TEXT 65535 null
civicrm_word_replacement Table id INT UNSIGNED 10 null

Word replacement ID

civicrm_contribution_page Table initial_amount_help_text_en_US TEXT 65535 null
civicrm_mailing_event_confirm Table id INT UNSIGNED 10 null
civicrm_survey Table recontact_interval TEXT 65535 null

Recontact intervals for each status.

civicrm_action_schedule Table end_frequency_unit VARCHAR 8 null

Time units till repetition of reminder.

civicrm_option_value Table is_optgroup TINYINT 3 0

Is this row simply a display header? Expected usage is to render these as OPTGROUP tags within a SELECT field list of options?

civicrm_dashboard_fr_CA View name VARCHAR 64 null

Internal name of dashlet.

civicrm_custom_group_en_US View max_multiple INT UNSIGNED 10 null

maximum number of multiple records, if 0 - no max

civicrm_dashboard Table permission VARCHAR 255 null

Permission for the dashlet

civicrm_survey Table thankyou_title_en_US VARCHAR 255 null
civicrm_participant Table register_date DATETIME 19 null

When did contact register for event?

civicrm_custom_group_fr_CA View weight INT 10 1

Controls display order when multiple extended property groups are setup for the same class.

civicrm_event_fr_CA View confirm_title VARCHAR 255 null
civicrm_membership Table membership_type_id INT UNSIGNED 10 null

FK to Membership Type

civicrm_contribution_recur Table failure_count INT UNSIGNED 10 0

Number of failed charge attempts since last success. Business rule could be set to deactivate on more than x failures.

civicrm_campaign Table end_date DATETIME 19 null

Date and time that Campaign ends.

civicrm_price_set_en_US View javascript VARCHAR 64 null

Optional Javascript script function(s) included on the form with this price_set. Can be used for conditional

civicrm_event_fr_CA View requires_approval TINYINT 3 null

Whether participants require approval before they can finish registering.

civicrm_event_fr_CA View is_billing_required TINYINT 3 0

Billing block required for Event

civicrm_openid Table allowed_to_login TINYINT 3 0

Whether or not this user is allowed to login

civicrm_pledge_block Table max_reminders INT UNSIGNED 10 1

The maximum number of payment reminders to send for any given payment.

civicrm_pcp_block_fr_CA View is_tellfriend_enabled TINYINT 3 null

Does Personal Campaign Page allow using tell a friend?

civicrm_premiums_fr_CA View id INT UNSIGNED 10 0
civicrm_contribution Table contact_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_mailing_event_unsubscribe Table event_queue_id INT UNSIGNED 10 null

FK to EventQueue

civicrm_group_fr_CA View name VARCHAR 64 null

Internal name of Group.

civicrm_premiums Table premiums_intro_text_en_US TEXT 65535 null
civicrm_event_fr_CA View registration_start_date DATETIME 19 null

Date and time that online registration starts.

civicrm_payment_token Table token VARCHAR 255 null

Externally provided token string

civicrm_price_set_fr_CA View is_quick_config TINYINT 3 0

Is set if edited on Contribution or Event Page rather than through Manage Price Sets

civicrm_job Table is_active TINYINT 3 null

Is this job active?

civicrm_option_value_en_US View id INT UNSIGNED 10 0

Option ID

civicrm_navigation Table domain_id INT UNSIGNED 10 null

Which Domain is this navigation item for

civicrm_event_fr_CA View summary TEXT 65535 null
civicrm_product Table image VARCHAR 255 null

Full or relative URL to uploaded image - fullsize.

civicrm_relationship Table is_active TINYINT 3 1

is the relationship active ?

civicrm_relationship Table relationship_type_id INT UNSIGNED 10 null

id of the relationship

civicrm_membership_status Table is_reserved TINYINT 3 0

Is this membership_status reserved.

civicrm_contribution_recur Table start_date DATETIME 19 null

The date the first scheduled recurring contribution occurs.

civicrm_payment_processor Table is_recur TINYINT 3 null

Can process recurring contributions

civicrm_option_value_fr_CA View id INT UNSIGNED 10 0

Option ID

civicrm_contribution_page Table is_monetary TINYINT 3 1

if true - allows real-time monetary transactions otherwise non-monetary transactions

civicrm_msg_template Table pdf_format_id INT UNSIGNED 10 null

a pseudo-FK to civicrm_option_value containing PDF Page Format.

civicrm_custom_field Table in_selector TINYINT 3 0

Should the multi-record custom field values be displayed in tab table listing

civicrm_custom_field_fr_CA View is_view TINYINT 3 null

Is this property set by PHP Code? A code field is viewable but not editable

civicrm_custom_field_fr_CA View text_length INT UNSIGNED 10 null

field length if alphanumeric

civicrm_group_fr_CA View is_reserved TINYINT 3 0
civicrm_note Table entity_table VARCHAR 64 null

Name of table where item being referenced is stored.

civicrm_batch_fr_CA View description TEXT 65535 null
civicrm_custom_group_en_US View collapse_display INT UNSIGNED 10 0

Will this group be in collapsed or expanded mode on initial display ?

civicrm_uf_field_fr_CA View in_selector TINYINT 3 0

Is this field included as a column in the selector table?

civicrm_event Table has_waitlist TINYINT 3 null

Whether the event has waitlist support.

civicrm_membership_block_fr_CA View is_required TINYINT 3 0

Is membership sign up optional

civicrm_relationship_type_en_US View contact_type_a VARCHAR 12 null

If defined, contact_a in a relationship of this type must be a specific contact_type.

civicrm_membership Table campaign_id INT UNSIGNED 10 null

The campaign for which this membership is attached.

civicrm_dedupe_rule Table dedupe_rule_group_id INT UNSIGNED 10 null

The id of the rule group this rule belongs to

civicrm_price_field_value_fr_CA View visibility_id INT UNSIGNED 10 1

Implicit FK to civicrm_option_group with name = 'visibility'

civicrm_campaign Table is_active TINYINT 3 1

Is this Campaign enabled or disabled/cancelled?

civicrm_dashboard Table is_reserved TINYINT 3 0

Is this dashlet reserved?

civicrm_file Table description VARCHAR 255 null

Additional descriptive text regarding this attachment (optional).

civicrm_price_field_value Table weight INT 10 1

Order in which the field options should appear

civicrm_custom_field Table end_date_years INT 10 null

Date may be up to end_date_years years after the current date.

civicrm_dashboard_fr_CA View label VARCHAR 255 null
civicrm_batch_en_US View description TEXT 65535 null
civicrm_event_en_US View is_show_location TINYINT 3 1

If true, show event location.

civicrm_product_en_US View options TEXT 65535 null
civicrm_price_field_en_US View id INT UNSIGNED 10 0

Price Field

civicrm_event_fr_CA View thankyou_title VARCHAR 255 null
civicrm_option_value_en_US View description TEXT 65535 null
civicrm_contribution_page_en_US View campaign_id INT UNSIGNED 10 null

The campaign for which we are collecting contributions with this page.

civicrm_report_instance Table header TEXT 65535 null

comma-separated list of email addresses to send the report to

civicrm_entity_tag Table tag_id INT UNSIGNED 10 null

FK to civicrm_tag

civicrm_custom_field_fr_CA View id INT UNSIGNED 10 0

Unique Custom Field ID

civicrm_group_contact Table status VARCHAR 8 null

status of contact relative to membership in group

civicrm_custom_group_fr_CA View id INT UNSIGNED 10 0

Unique Custom Group ID

civicrm_membership_status_fr_CA View is_active TINYINT 3 1

Is this membership_status enabled.

civicrm_mail_settings Table name VARCHAR 255 null

name of this group of settings

civicrm_event Table currency VARCHAR 3 null

3 character string, value from config setting or input via user.

civicrm_uf_group Table is_update_dupe TINYINT 3 0

Should we update the contact record if we find a duplicate

civicrm_recurring_entity Table id INT UNSIGNED 10 null

primary key

civicrm_product_fr_CA View image VARCHAR 255 null

Full or relative URL to uploaded image - fullsize.

civicrm_prevnext_cache Table entity_table VARCHAR 64 null

physical tablename for entity being joined to discount, e.g. civicrm_event

civicrm_email Table id INT UNSIGNED 10 null

Unique Email ID

civicrm_membership_type_en_US View duration_unit VARCHAR 8 null

Unit in which membership period is expressed.

civicrm_price_field_value_en_US View id INT UNSIGNED 10 0

Price Field Value

civicrm_case_activity Table id INT UNSIGNED 10 null

Unique case-activity association id

civicrm_uf_group Table submit_button_text_en_US VARCHAR 64 null

Custom Text to display on the submit button on profile edit/create screens

civicrm_group Table visibility VARCHAR 24 User and User Admin Only

In what context(s) is this field visible.

civicrm_im Table contact_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_mailing_job Table mailing_id INT UNSIGNED 10 null

The ID of the mailing this Job will send.

civicrm_participant Table discount_id INT UNSIGNED 10 null

FK to Discount ID

civicrm_relationship_type Table is_active TINYINT 3 1

Is this relationship type currently active (i.e. can be used when creating or editing relationships)?

civicrm_activity Table campaign_id INT UNSIGNED 10 null

The campaign for which this activity has been triggered.

civicrm_membership_status_en_US View start_event_adjust_unit VARCHAR 8 null

Unit used for adjusting from start_event.

civicrm_navigation Table parent_id INT UNSIGNED 10 null

Parent navigation item, used for grouping

civicrm_pledge Table contribution_page_id INT UNSIGNED 10 null

The Contribution Page which triggered this contribution

civicrm_custom_field_fr_CA View time_format INT UNSIGNED 10 null

time format for custom date

civicrm_custom_field_en_US View column_name VARCHAR 255 null

Name of the column that holds the values for this field.

civicrm_mailing Table scheduled_id INT UNSIGNED 10 null

FK to Contact ID who scheduled this mailing

civicrm_country Table id INT UNSIGNED 10 null

Country Id

civicrm_custom_group_fr_CA View table_name VARCHAR 255 null

Name of the table that holds the values for this group.

civicrm_phone Table is_billing TINYINT 3 0

Is this the billing?

civicrm_uf_group_en_US View is_cms_user TINYINT 3 0

Should we create a cms user for this profile

civicrm_contribution_page_en_US View payment_processor VARCHAR 128 null

Payment Processors configured for this contribution Page

civicrm_menu Table weight INT 10 1

Ordering of the menu items in various blocks.

civicrm_product_fr_CA View frequency_interval INT 10 null

Number of units for delivery frequency of subscription, service, membership (e.g. every 3 Months).

civicrm_campaign_group Table group_type VARCHAR 8 null

Type of Group.

civicrm_contribution_page Table is_confirm_enabled TINYINT 3 1

if false, the confirm page in contribution pages gets skipped

civicrm_event Table title_en_US VARCHAR 255 null
civicrm_mailing Table approval_status_id INT UNSIGNED 10 null

The status of this mailing. Values: none, approved, rejected

civicrm_price_field_fr_CA View is_enter_qty TINYINT 3 0

Enter a quantity for this field?

civicrm_loc_block Table im_2_id INT UNSIGNED 10 null
civicrm_log Table entity_id INT UNSIGNED 10 null

Foreign key to the referenced item.

civicrm_event_fr_CA View end_date DATETIME 19 null

Date and time that event ends. May be NULL if no defined end date/time

civicrm_participant_status_type Table id INT UNSIGNED 10 null

unique participant status type id

civicrm_saved_search Table where_tables TEXT 65535 null

the tables to be included in the count statement

civicrm_cxn Table modified_date TIMESTAMP 19 CURRENT_TIMESTAMP

When the connection was created or modified.

civicrm_tell_friend Table title_fr_CA VARCHAR 255 null
civicrm_uf_join Table entity_id INT UNSIGNED 10 null

Foreign key to the referenced item.

civicrm_action_schedule Table repetition_frequency_unit VARCHAR 8 null

Time units for repetition of reminder.

civicrm_price_field_fr_CA View is_display_amounts TINYINT 3 1

Should the price be displayed next to the label for each option?

civicrm_product_fr_CA View financial_type_id INT UNSIGNED 10 null

FK to Financial Type.

civicrm_report_instance Table permission VARCHAR 255 null

permission required to be able to run this instance

civicrm_price_field_value_en_US View financial_type_id INT UNSIGNED 10 null

FK to Financial Type.

civicrm_membership_status Table start_event_adjust_interval INT 10 null

Status range begins this many units from start_event.

civicrm_uf_group_en_US View post_URL VARCHAR 255 null

Redirect to URL.

civicrm_custom_group Table style VARCHAR 15 null

Visual relationship between this form and its parent.

civicrm_pledge_block Table id INT UNSIGNED 10 null

Pledge ID

civicrm_membership_block_en_US View display_min_fee TINYINT 3 1

Display minimum membership fee

civicrm_custom_group Table is_active TINYINT 3 null

Is this property active?

civicrm_report_instance Table description VARCHAR 255 null

Report Instance description.

civicrm_event Table loc_block_id INT UNSIGNED 10 null

FK to Location Block ID

civicrm_premiums_fr_CA View premiums_active TINYINT 3 0

Is the Premiums feature enabled for this page?

civicrm_membership_payment Table contribution_id INT UNSIGNED 10 null

FK to contribution table.

civicrm_option_value Table label_fr_CA VARCHAR 512 null
civicrm_group_en_US View is_reserved TINYINT 3 0
civicrm_event Table pay_later_text_en_US TEXT 65535 null
civicrm_custom_group_fr_CA View title VARCHAR 64 null
civicrm_setting Table domain_id INT UNSIGNED 10 null

Which Domain is this menu item for

civicrm_financial_trxn Table pan_truncation VARCHAR 4 null

Last 4 digits of credit card

civicrm_navigation Table id INT UNSIGNED 10 null
civicrm_option_group_en_US View description VARCHAR 255 null
civicrm_address Table geo_code_1 DOUBLE 22 null

Latitude

civicrm_event_en_US View registration_link_text VARCHAR 255 null
civicrm_event_en_US View has_waitlist TINYINT 3 null

Whether the event has waitlist support.

civicrm_contact_type Table name VARCHAR 64 null

Internal name of Contact Type (or Subtype).

civicrm_contact Table is_opt_out TINYINT 3 0

Has the contact opted out from receiving all bulk email from the organization or site domain?

civicrm_dedupe_rule_group Table contact_type VARCHAR 12 null

The type of contacts this group applies to

civicrm_entity_tag Table id INT UNSIGNED 10 null

primary key

civicrm_product_en_US View duration_unit VARCHAR 8 year
civicrm_event_fr_CA View slot_label_id INT UNSIGNED 10 null

Subevent slot label. Implicit FK to civicrm_option_value where option_group = conference_slot.

civicrm_system_log Table contact_id INT UNSIGNED 10 null

Optional Contact ID that created the log. Not an FK as we keep this regardless

civicrm_file Table id INT UNSIGNED 10 null

Unique ID

civicrm_premiums_en_US View entity_id INT UNSIGNED 10 null
civicrm_price_set_fr_CA View name VARCHAR 255 null

Variable name/programmatic handle for this set of price fields.

civicrm_price_field_value_fr_CA View amount DECIMAL 18 null

Price field option amount

civicrm_event_en_US View confirm_from_name VARCHAR 255 null
civicrm_membership_type_fr_CA View duration_interval INT 10 null

Number of duration units in membership period (e.g. 1 year, 12 months).

civicrm_contribution Table address_id INT UNSIGNED 10 null

Conditional foreign key to civicrm_address.id. We insert an address record for each contribution when we have associated billing name and address data.

civicrm_group_fr_CA View parents TEXT 65535 null

IDs of the parent(s)

civicrm_membership_log Table membership_id INT UNSIGNED 10 null

FK to Membership table

civicrm_custom_field_fr_CA View weight INT 10 1

Controls field display order within an extended property group.

civicrm_uf_field_fr_CA View is_active TINYINT 3 1

Is this field currently shareable? If false, hide the field for all sharing contexts.

civicrm_acl_cache Table id INT UNSIGNED 10 null

Unique table ID

civicrm_sms_provider Table is_active TINYINT 3 0
civicrm_premiums_en_US View premiums_intro_title VARCHAR 255 null
civicrm_product Table financial_type_id INT UNSIGNED 10 null

FK to Financial Type.

civicrm_uf_group_fr_CA View submit_button_text VARCHAR 64 null

Custom Text to display on the submit button on profile edit/create screens

civicrm_membership_status_en_US View is_admin TINYINT 3 null

Is this status for admin/manual assignment only.

civicrm_preferences_date Table start INT 10 null

The start offset relative to current year

civicrm_event_fr_CA View is_template TINYINT 3 0

whether the event has template

civicrm_menu Table type INT 10 1

Drupal menu type.

civicrm_contribution_recur Table is_email_receipt TINYINT 3 1

if true, receipt is automatically emailed to contact on each successful payment

civicrm_contact Table contact_type VARCHAR 64 null

Type of Contact.

civicrm_sms_provider Table password VARCHAR 255 null
civicrm_report_instance Table created_id INT UNSIGNED 10 null

FK to contact table.

civicrm_report_instance Table email_subject VARCHAR 255 null

Subject of email

civicrm_price_set_fr_CA View financial_type_id INT UNSIGNED 10 null

FK to Financial Type(for membership price sets only).

civicrm_activity Table details LONGTEXT 2147483647 null

Details about the activity (agenda, notes, etc).

civicrm_membership_type Table period_type VARCHAR 8 null

Rolling membership period starts on signup date. Fixed membership periods start on fixed_period_start_day.

civicrm_membership_log Table status_id INT UNSIGNED 10 null

New status assigned to membership by this action. FK to Membership Status

civicrm_tell_friend_en_US View thankyou_text TEXT 65535 null
civicrm_location_type_en_US View vcard_name VARCHAR 64 null

vCard Location Type Name.

civicrm_group_en_US View description TEXT 65535 null

Optional verbose description of the group.

civicrm_contribution_page_en_US View is_recur_interval TINYINT 3 0

if true - supports recurring intervals

civicrm_email Table location_type_id INT UNSIGNED 10 null

Which Location does this email belong to.

civicrm_uf_field_fr_CA View is_searchable TINYINT 3 0

Is this field included search form of profile?

civicrm_menu Table access_callback VARCHAR 255 null

Function to call to check access permissions

civicrm_price_field_value_fr_CA View count INT UNSIGNED 10 null

Number of participants per field option

civicrm_custom_field_fr_CA View is_required TINYINT 3 null

Is a value required for this property.

civicrm_custom_field Table option_group_id INT UNSIGNED 10 null

For elements with options, the option group id that is used

civicrm_event_fr_CA View max_participants INT UNSIGNED 10 null

Maximum number of registered participants to allow. After max is reached, a custom Event Full message is displayed. If NULL, allow unlimited number of participants.

civicrm_participant Table role_id VARCHAR 128 null

Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.

civicrm_financial_trxn Table from_financial_account_id INT UNSIGNED 10 null

FK to financial_account table.

civicrm_custom_field Table attributes VARCHAR 255 null

Store collection of type-appropriate attributes, e.g. textarea needs rows/cols attributes

civicrm_report_instance Table form_values TEXT 65535 null

Submitted form values for this report

civicrm_custom_field Table date_format VARCHAR 64 null

date format for custom date

civicrm_option_value_en_US View is_active TINYINT 3 1

Is this option active?

civicrm_custom_field Table default_value VARCHAR 255 null

Use form_options.is_default for field_types which use options.

civicrm_contribution_page Table id INT UNSIGNED 10 null

Contribution Id

civicrm_uf_group Table help_post_fr_CA TEXT 65535 null
civicrm_option_group Table name VARCHAR 64 null

Option group name. Used as selection key by class properties which lookup options in civicrm_option_value.

civicrm_mailing Table approver_id INT UNSIGNED 10 null

FK to Contact ID who approved this mailing

civicrm_timezone Table name VARCHAR 64 null

Timezone full name

civicrm_dashboard_en_US View fullscreen_url VARCHAR 255 null

fullscreen url for dashlet

civicrm_premiums Table entity_id INT UNSIGNED 10 null
civicrm_country Table is_province_abbreviated TINYINT 3 0

Should state/province be displayed as abbreviation for contacts from this country?

civicrm_pcp Table currency VARCHAR 3 null

3 character string, value from config setting or input via user.

civicrm_price_set_fr_CA View help_post TEXT 65535 null
civicrm_relationship_type Table name_a_b VARCHAR 64 null

name for relationship of contact_a to contact_b.

civicrm_financial_item Table description VARCHAR 255 null

Human readable description of this item, to ease display without lookup of source item.

civicrm_event_fr_CA View thankyou_footer_text TEXT 65535 null
civicrm_contribution_page Table is_billing_required TINYINT 3 0

Billing block required for Contribution Page

civicrm_msg_template Table msg_title VARCHAR 255 null

Descriptive title of message

civicrm_discount Table entity_table VARCHAR 64 null

physical tablename for entity being joined to discount, e.g. civicrm_event

civicrm_county Table abbreviation VARCHAR 4 null

2-4 Character Abbreviation of County

civicrm_mailing Table created_date DATETIME 19 null

Date and time this mailing was created.

civicrm_dashboard_en_US View domain_id INT UNSIGNED 10 null

Domain for dashboard

civicrm_tell_friend_fr_CA View id INT UNSIGNED 10 0

Friend ID

civicrm_custom_group_en_US View title VARCHAR 64 null
civicrm_price_field_fr_CA View id INT UNSIGNED 10 0

Price Field

civicrm_contribution_page_en_US View pay_later_text TEXT 65535 null
civicrm_mailing_spool Table removed_at DATETIME 19 null

date on which this job was removed.

civicrm_contact Table last_name VARCHAR 64 null

Last Name.

civicrm_tell_friend Table thankyou_text_fr_CA TEXT 65535 null
civicrm_navigation Table has_separator TINYINT 3 null

If separator needs to be added after this menu item

civicrm_event Table created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this event

civicrm_uf_field Table location_type_id INT UNSIGNED 10 null

Location type of this mapping, if required

civicrm_timezone Table id INT UNSIGNED 10 null

Timezone Id

civicrm_product Table frequency_interval INT 10 null

Number of units for delivery frequency of subscription, service, membership (e.g. every 3 Months).

civicrm_phone Table phone_type_id INT UNSIGNED 10 null

Which type of phone does this number belongs.

civicrm_pcp_block Table target_entity_id INT UNSIGNED 10 null

The entity that this pcp targets

civicrm_relationship_type Table label_a_b_fr_CA VARCHAR 64 null
civicrm_mail_settings Table username VARCHAR 255 null

username to use when polling

civicrm_product_en_US View thumbnail VARCHAR 255 null

Full or relative URL to image thumbnail.

civicrm_mailing Table template_type VARCHAR 64 traditional

The language/processing system used for email templates.

civicrm_contribution_page_fr_CA View min_amount DECIMAL 20 null

if other amounts allowed, user can configure minimum allowed.

civicrm_price_field_value Table is_default TINYINT 3 0

Is this default price field option

civicrm_sms_provider Table api_params TEXT 65535 null

the api params in xml, http or smtp format

civicrm_uf_field_fr_CA View is_reserved TINYINT 3 null

Is this field reserved for use by some other CiviCRM functionality?

civicrm_custom_field_en_US View start_date_years INT 10 null

Date may be up to start_date_years years prior to the current date.

civicrm_participant_status_type Table visibility_id INT UNSIGNED 10 null

whether the status type is visible to the public, an implicit foreign key to option_value.value related to the visibility option_group

civicrm_cache Table id INT UNSIGNED 10 null
civicrm_location_type_fr_CA View name VARCHAR 64 null

Location Type Name.

civicrm_mapping Table id INT UNSIGNED 10 null

Mapping ID

civicrm_payment_processor_type Table billing_mode INT UNSIGNED 10 null

Billing Mode

civicrm_case Table details TEXT 65535 null

Details about the meeting (agenda, notes, etc).

civicrm_mailing_event_subscribe Table contact_id INT UNSIGNED 10 null

FK to Contact

civicrm_uf_field Table is_active TINYINT 3 1

Is this field currently shareable? If false, hide the field for all sharing contexts.

civicrm_event_fr_CA View confirm_footer_text TEXT 65535 null
civicrm_case_type Table is_reserved TINYINT 3 null

Is this case type a predefined system type?

civicrm_event_en_US View is_multiple_registrations TINYINT 3 0

if true - allows the user to register multiple participants for event

civicrm_loc_block Table phone_id INT UNSIGNED 10 null
civicrm_participant Table transferred_to_contact_id INT UNSIGNED 10 null

Contact to which the event registration is transferred

civicrm_payment_processor Table signature TEXT 65535 null
civicrm_event_en_US View pay_later_receipt TEXT 65535 null
civicrm_mail_settings Table server VARCHAR 255 null

server to use when polling

civicrm_participant Table campaign_id INT UNSIGNED 10 null

The campaign for which this participant has been registered.

civicrm_event Table initial_amount_help_text_fr_CA TEXT 65535 null
civicrm_dedupe_rule Table rule_table VARCHAR 64 null

The name of the table this rule is about

civicrm_payment_processor_type Table password_label VARCHAR 255 null
civicrm_pcp_block_en_US View is_tellfriend_enabled TINYINT 3 null

Does Personal Campaign Page allow using tell a friend?

civicrm_action_schedule Table end_date VARCHAR 64 null

Entity end date

civicrm_financial_trxn Table net_amount DECIMAL 20 null

actual funds transfer amount. total less fees. if processor does not report actual fee during transaction, this is set to total_amount.

civicrm_contribution_soft Table pcp_display_in_roll TINYINT 3 0
civicrm_event_fr_CA View footer_text TEXT 65535 null
civicrm_pledge Table end_date DATETIME 19 null

Date this pledge finished successfully (total pledge payments equal to or greater than pledged amount).

civicrm_job Table domain_id INT UNSIGNED 10 null

Which Domain is this scheduled job for

civicrm_acl_contact_cache Table operation VARCHAR 8 null

What operation does this user have permission on?

civicrm_contribution_page Table is_recur_interval TINYINT 3 0

if true - supports recurring intervals

civicrm_contribution_recur Table installments INT UNSIGNED 10 null

Total number of payments to be made. Set this to 0 if this is an open-ended commitment i.e. no set end date.

civicrm_action_schedule Table recipient_manual VARCHAR 128 null

Contact IDs to which reminder should be sent.

civicrm_contribution_soft Table pcp_personal_note VARCHAR 255 null
civicrm_relationship_type_en_US View label_b_a VARCHAR 64 null
civicrm_activity_contact Table record_type_id INT UNSIGNED 10 null

Nature of this contact's role in the activity: 1 assignee, 2 creator, 3 focus or target.

civicrm_membership_type_fr_CA View visibility VARCHAR 64 null
civicrm_activity Table id INT UNSIGNED 10 null

Unique Other Activity ID

civicrm_event Table thankyou_footer_text_fr_CA TEXT 65535 null
civicrm_price_field Table help_pre_fr_CA TEXT 65535 null
civicrm_uf_group Table group_type VARCHAR 255 null

This column will store a comma separated list of the type(s) of profile fields.

civicrm_menu Table page_callback VARCHAR 255 null

function to call for this url

civicrm_tell_friend_fr_CA View suggested_message TEXT 65535 null
civicrm_navigation Table is_active TINYINT 3 null

Is this navigation item active?

civicrm_cxn Table app_meta TEXT 65535 null

Application Metadata (JSON)

civicrm_contribution_widget Table color_button VARCHAR 10 null
civicrm_product_fr_CA View id INT UNSIGNED 10 0
civicrm_recurring_entity Table entity_table VARCHAR 64 null

physical tablename for entity, e.g. civicrm_event

civicrm_payment_token Table billing_middle_name VARCHAR 255 null

Billing middle name at the time of token creation. Useful for fraud forensics

civicrm_dashboard Table fullscreen_url VARCHAR 255 null

fullscreen url for dashlet

civicrm_membership Table is_pay_later TINYINT 3 0
civicrm_event_en_US View is_monetary TINYINT 3 0

If true, one or more fee amounts must be set and a Payment Processor must be configured for Online Event Registration.

civicrm_group Table select_tables TEXT 65535 null

the tables to be included in a select data

civicrm_batch_fr_CA View item_count INT UNSIGNED 10 null

Number of items in a batch.

civicrm_phone Table phone_ext VARCHAR 16 null

Optional extension for a phone number.

civicrm_contribution_soft Table amount DECIMAL 20 null

Amount of this soft contribution.

civicrm_contribution_page_fr_CA View initial_amount_help_text TEXT 65535 null
civicrm_tell_friend_fr_CA View entity_table VARCHAR 64 null

Name of table where item being referenced is stored.

civicrm_contact Table organization_name VARCHAR 128 null

Organization Name.

civicrm_membership_block_fr_CA View is_separate_payment TINYINT 3 1

Should membership transactions be processed separately

civicrm_line_item Table qty DECIMAL 20 null
civicrm_event_fr_CA View cc_confirm VARCHAR 255 null

comma-separated list of email addresses to cc each time a confirmation is sent

civicrm_mailing Table is_archived TINYINT 3 0

Is this mailing archived?

civicrm_contribution Table check_number VARCHAR 255 null
civicrm_uf_group Table add_captcha TINYINT 3 0

Should a CAPTCHA widget be included this Profile form.

civicrm_custom_field_en_US View date_format VARCHAR 64 null

date format for custom date

civicrm_product Table name_en_US VARCHAR 255 null
civicrm_openid Table location_type_id INT UNSIGNED 10 null

Which Location does this email belong to.

civicrm_uf_group_en_US View is_edit_link TINYINT 3 0

Should edit link display in profile selector

civicrm_contact_type_fr_CA View is_reserved TINYINT 3 null

Is this contact type a predefined system type

civicrm_email Table email VARCHAR 254 null

Email address

civicrm_location_type Table description VARCHAR 255 null

Location Type Description.

civicrm_campaign Table goal_general TEXT 65535 null

General goals for Campaign.

civicrm_entity_financial_trxn Table id INT UNSIGNED 10 null

ID

civicrm_mailing_event_queue Table phone_id INT UNSIGNED 10 null

FK to Phone

civicrm_product_fr_CA View sku VARCHAR 50 null

Optional product sku or code.

civicrm_job_log Table job_id INT UNSIGNED 10 null

Pointer to job id - not a FK though, just for logging purposes

civicrm_membership_block Table renewal_title_en_US VARCHAR 255 null
civicrm_participant_status_type_fr_CA View label VARCHAR 255 null
civicrm_activity Table is_test TINYINT 3 0
civicrm_country Table address_format_id INT UNSIGNED 10 null

Foreign key to civicrm_address_format.id.

civicrm_contact_type Table label_en_US VARCHAR 64 null
civicrm_survey Table thankyou_title_fr_CA VARCHAR 255 null
civicrm_acl Table object_id INT UNSIGNED 10 null

The ID of the object controlled by this ACL entry

civicrm_financial_item Table created_date TIMESTAMP 19 CURRENT_TIMESTAMP

Date and time the item was created

civicrm_acl Table object_table VARCHAR 64 null

The table of the object controlled by this ACL entry

civicrm_uf_field Table help_pre_fr_CA TEXT 65535 null
civicrm_mailing Table hash VARCHAR 16 null

Key for validating requests related to this mailing.

civicrm_custom_field_en_US View javascript VARCHAR 255 null

Optional scripting attributes for field.

civicrm_uf_field_en_US View weight INT 10 1

Controls field display order when user framework fields are displayed in registration and account editing forms.

civicrm_membership_block_fr_CA View renewal_text TEXT 65535 null
civicrm_event_en_US View is_share TINYINT 3 1

Can people share the event through social media?

civicrm_product Table options_fr_CA TEXT 65535 null
civicrm_uf_field_fr_CA View website_type_id INT UNSIGNED 10 null

Website Type Id, if required

civicrm_activity Table modified_date TIMESTAMP 19 CURRENT_TIMESTAMP

When was the activity (or closely related entity) was created or modified or deleted.

civicrm_relationship_type_fr_CA View label_a_b VARCHAR 64 null
civicrm_option_value_en_US View weight INT UNSIGNED 10 null

Controls display sort order.

civicrm_event_fr_CA View default_fee_id INT UNSIGNED 10 null

FK to civicrm_option_value.

civicrm_mailing_component Table id INT UNSIGNED 10 null
civicrm_contribution_page Table is_credit_card_only TINYINT 3 0

if true - processing logic must reject transaction at confirmation stage if pay method != credit card

civicrm_membership_type_en_US View max_related INT 10 null

Maximum number of related memberships.

civicrm_address Table is_billing TINYINT 3 0

Is this the billing address.

civicrm_dashboard_fr_CA View id INT UNSIGNED 10 0
civicrm_survey_fr_CA View last_modified_id INT UNSIGNED 10 null

FK to civicrm_contact, who recently edited this Survey.

civicrm_uf_group Table is_edit_link TINYINT 3 0

Should edit link display in profile selector

civicrm_note Table note TEXT 65535 null

Note and/or Comment.

civicrm_payment_processor_type Table url_api_test_default VARCHAR 255 null
civicrm_case_type_fr_CA View id INT UNSIGNED 10 0

Autoincremented type id

civicrm_membership_status Table name VARCHAR 128 null

Name for Membership Status

civicrm_file Table upload_date DATETIME 19 null

Date and time that this attachment was uploaded or written to server.

civicrm_event_fr_CA View is_show_location TINYINT 3 1

If true, show event location.

civicrm_domain Table description VARCHAR 255 null

Description of Domain.

civicrm_mailing_bounce_type Table description VARCHAR 255 null

A description of this bounce type

civicrm_action_schedule Table recipient_listing VARCHAR 128 null

listing based on recipient field.

civicrm_option_value_en_US View color VARCHAR 255 null

Hex color value e.g. #ffffff

civicrm_pcp_block_fr_CA View is_approval_needed TINYINT 3 null

Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?

civicrm_event_en_US View footer_text TEXT 65535 null
civicrm_uf_group Table cancel_button_text_fr_CA VARCHAR 64 null

Custom Text to display on the cancel button when used in create or edit mode

civicrm_note Table contact_id INT UNSIGNED 10 null

FK to Contact ID creator

civicrm_uf_join Table id INT UNSIGNED 10 null

Unique table ID

civicrm_pledge_payment Table reminder_date DATETIME 19 null

The date that the most recent payment reminder was sent.

civicrm_contribution Table amount_level TEXT 65535 null
civicrm_event_fr_CA View default_role_id INT UNSIGNED 10 1

Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.

civicrm_price_set Table help_pre_fr_CA TEXT 65535 null
civicrm_uf_group_fr_CA View post_URL VARCHAR 255 null

Redirect to URL.

civicrm_contribution_page_en_US View cc_receipt VARCHAR 255 null

comma-separated list of email addresses to cc each time a receipt is sent

civicrm_financial_account Table is_reserved TINYINT 3 null

Is this a predefined system object?

civicrm_financial_item Table amount DECIMAL 20 0.00

Total amount of this item

civicrm_custom_group Table is_public BIT 0 1

Is this property public?

civicrm_mailing Table domain_id INT UNSIGNED 10 null

Which site is this mailing for

civicrm_event Table event_full_text_en_US TEXT 65535 null
civicrm_uf_field Table is_reserved TINYINT 3 null

Is this field reserved for use by some other CiviCRM functionality?

civicrm_custom_field_en_US View weight INT 10 1

Controls field display order within an extended property group.

civicrm_event Table expiration_time INT UNSIGNED 10 null

Expire pending but unconfirmed registrations after this many hours.

civicrm_print_label Table is_default TINYINT 3 1

Is this default?

civicrm_event Table initial_amount_label_fr_CA VARCHAR 255 null
civicrm_relationship_type_fr_CA View description VARCHAR 255 null
civicrm_event Table initial_amount_label_en_US VARCHAR 255 null
civicrm_contribution_page Table is_partial_payment TINYINT 3 0

is partial payment enabled for this online contribution page

civicrm_option_group_en_US View name VARCHAR 64 null

Option group name. Used as selection key by class properties which lookup options in civicrm_option_value.

civicrm_sms_provider Table username VARCHAR 255 null
civicrm_note Table entity_id INT UNSIGNED 10 null

Foreign key to the referenced item.

civicrm_event_en_US View is_active TINYINT 3 0

Is this Event enabled or disabled/cancelled?

civicrm_grant Table decision_date DATE 10 null

Date on which grant decision was made.

civicrm_tell_friend_en_US View entity_table VARCHAR 64 null

Name of table where item being referenced is stored.

civicrm_uf_field_en_US View is_active TINYINT 3 1

Is this field currently shareable? If false, hide the field for all sharing contexts.

civicrm_product_en_US View frequency_interval INT 10 null

Number of units for delivery frequency of subscription, service, membership (e.g. every 3 Months).

civicrm_group_fr_CA View created_id INT UNSIGNED 10 null

FK to contact table.

civicrm_location_type Table vcard_name VARCHAR 64 null

vCard Location Type Name.

civicrm_entity_financial_trxn Table entity_table VARCHAR 64 null

May contain civicrm_financial_item, civicrm_contribution, civicrm_financial_trxn, civicrm_grant, etc

civicrm_case_type_en_US View weight INT 10 1

Ordering of the case types

civicrm_event Table is_partial_payment TINYINT 3 0

is partial payment enabled for this event

civicrm_product_fr_CA View thumbnail VARCHAR 255 null

Full or relative URL to image thumbnail.

civicrm_case_activity Table activity_id INT UNSIGNED 10 null

Activity ID of case-activity association.

civicrm_price_set_en_US View extends VARCHAR 255 null

What components are using this price set?

civicrm_event Table approval_req_text_fr_CA TEXT 65535 null
civicrm_dashboard_en_US View cache_minutes INT UNSIGNED 10 60

Number of minutes to cache dashlet content in browser localStorage.

civicrm_event_en_US View initial_amount_help_text TEXT 65535 null
civicrm_mailing Table mailing_type VARCHAR 32 null

differentiate between standalone mailings, A/B tests, and A/B final-winner

civicrm_mail_settings Table password VARCHAR 255 null

password to use when polling

civicrm_status_pref Table domain_id INT UNSIGNED 10 null

Which Domain is this Status Preference for

civicrm_financial_account Table accounting_code VARCHAR 64 null

Optional value for mapping monies owed and received to accounting system codes.

civicrm_uf_group_fr_CA View description TEXT 65535 null

Optional verbose description of the profile.

civicrm_dashboard Table is_active TINYINT 3 0

Is this dashlet active?

civicrm_uf_group_fr_CA View is_edit_link TINYINT 3 0

Should edit link display in profile selector

civicrm_event_en_US View created_date DATETIME 19 null

Date and time that event was created.

civicrm_dedupe_rule Table rule_weight INT 10 null

The weight of the rule

civicrm_contribution_page_en_US View thankyou_text TEXT 65535 null
civicrm_group Table is_hidden TINYINT 3 0

Is this group hidden?

civicrm_uf_group_en_US View is_proximity_search TINYINT 3 0

Should we include proximity search feature in this profile search form?

civicrm_product Table period_type VARCHAR 8 rolling

Rolling means we set start/end based on current day, fixed means we set start/end for current year or month (e.g. 1 year + fixed -> we would set start/end for 1/1/06 thru 12/31/06 for any premium chosen in 2006)

civicrm_event Table allow_same_participant_emails TINYINT 3 0

if true - allows the user to register multiple registrations from same email address.

civicrm_option_value_en_US View component_id INT UNSIGNED 10 null

Component that this option value belongs/caters to.

civicrm_event_en_US View registration_end_date DATETIME 19 null

Date and time that online registration ends.

civicrm_openid Table is_primary TINYINT 3 0

Is this the primary email for this contact and location.

civicrm_contact_type_en_US View is_active TINYINT 3 null

Is this entry active?

civicrm_payment_processor Table subject VARCHAR 255 null
civicrm_group_fr_CA View where_tables TEXT 65535 null

the tables to be included in the count statement

civicrm_activity Table medium_id INT UNSIGNED 10 null

Activity Medium, Implicit FK to civicrm_option_value where option_group = encounter_medium.

civicrm_membership_status_fr_CA View end_event_adjust_unit VARCHAR 8 null

Unit used for adjusting from the ending event.

civicrm_entity_financial_trxn Table entity_id INT UNSIGNED 10 null
civicrm_participant_status_type Table label_en_US VARCHAR 255 null
civicrm_activity Table status_id INT UNSIGNED 10 null

ID of the status this activity is currently in. Foreign key to civicrm_option_value.

civicrm_option_value_fr_CA View is_default TINYINT 3 0

Is this the default option for the group?

civicrm_mailing_job Table start_date DATETIME 19 null

date on which this job was started.

civicrm_event_en_US View fee_label VARCHAR 255 null
civicrm_action_schedule Table name VARCHAR 64 null

Name of the action(reminder)

civicrm_product Table min_contribution DECIMAL 20 null

Minimum contribution required to be eligible to select this premium.

civicrm_event Table template_title_fr_CA VARCHAR 255 null
civicrm_group Table id INT UNSIGNED 10 null

Group ID

civicrm_option_value_fr_CA View icon VARCHAR 255 null

crm-i icon class

civicrm_batch_en_US View payment_instrument_id INT UNSIGNED 10 null

fk to Payment Instrument options in civicrm_option_values

civicrm_event Table pay_later_receipt_fr_CA TEXT 65535 null
civicrm_mailing Table override_verp TINYINT 3 0

Should we overrite VERP address in Reply-To

civicrm_case_type Table is_active TINYINT 3 null

Is this entry active?

civicrm_event Table is_active TINYINT 3 0

Is this Event enabled or disabled/cancelled?

civicrm_tag Table used_for VARCHAR 64 null
civicrm_contribution_page_fr_CA View created_date DATETIME 19 null

Date and time that contribution page was created.

civicrm_batch_fr_CA View mode_id INT UNSIGNED 10 null

fk to Batch mode options in civicrm_option_values

civicrm_option_value_fr_CA View is_active TINYINT 3 1

Is this option active?

civicrm_membership_type Table name_en_US VARCHAR 128 null
civicrm_event_en_US View pay_later_text TEXT 65535 null
civicrm_pledge_block Table pledge_start_date VARCHAR 64 null

The date that the first scheduled pledge occurs.

civicrm_activity Table engagement_level INT UNSIGNED 10 null

Assign a specific level of engagement to this activity. Used for tracking constituents in ladder of engagement.

civicrm_pcp_block_en_US View owner_notify_id INT 10 null

FK to option_value where option_group = pcp_owner_notification

civicrm_pledge_block Table initial_reminder_day INT UNSIGNED 10 5

Send initial reminder this many days prior to the payment due date.

civicrm_survey_en_US View created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this Survey.

civicrm_premiums_en_US View premiums_contact_phone VARCHAR 50 null

This phone number is included in receipts if it is populated and a premium has been selected.

civicrm_event_fr_CA View default_discount_fee_id INT UNSIGNED 10 null

FK to civicrm_option_value.

civicrm_event Table confirm_email_text_fr_CA TEXT 65535 null
civicrm_mailing_abtest Table domain_id INT UNSIGNED 10 null

Which site is this mailing for

civicrm_batch_fr_CA View created_date DATETIME 19 null

When was this item created

civicrm_msg_template Table is_reserved TINYINT 3 null

is this the reserved message template which we ship for the workflow referenced by workflow_id?

civicrm_event Table pay_later_text_fr_CA TEXT 65535 null
civicrm_price_field_value Table help_post_en_US TEXT 65535 null

Price field option post help text.

civicrm_event_en_US View confirm_title VARCHAR 255 null
civicrm_action_schedule Table from_name VARCHAR 255 null

Name in "from" field

civicrm_domain Table locales TEXT 65535 null

list of locales supported by the current db state (NULL for single-lang install)

civicrm_uf_match Table uf_name VARCHAR 128 null

UF Name

civicrm_event Table description_fr_CA TEXT 65535 null
civicrm_mailing_event_opened Table id INT UNSIGNED 10 null
civicrm_pcp_block_en_US View is_approval_needed TINYINT 3 null

Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?

civicrm_uf_group_en_US View submit_button_text VARCHAR 64 null

Custom Text to display on the submit button on profile edit/create screens

civicrm_pledge Table start_date DATETIME 19 null

The date the first scheduled pledge occurs.

civicrm_financial_trxn Table trxn_id VARCHAR 255 null

user-specified unique processor transaction id, bank id + trans id,... depending on payment_method

civicrm_custom_field Table html_type VARCHAR 32 null

HTML types plus several built-in extended types.

civicrm_financial_trxn Table trxn_result_code VARCHAR 255 null

processor result code

civicrm_custom_field Table mask VARCHAR 64 null

Optional format instructions for specific field types, like date types.

civicrm_uf_field Table weight INT 10 1

Controls field display order when user framework fields are displayed in registration and account editing forms.

civicrm_product_en_US View id INT UNSIGNED 10 0
civicrm_price_field_value_fr_CA View price_field_id INT UNSIGNED 10 null

FK to civicrm_price_field

civicrm_contact_type_en_US View parent_id INT UNSIGNED 10 null

Optional FK to parent contact type.

civicrm_membership_log Table max_related INT 10 null

Maximum number of related memberships.

civicrm_payment_processor Table id INT UNSIGNED 10 null

Payment Processor ID

civicrm_uf_group Table title_fr_CA VARCHAR 64 null
civicrm_option_value_en_US View visibility_id INT UNSIGNED 10 null
civicrm_system_log Table message VARCHAR 128 null

Standardized message

civicrm_price_field_fr_CA View options_per_line INT UNSIGNED 10 1

number of options per line for checkbox and radio

civicrm_system_log Table hostname VARCHAR 128 null

Optional Name of logging host

civicrm_mailing Table msg_template_id INT UNSIGNED 10 null

FK to the message template.

civicrm_location_type_en_US View is_default TINYINT 3 null

Is this location type the default?

civicrm_participant_status_type_fr_CA View name VARCHAR 64 null

non-localized name of the status type

civicrm_contribution_page_en_US View is_pay_later TINYINT 3 0

if true - allows the user to send payment directly to the org later

civicrm_dashboard_fr_CA View url VARCHAR 255 null

url in case of external dashlet

civicrm_membership_status Table is_default TINYINT 3 null

Assign this status to a membership record if no other status match is found.

civicrm_group_fr_CA View modified_id INT UNSIGNED 10 null

FK to contact table.

civicrm_premiums_en_US View premiums_intro_text TEXT 65535 null
civicrm_payment_processor Table is_default TINYINT 3 null

Is this processor the default?

civicrm_contribution_page_en_US View goal_amount DECIMAL 20 null

The target goal for this page, allows people to build a goal meter

civicrm_financial_trxn Table to_financial_account_id INT UNSIGNED 10 null

FK to financial_financial_account table.

civicrm_action_mapping Table entity_recipient VARCHAR 64 null

Entity recipient

civicrm_contact Table email_greeting_id INT UNSIGNED 10 null

FK to civicrm_option_value.id, that has to be valid registered Email Greeting.

civicrm_case_contact Table case_id INT UNSIGNED 10 null

Case ID of case-contact association.

civicrm_contact Table gender_id INT UNSIGNED 10 null

FK to gender ID

civicrm_pcp Table is_active TINYINT 3 0

Is Personal Campaign Page enabled/active?

civicrm_word_replacement Table replace_word VARCHAR 255 null

Word which will replace the word in find

civicrm_uf_group_en_US View cancel_URL VARCHAR 255 null

Redirect to URL when Cancle button clik .

civicrm_events_in_carts Table event_cart_id INT UNSIGNED 10 null

FK to Event Cart ID

civicrm_mailing_bounce_type Table name VARCHAR 24 null

Type of bounce

civicrm_uf_group Table cancel_button_text_en_US VARCHAR 64 null

Custom Text to display on the cancel button when used in create or edit mode

civicrm_uf_field_fr_CA View phone_type_id INT UNSIGNED 10 null

Phone Type Id, if required

civicrm_relationship_type_fr_CA View contact_type_a VARCHAR 12 null

If defined, contact_a in a relationship of this type must be a specific contact_type.

civicrm_status_pref Table id INT UNSIGNED 10 null

Unique Status Preference ID

civicrm_file Table mime_type VARCHAR 255 null

mime type of the document

civicrm_event Table confirm_footer_text_en_US TEXT 65535 null
civicrm_mailing Table dedupe_email TINYINT 3 0

Remove duplicate emails?

civicrm_premiums_product Table weight INT UNSIGNED 10 null
civicrm_uf_group Table post_URL VARCHAR 255 null

Redirect to URL.

civicrm_contribution_widget Table url_homepage VARCHAR 255 null

URL to Homepage.

civicrm_contribution Table currency VARCHAR 3 null

3 character string, value from config setting or input via user.

civicrm_location_type Table name VARCHAR 64 null

Location Type Name.

civicrm_contribution_page Table initial_amount_label_fr_CA VARCHAR 255 null
civicrm_group Table modified_id INT UNSIGNED 10 null

FK to contact table.

civicrm_pcp_block Table tellfriend_limit INT UNSIGNED 10 null

Maximum recipient fields allowed in tell a friend

civicrm_tell_friend_en_US View intro TEXT 65535 null
civicrm_acl Table operation VARCHAR 8 null

What operation does this ACL entry control?

civicrm_financial_type Table id INT UNSIGNED 10 null

ID of original financial_type so you can search this table by the financial_type.id and then select the relevant version based on the timestamp

civicrm_membership Table owner_membership_id INT UNSIGNED 10 null

Optional FK to Parent Membership.

civicrm_menu Table title VARCHAR 255 null

Menu Title

civicrm_pcp_block Table entity_table VARCHAR 64 null
civicrm_event_fr_CA View financial_type_id INT UNSIGNED 10 null

Financial type assigned to paid event registrations for this event. Required if is_monetary is true.

civicrm_case_type_en_US View id INT UNSIGNED 10 0

Autoincremented type id

civicrm_pcp_block_fr_CA View is_active TINYINT 3 1

Is Personal Campaign Page Block enabled/active?

civicrm_survey_en_US View bypass_confirm TINYINT 3 0

Bypass the email verification.

civicrm_contribution Table invoice_id VARCHAR 255 null

unique invoice id, system generated or passed in

civicrm_location_type Table display_name_en_US VARCHAR 64 null
civicrm_saved_search Table form_values TEXT 65535 null

Submitted form values for this search

civicrm_uf_field Table help_post_en_US TEXT 65535 null
civicrm_saved_search Table mapping_id INT UNSIGNED 10 null

Foreign key to civicrm_mapping used for saved search-builder searches.

civicrm_mailing_component Table component_type VARCHAR 12 null

Type of Component.

civicrm_price_field_en_US View expire_on DATETIME 19 null

If non-zero, do not show this field after the date specified

civicrm_uf_group Table description TEXT 65535 null

Optional verbose description of the profile.

civicrm_subscription_history Table id INT UNSIGNED 10 null

Internal Id

civicrm_option_group Table data_type VARCHAR 128 null

Data Type of Option Group.

civicrm_membership_type_en_US View relationship_direction VARCHAR 128 null
civicrm_contribution_page_en_US View created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this contribution page

civicrm_custom_group_en_US View extends_entity_column_value VARCHAR 255 null

linking custom group for dynamic object

civicrm_contact_type_fr_CA View is_active TINYINT 3 null

Is this entry active?

civicrm_event_fr_CA View bcc_confirm VARCHAR 255 null

comma-separated list of email addresses to bcc each time a confirmation is sent

civicrm_price_set_fr_CA View title VARCHAR 255 null
civicrm_membership_block Table is_required TINYINT 3 0

Is membership sign up optional

civicrm_relationship_type_fr_CA View name_a_b VARCHAR 64 null

name for relationship of contact_a to contact_b.

civicrm_price_field_value_fr_CA View is_default TINYINT 3 0

Is this default price field option

civicrm_product Table thumbnail VARCHAR 255 null

Full or relative URL to image thumbnail.

civicrm_event Table payment_processor VARCHAR 128 null

Payment Processors configured for this Event (if is_monetary is true)

civicrm_entity_tag Table entity_id INT UNSIGNED 10 null

FK to entity table specified in entity_table column.

civicrm_email Table contact_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_custom_group Table weight INT 10 1

Controls display order when multiple extended property groups are setup for the same class.

civicrm_membership_status_en_US View end_event_adjust_unit VARCHAR 8 null

Unit used for adjusting from the ending event.

civicrm_mailing_spool Table recipient_email TEXT 65535 null

The email of the receipients this mail is to be sent.

civicrm_price_set_fr_CA View id INT UNSIGNED 10 0

Price Set

civicrm_survey Table title_en_US VARCHAR 255 null
civicrm_price_set_entity Table price_set_id INT UNSIGNED 10 null

price set being used

civicrm_custom_field_fr_CA View options_per_line INT UNSIGNED 10 null

number of options per line for checkbox and radio

civicrm_action_schedule Table msg_template_id INT UNSIGNED 10 null

FK to the message template.

civicrm_location_type_fr_CA View vcard_name VARCHAR 64 null

vCard Location Type Name.

civicrm_price_set_fr_CA View is_reserved TINYINT 3 0

Is this a predefined system price set (i.e. it can not be deleted, edited)?

civicrm_pcp_block_en_US View entity_id INT UNSIGNED 10 null

FK to civicrm_contribution_page.id OR civicrm_event.id

civicrm_cxn Table id INT UNSIGNED 10 null

Connection ID

civicrm_survey Table last_modified_date DATETIME 19 null

Date and time that Survey was edited last time.

civicrm_price_field Table active_on DATETIME 19 null

If non-zero, do not show this field before the date specified

civicrm_component Table namespace VARCHAR 128 null

Path to components main directory in a form of a class namespace.

civicrm_price_set Table is_reserved TINYINT 3 0

Is this a predefined system price set (i.e. it can not be deleted, edited)?

civicrm_membership Table max_related INT 10 null

Maximum number of related memberships (membership_type override).

civicrm_pledge Table contact_id INT UNSIGNED 10 null

Foreign key to civicrm_contact.id .

civicrm_custom_field Table label_en_US VARCHAR 255 null
civicrm_membership_type_fr_CA View name VARCHAR 128 null
civicrm_survey_en_US View title VARCHAR 255 null
civicrm_pcp Table status_id INT UNSIGNED 10 null
civicrm_event_en_US View is_confirm_enabled TINYINT 3 1

If false, the event booking confirmation screen gets skipped

civicrm_participant_status_type_en_US View visibility_id INT UNSIGNED 10 null

whether the status type is visible to the public, an implicit foreign key to option_value.value related to the visibility option_group

civicrm_membership_type_fr_CA View receipt_text_signup VARCHAR 255 null

Receipt Text for membership signup

civicrm_premiums Table premiums_intro_text_fr_CA TEXT 65535 null
civicrm_action_schedule Table mode VARCHAR 128 Email

Send the message as email or sms or both.

civicrm_custom_field_fr_CA View note_columns INT UNSIGNED 10 null

Number of columns in Note Field

civicrm_group_en_US View id INT UNSIGNED 10 0

Group ID

civicrm_print_label Table is_active TINYINT 3 1

Is this option active?

civicrm_uf_group_fr_CA View is_map TINYINT 3 0

Do we want to map results from this profile.

civicrm_contribution_page Table receipt_text_en_US TEXT 65535 null
civicrm_contribution_page_fr_CA View pay_later_text TEXT 65535 null
civicrm_payment_processor Table class_name VARCHAR 255 null
civicrm_custom_field Table is_searchable TINYINT 3 null

Is this property searchable.

civicrm_contribution_page_en_US View is_share TINYINT 3 1

Can people share the contribution page through social media?

civicrm_batch_fr_CA View type_id INT UNSIGNED 10 null

fk to Batch Type options in civicrm_option_values

civicrm_membership_type_fr_CA View minimum_fee DECIMAL 18 0.000000000

Minimum fee for this membership (0 for free/complimentary memberships).

civicrm_contribution_page_fr_CA View thankyou_title VARCHAR 255 null
civicrm_entity_financial_account Table entity_id INT UNSIGNED 10 null

Links to an id in the entity_table, such as vid in civicrm_financial_type

civicrm_pledge Table currency VARCHAR 3 null

3 character string, value from config setting or input via user.

civicrm_report_instance Table email_cc TEXT 65535 null

comma-separated list of email addresses to send the report to

civicrm_membership_status_en_US View end_event VARCHAR 12 null

Event after which this status ends.

civicrm_batch_fr_CA View modified_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_case_activity Table case_id INT UNSIGNED 10 null

Case ID of case-activity association.

civicrm_contact Table do_not_trade TINYINT 3 0
civicrm_cxn Table app_guid VARCHAR 128 null

Application GUID

civicrm_uf_group Table title_en_US VARCHAR 64 null
civicrm_contribution_page Table adjust_recur_start_date TINYINT 3 0

If true - user is able to adjust payment start date.

civicrm_report_instance Table id INT UNSIGNED 10 null

Report Instance ID

civicrm_acl Table entity_table VARCHAR 64 null

Table of the object possessing this ACL entry (Contact, Group, or ACL Group)

civicrm_tag Table created_date DATETIME 19 null

Date and time that tag was created.

civicrm_dedupe_rule_group Table is_reserved TINYINT 3 null

Is this a reserved rule - a rule group that has been optimized and cannot be changed by the admin

civicrm_contribution_page_en_US View is_email_receipt TINYINT 3 0

if true, receipt is automatically emailed to contact on success

civicrm_msg_template Table is_default TINYINT 3 1

is this the default message template for the workflow referenced by workflow_id?

civicrm_relationship Table contact_id_b INT UNSIGNED 10 null

id of the second contact

civicrm_line_item Table unit_price DECIMAL 20 null

price of each item

civicrm_mailing_group Table group_type VARCHAR 8 null

Are the members of the group included or excluded?.

civicrm_event Table intro_text_en_US TEXT 65535 null
civicrm_option_value Table option_group_id INT UNSIGNED 10 null

Group which this option belongs to.

civicrm_print_label Table is_reserved TINYINT 3 1

Is this reserved label?

civicrm_contact Table job_title VARCHAR 255 null

Job Title

civicrm_action_schedule Table group_id INT UNSIGNED 10 null

FK to Group

civicrm_membership_block Table new_title_en_US VARCHAR 255 null
civicrm_tell_friend_en_US View title VARCHAR 255 null
civicrm_preferences_date Table date_format VARCHAR 64 null

The date type

civicrm_activity Table is_deleted TINYINT 3 0
civicrm_price_field_value Table help_pre_en_US TEXT 65535 null

Price field option pre help text.

civicrm_cache Table data LONGTEXT 2147483647 null

data associated with this path

civicrm_tell_friend_fr_CA View title VARCHAR 255 null
civicrm_tell_friend_fr_CA View entity_id INT UNSIGNED 10 null

Foreign key to the referenced item.

civicrm_option_value_fr_CA View is_reserved TINYINT 3 0

Is this a predefined system object?

civicrm_payment_processor_type Table url_button_test_default VARCHAR 255 null
civicrm_uf_group_fr_CA View id INT UNSIGNED 10 0

Unique table ID

civicrm_batch_en_US View item_count INT UNSIGNED 10 null

Number of items in a batch.

civicrm_pledge_payment Table reminder_count INT UNSIGNED 10 0

The number of payment reminders sent.

civicrm_price_field Table html_type VARCHAR 12 null
civicrm_action_schedule Table from_email VARCHAR 255 null

Email address in "from" field

civicrm_note Table modified_date DATE 10 null

When was this note last modified/edited

civicrm_contribution_recur Table frequency_unit VARCHAR 8 month

Time units for recurrence of payment.

civicrm_option_value Table domain_id INT UNSIGNED 10 null

Which Domain is this option value for

civicrm_contact Table email_greeting_display VARCHAR 255 null

Cache Email Greeting.

civicrm_financial_trxn Table payment_instrument_id INT UNSIGNED 10 null

FK to payment_instrument option group values

civicrm_action_schedule Table start_action_date VARCHAR 64 null

Entity date

civicrm_option_group Table is_active TINYINT 3 null

Is this option group active?

civicrm_contact Table contact_sub_type VARCHAR 255 null

May be used to over-ride contact view and edit templates.

civicrm_payment_processor Table payment_processor_type_id INT UNSIGNED 10 null
civicrm_mailing_event_delivered Table time_stamp DATETIME 19 null

When this delivery event occurred.

civicrm_dashboard_en_US View is_active TINYINT 3 0

Is this dashlet active?

civicrm_contribution_page_fr_CA View is_recur TINYINT 3 0

if true - allows recurring contributions, valid only for PayPal_Standard

civicrm_entity_tag Table entity_table VARCHAR 64 null

physical tablename for entity being joined to file, e.g. civicrm_contact

civicrm_mailing_spool Table added_at DATETIME 19 null

date on which this job was added.

civicrm_action_mapping Table entity_value_label VARCHAR 64 null

Entity value label

civicrm_contact_type Table is_reserved TINYINT 3 null

Is this contact type a predefined system type

civicrm_discount Table start_date DATE 10 null

Date when discount starts.

civicrm_cxn Table is_active TINYINT 3 1

Is connection currently enabled?

civicrm_custom_group Table collapse_adv_display INT UNSIGNED 10 0

Will this group be in collapsed or expanded mode on advanced search display ?

civicrm_address Table is_primary TINYINT 3 0

Is this the primary address.

civicrm_batch_fr_CA View created_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_custom_field Table start_date_years INT 10 null

Date may be up to start_date_years years prior to the current date.

civicrm_batch_en_US View created_id INT UNSIGNED 10 null

FK to Contact ID

civicrm_dedupe_rule_group Table name VARCHAR 64 null

Name of the rule group

civicrm_custom_group_fr_CA View is_multiple TINYINT 3 null

Does this group hold multiple values?

civicrm_uf_group_en_US View is_map TINYINT 3 0

Do we want to map results from this profile.

civicrm_contribution_page_en_US View thankyou_footer TEXT 65535 null
civicrm_mailing Table footer_id INT UNSIGNED 10 null

FK to the footer component.

civicrm_custom_field_en_US View is_view TINYINT 3 null

Is this property set by PHP Code? A code field is viewable but not editable

civicrm_mailing Table open_tracking TINYINT 3 null

Should we track when recipients open/read this mailing?

civicrm_batch_fr_CA View modified_date DATETIME 19 null

When was this item created

civicrm_premiums_en_US View entity_table VARCHAR 64 null

Joins these premium settings to another object. Always civicrm_contribution_page for now.

civicrm_action_log Table is_error TINYINT 3 0

Was there any error sending the reminder?

civicrm_pcp Table title VARCHAR 255 null
civicrm_event Table cc_confirm VARCHAR 255 null

comma-separated list of email addresses to cc each time a confirmation is sent

civicrm_case_contact Table id INT UNSIGNED 10 null

Unique case-contact association id

civicrm_event_fr_CA View fee_label VARCHAR 255 null
civicrm_contact_type Table image_URL VARCHAR 255 null

URL of image if any.

civicrm_phone Table id INT UNSIGNED 10 null

Unique Phone ID

civicrm_participant_payment Table id INT UNSIGNED 10 null

Participant Payment Id

civicrm_payment_processor Table billing_mode INT UNSIGNED 10 null

Billing Mode

civicrm_financial_trxn Table total_amount DECIMAL 20 null

amount of transaction

civicrm_custom_group_en_US View table_name VARCHAR 255 null

Name of the table that holds the values for this group.

civicrm_contribution_page Table title_en_US VARCHAR 255 null
civicrm_event_fr_CA View created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this event

civicrm_product_fr_CA View options TEXT 65535 null
civicrm_participant Table id INT UNSIGNED 10 null

Participant Id

civicrm_event_en_US View created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this event

civicrm_loc_block Table im_id INT UNSIGNED 10 null
civicrm_case_type_en_US View description VARCHAR 255 null
civicrm_campaign Table goal_revenue DECIMAL 20 null

The target revenue for this campaign.

civicrm_event_en_US View default_fee_id INT UNSIGNED 10 null

FK to civicrm_option_value.

civicrm_custom_field Table is_required TINYINT 3 null

Is a value required for this property.

civicrm_price_field Table price_set_id INT UNSIGNED 10 null

FK to civicrm_price_set

civicrm_tag Table is_tagset TINYINT 3 0
civicrm_price_set Table name VARCHAR 255 null

Variable name/programmatic handle for this set of price fields.

civicrm_custom_group_en_US View is_reserved TINYINT 3 0

Is this a reserved Custom Group?

civicrm_case Table created_date TIMESTAMP 19 null

When was the case was created.

civicrm_price_field_value Table non_deductible_amount DECIMAL 20 0.00

Portion of total amount which is NOT tax deductible.

civicrm_relationship Table description VARCHAR 255 null

Optional verbose description for the relationship.

civicrm_status_pref Table prefs VARCHAR 255 null

These settings are per-check, and can't be compared across checks.

civicrm_contribution_page_fr_CA View is_credit_card_only TINYINT 3 0

if true - processing logic must reject transaction at confirmation stage if pay method != credit card

civicrm_payment_processor_type Table description VARCHAR 255 null

Payment Processor Description.

civicrm_contribution_recur Table is_test TINYINT 3 0
civicrm_activity Table activity_type_id INT UNSIGNED 10 1

FK to civicrm_option_value.id, that has to be valid, registered activity type.

civicrm_contact Table nick_name VARCHAR 128 null

Nickname.

civicrm_contact Table preferred_mail_format VARCHAR 8 Both

What is the preferred mode of sending an email.

civicrm_custom_field Table is_active TINYINT 3 null

Is this property active?

civicrm_uf_group_fr_CA View is_uf_link TINYINT 3 0

Should we display a link to the website profile in profile selector

civicrm_pledge Table installments INT UNSIGNED 10 1

Total number of payments to be made.

civicrm_cxn Table created_date TIMESTAMP 19 null

When was the connection was created.

civicrm_batch_en_US View saved_search_id INT UNSIGNED 10 null

FK to Saved Search ID

civicrm_event Table default_role_id INT UNSIGNED 10 1

Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.

civicrm_survey_fr_CA View created_date DATETIME 19 null

Date and time that Survey was created.

civicrm_option_group Table title_en_US VARCHAR 255 null
civicrm_menu Table domain_id INT UNSIGNED 10 null

Which Domain is this menu item for

civicrm_campaign Table name VARCHAR 255 null

Name of the Campaign.

civicrm_contribution_widget Table contribution_page_id INT UNSIGNED 10 null

The Contribution Page which triggered this contribution

civicrm_product_fr_CA View cost DECIMAL 20 null

Actual cost of this product. Useful to determine net return from sale or using this as an incentive.

civicrm_case_type_en_US View is_reserved TINYINT 3 null

Is this case type a predefined system type?

civicrm_price_set_en_US View name VARCHAR 255 null

Variable name/programmatic handle for this set of price fields.

civicrm_grant Table id INT UNSIGNED 10 null

Unique Grant id

civicrm_msg_template Table id INT UNSIGNED 10 null

Message Template ID

civicrm_report_instance Table args VARCHAR 255 null

arguments that are passed in the url when invoking the instance

civicrm_timezone Table gmt VARCHAR 64 null

GMT name of the timezone

civicrm_group_fr_CA View group_type VARCHAR 128 null

FK to group type

civicrm_entity_batch Table batch_id INT UNSIGNED 10 null

FK to civicrm_batch

civicrm_contribution_page_fr_CA View adjust_recur_start_date TINYINT 3 0

If true - user is able to adjust payment start date.

civicrm_uf_group_en_US View name VARCHAR 64 null

Name of the UF group for directly addressing it in the codebase

civicrm_relationship_type_fr_CA View is_active TINYINT 3 1

Is this relationship type currently active (i.e. can be used when creating or editing relationships)?

civicrm_relationship_type_en_US View name_a_b VARCHAR 64 null

name for relationship of contact_a to contact_b.

civicrm_contribution_page_fr_CA View footer_text TEXT 65535 null
civicrm_country Table country_code VARCHAR 4 null

National prefix to be used when dialing TO this country.

civicrm_survey Table created_date DATETIME 19 null

Date and time that Survey was created.

civicrm_mailing_abtest Table status VARCHAR 32 null

Status

civicrm_dashboard_en_US View is_reserved TINYINT 3 0

Is this dashlet reserved?

civicrm_contribution_page Table financial_type_id INT UNSIGNED 10 null

default financial type assigned to contributions submitted via this page, e.g. Contribution, Campaign Contribution

civicrm_event_en_US View template_title VARCHAR 255 null
civicrm_payment_processor Table description VARCHAR 255 null

Payment Processor Description.

civicrm_campaign_group Table entity_table VARCHAR 64 null

Name of table where item being referenced is stored.

civicrm_option_value_fr_CA View grouping VARCHAR 255 null

Use to sort and/or set display properties for sub-set(s) of options within an option group. EXAMPLE: Use for college_interest field, to differentiate partners from non-partners.

civicrm_contribution_page Table is_pay_later TINYINT 3 0

if true - allows the user to send payment directly to the org later

civicrm_uf_field_en_US View label VARCHAR 255 null
civicrm_mailing_event_bounce Table bounce_type_id INT UNSIGNED 10 null

What type of bounce was it?

civicrm_membership_type Table fixed_period_start_day INT 10 null

For fixed period memberships, month and day (mmdd) on which subscription/membership will start. Period start is back-dated unless after rollover day.

civicrm_grant Table grant_due_date DATE 10 null

Date on which grant report is due.

civicrm_log Table entity_table VARCHAR 64 null

Name of table where item being referenced is stored.

civicrm_case_contact Table contact_id INT UNSIGNED 10 null

Contact ID of contact record given case belongs to.

civicrm_price_field_fr_CA View visibility_id INT UNSIGNED 10 1

Implicit FK to civicrm_option_group with name = \'visibility\'

civicrm_membership_log Table start_date DATE 10 null

New membership period start date

civicrm_custom_field Table label_fr_CA VARCHAR 255 null
civicrm_pledge Table id INT UNSIGNED 10 null

Pledge ID

civicrm_event_en_US View default_role_id INT UNSIGNED 10 1

Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.

civicrm_line_item Table line_total DECIMAL 20 null

qty * unit_price

civicrm_price_set_en_US View financial_type_id INT UNSIGNED 10 null

FK to Financial Type(for membership price sets only).

civicrm_participant Table fee_level TEXT 65535 null

Populate with the label (text) associated with a fee level for paid events with multiple levels. Note that we store the label value and not the key

civicrm_pcp_block_fr_CA View target_entity_type VARCHAR 255 contribute

The type of entity that this pcp targets

civicrm_contribution_page Table bcc_receipt VARCHAR 255 null

comma-separated list of email addresses to bcc each time a receipt is sent

civicrm_premiums_fr_CA View premiums_intro_text TEXT 65535 null
civicrm_pcp Table donate_link_text VARCHAR 255 null
civicrm_acl Table entity_id INT UNSIGNED 10 null

ID of the object possessing this ACL

civicrm_product_fr_CA View price DECIMAL 20 null

Sell price or market value for premiums. For tax-deductible contributions, this will be stored as non_deductible_amount in the contribution record.

civicrm_price_field Table javascript VARCHAR 255 null

Optional scripting attributes for field

civicrm_contribution Table revenue_recognition_date DATETIME 19 null

Stores the date when revenue should be recognized.

civicrm_payment_processor_type Table is_active TINYINT 3 null

Is this processor active?

civicrm_action_schedule Table is_repeat TINYINT 3 0
civicrm_relationship_type Table id INT UNSIGNED 10 null

Primary key

civicrm_uf_field Table is_multi_summary TINYINT 3 0

Include in multi-record listing?

civicrm_print_label Table title VARCHAR 255 null

User title for for this label layout

civicrm_group Table description TEXT 65535 null

Optional verbose description of the group.

civicrm_note Table subject VARCHAR 255 null

subject of note description

civicrm_group_nesting Table parent_group_id INT UNSIGNED 10 null

ID of the parent group

civicrm_membership_block Table entity_id INT UNSIGNED 10 null

FK to civicrm_contribution_page.id

civicrm_dedupe_rule_group Table threshold INT 10 null

The weight threshold the sum of the rule weights has to cross to consider two contacts the same

civicrm_survey_en_US View id INT UNSIGNED 10 0

Survey id.

civicrm_contribution Table fee_amount DECIMAL 20 null

actual processor fee if known - may be 0.

civicrm_country Table ndd_prefix VARCHAR 4 null

Access prefix to call within a country to a different area

civicrm_option_group Table id INT UNSIGNED 10 null

Option Group ID

civicrm_option_value Table is_default TINYINT 3 0

Is this the default option for the group?

civicrm_relationship Table id INT UNSIGNED 10 null

Relationship ID

civicrm_mailing Table sms_provider_id INT UNSIGNED 10 null
civicrm_setting Table created_id INT UNSIGNED 10 null

FK to civicrm_contact, who created this setting

civicrm_menu Table is_exposed TINYINT 3 null

Is this menu exposed to the navigation system?

civicrm_batch Table modified_date DATETIME 19 null

When was this item created

civicrm_action_schedule Table recipient VARCHAR 64 null

Recipient

civicrm_payment_processor_type Table url_site_test_default VARCHAR 255 null
civicrm_pcp Table is_honor_roll INT UNSIGNED 10 0
civicrm_relationship_type_fr_CA View id INT UNSIGNED 10 0

Primary key

civicrm_sms_provider Table title VARCHAR 64 null

Provider name visible to user

civicrm_group Table where_clause TEXT 65535 null

the sql where clause if a saved search acl

civicrm_membership_block_en_US View new_text TEXT 65535 null
civicrm_job_log Table name VARCHAR 255 null

Title of the job

civicrm_acl_contact_cache Table id INT UNSIGNED 10 null

primary key

civicrm_pcp_block_en_US View link_text VARCHAR 255 null
civicrm_pcp_block_en_US View supporter_profile_id INT UNSIGNED 10 null

FK to civicrm_uf_group.id. Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?

civicrm_case_type_en_US View definition BLOB 65535 null

xml definition of case type

civicrm_county Table name VARCHAR 64 null

Name of County

civicrm_uf_field Table is_view TINYINT 3 0

the field is view only and not editable in user forms.

civicrm_batch_en_US View total DECIMAL 20 null

Total amount for this batch.

civicrm_event_en_US View is_pay_later TINYINT 3 0

if true - allows the user to send payment directly to the org later

civicrm_financial_type Table is_reserved TINYINT 3 null

Is this a predefined system object?

civicrm_action_schedule Table mapping_id VARCHAR 64 null

Name/ID of the mapping to use on this table

civicrm_mailing_event_trackable_url_open Table trackable_url_id INT UNSIGNED 10 null

FK to TrackableURL

civicrm_price_field_value Table membership_type_id INT UNSIGNED 10 null

FK to Membership Type

civicrm_participant_status_type_en_US View is_counted TINYINT 3 null

whether this status type is counted against event size limit

civicrm_event Table thankyou_text_en_US TEXT 65535 null
civicrm_event Table dedupe_rule_group_id INT UNSIGNED 10 null

Rule to use when matching registrations for this event

civicrm_custom_field_en_US View name VARCHAR 64 null

Variable name/programmatic handle for this group.

civicrm_uf_field Table in_selector TINYINT 3 0

Is this field included as a column in the selector table?

civicrm_event Table end_date DATETIME 19 null

Date and time that event ends. May be NULL if no defined end date/time

civicrm_product_en_US View fixed_period_start_day INT 10 101

Month and day (MMDD) that fixed period type subscription or membership starts.

civicrm_contact Table suffix_id INT UNSIGNED 10 null

Suffix for name (Jr, Sr...). FK to suffix ID

civicrm_action_schedule Table entity_value VARCHAR 255 null

Entity value

civicrm_dedupe_rule_group Table id INT UNSIGNED 10 null

Unique dedupe rule group id

civicrm_membership_status_fr_CA View name VARCHAR 128 null

Name for Membership Status

civicrm_address Table timezone VARCHAR 8 null

Timezone expressed as a UTC offset - e.g. United States CST would be written as "UTC-6".

civicrm_mailing_job Table job_type VARCHAR 255 null

Type of mailling job: null | child

civicrm_contribution_page_en_US View is_recur TINYINT 3 0

if true - allows recurring contributions, valid only for PayPal_Standard

civicrm_payment_processor_type Table payment_instrument_id INT UNSIGNED 10 1

Payment Instrument ID

civicrm_membership Table join_date DATE 10 null

Beginning of initial membership period (member since...).

civicrm_setting Table id INT UNSIGNED 10 null
civicrm_contact_type Table is_active TINYINT 3 null

Is this entry active?

civicrm_dashboard Table label_fr_CA VARCHAR 255 null
civicrm_batch Table total DECIMAL 20 null

Total amount for this batch.

civicrm_membership_status Table label_fr_CA VARCHAR 128 null
civicrm_membership_block_en_US View is_active TINYINT 3 1

Is this membership_block enabled

civicrm_membership_type Table domain_id INT UNSIGNED 10 null

Which Domain is this match entry for

civicrm_product Table duration_interval INT 10 null

Number of units for total duration of subscription, service, membership (e.g. 12 Months).

civicrm_pcp_block Table owner_notify_id INT 10 null

FK to option_value where option_group = pcp_owner_notification

civicrm_contact Table is_deceased TINYINT 3 0
civicrm_event_en_US View requires_approval TINYINT 3 null

Whether participants require approval before they can finish registering.

civicrm_contribution_page_en_US View receipt_from_email VARCHAR 255 null

FROM email address used for receipts generated by contributions to this contribution page.

civicrm_product_en_US View sku VARCHAR 50 null

Optional product sku or code.

civicrm_group Table name VARCHAR 64 null

Internal name of Group.

civicrm_mailing_recipients Table id INT UNSIGNED 10 null
civicrm_price_set_fr_CA View min_amount INT UNSIGNED 10 0

Minimum Amount required for this set.

civicrm_contribution_soft Table pcp_roll_nickname VARCHAR 255 null
civicrm_price_field_value_en_US View non_deductible_amount DECIMAL 20 0.00

Portion of total amount which is NOT tax deductible.

civicrm_contact_type_fr_CA View label VARCHAR 64 null
civicrm_custom_group_en_US View extends VARCHAR 255 Contact

Type of object this group extends (can add other options later e.g. contact_address, etc.).

civicrm_survey Table is_default TINYINT 3 0

Is this default survey?

civicrm_price_field_value Table amount DECIMAL 18 null

Price field option amount

civicrm_location_type_en_US View id INT UNSIGNED 10 0

Location Type ID

civicrm_financial_account Table is_deductible TINYINT 3 1

Is this account tax-deductible?

civicrm_contribution_page_fr_CA View receipt_from_name VARCHAR 255 null
civicrm_price_set Table domain_id INT UNSIGNED 10 null

Which Domain is this price-set for

civicrm_mapping_field Table contact_type VARCHAR 64 null

Contact Type in mapping

civicrm_subscription_history Table method VARCHAR 8 null

How the (un)subscription was triggered

civicrm_batch Table title_fr_CA VARCHAR 255 null
civicrm_mail_settings Table domain_id INT UNSIGNED 10 null

Which Domain is this match entry for

civicrm_custom_group_fr_CA View created_date DATETIME 19 null

Date and time this custom group was created.

civicrm_activity Table relationship_id INT UNSIGNED 10 null

FK to Relationship ID

civicrm_membership_status Table weight INT 10 null
civicrm_mailing_event_subscribe Table id INT UNSIGNED 10 null
civicrm_acl_entity_role Table id INT UNSIGNED 10 null

Unique table ID

civicrm_contribution_page Table receipt_text_fr_CA TEXT 65535 null
civicrm_contact Table prefix_id INT UNSIGNED 10 null

Prefix or Title for name (Ms, Mr...). FK to prefix ID

civicrm_relationship_type_fr_CA View is_reserved TINYINT 3 null

Is this relationship type a predefined system type (can not be changed or de-activated)?

civicrm_membership_block_fr_CA View display_min_fee TINYINT 3 1

Display minimum membership fee

civicrm_pledge Table amount DECIMAL 20 null

Total pledged amount.

civicrm_event_en_US View payment_processor VARCHAR 128 null

Payment Processors configured for this Event (if is_monetary is true)