Table d47civi_0z3xa.civicrm_contribution_page Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
civicrm_contribution.contribution_page_id FK_civicrm_contribution_contribution_page_id N
civicrm_contribution_widget.contribution_page_id FK_civicrm_contribution_widget_contribution_page_id C
civicrm_membership_block.entity_id FK_civicrm_membership_block_entity_id R
civicrm_pledge.contribution_page_id FK_civicrm_pledge_contribution_page_id N
Contribution Id
title varchar 255  √  null Contribution Page title. For top of page display
intro_text text 65535  √  null Text and html allowed. Displayed below title.
financial_type_id int unsigned 10  √  null
civicrm_financial_type.id FK_civicrm_contribution_page_financial_type_id R
default financial type assigned to contributions submitted via this page, e.g. Contribution, Campaign Contribution
payment_processor varchar 128  √  null Payment Processors configured for this contribution Page
is_credit_card_only tinyint 3  √  0 if true - processing logic must reject transaction at confirmation stage if pay method != credit card
is_monetary tinyint 3  √  1 if true - allows real-time monetary transactions otherwise non-monetary transactions
is_recur tinyint 3  √  0 if true - allows recurring contributions, valid only for PayPal_Standard
is_confirm_enabled tinyint 3  √  1 if false, the confirm page in contribution pages gets skipped
recur_frequency_unit varchar 128  √  null Supported recurring frequency units.
is_recur_interval tinyint 3  √  0 if true - supports recurring intervals
is_recur_installments tinyint 3  √  0 if true - asks user for recurring installments
is_pay_later tinyint 3  √  0 if true - allows the user to send payment directly to the org later
pay_later_text text 65535  √  null The text displayed to the user in the main form
pay_later_receipt text 65535  √  null The receipt sent to the user instead of the normal receipt text
is_partial_payment tinyint 3  √  0 is partial payment enabled for this online contribution page
initial_amount_label varchar 255  √  null Initial amount label for partial payment
initial_amount_help_text text 65535  √  null Initial amount help text for partial payment
min_initial_amount decimal 20,2  √  null Minimum initial amount for partial payment
is_allow_other_amount tinyint 3  √  0 if true, page will include an input text field where user can enter their own amount
default_amount_id int unsigned 10  √  null FK to civicrm_option_value.
min_amount decimal 20,2  √  null if other amounts allowed, user can configure minimum allowed.
max_amount decimal 20,2  √  null if other amounts allowed, user can configure maximum allowed.
goal_amount decimal 20,2  √  null The target goal for this page, allows people to build a goal meter
thankyou_title varchar 255  √  null Title for Thank-you page (header title tag, and display at the top of the page).
thankyou_text text 65535  √  null text and html allowed. displayed above result on success page
thankyou_footer text 65535  √  null Text and html allowed. displayed at the bottom of the success page. Common usage is to include link(s) to other pages such as tell-a-friend, etc.
is_email_receipt tinyint 3  √  0 if true, receipt is automatically emailed to contact on success
receipt_from_name varchar 255  √  null FROM email name used for receipts generated by contributions to this contribution page.
receipt_from_email varchar 255  √  null FROM email address used for receipts generated by contributions to this contribution page.
cc_receipt varchar 255  √  null comma-separated list of email addresses to cc each time a receipt is sent
bcc_receipt varchar 255  √  null comma-separated list of email addresses to bcc each time a receipt is sent
receipt_text text 65535  √  null text to include above standard receipt info on receipt email. emails are text-only, so do not allow html for now
is_active tinyint 3  √  null Is this property active?
footer_text text 65535  √  null Text and html allowed. Displayed at the bottom of the first page of the contribution wizard.
amount_block_is_active tinyint 3  √  1 Is this property active?
start_date datetime 19  √  null Date and time that this page starts.
end_date datetime 19  √  null Date and time that this page ends. May be NULL if no defined end date/time
created_id int unsigned 10  √  null
civicrm_contact.id FK_civicrm_contribution_page_created_id N
FK to civicrm_contact, who created this contribution page
created_date datetime 19  √  null Date and time that contribution page was created.
currency varchar 3  √  null 3 character string, value from config setting or input via user.
campaign_id int unsigned 10  √  null
civicrm_campaign.id FK_civicrm_contribution_page_campaign_id N
The campaign for which we are collecting contributions with this page.
is_share tinyint 3  √  1 Can people share the contribution page through social media?
is_billing_required tinyint 3  √  0 if true - billing block is required for online contribution page

Table contained 3 rows at mer. avr. 13 16:52 EDT 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
campaign_id Performance Asc FK_civicrm_contribution_page_campaign_id
created_id Performance Asc FK_civicrm_contribution_page_created_id
financial_type_id Performance Asc FK_civicrm_contribution_page_financial_type_id

Close relationships  within of separation: