| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | 0 |
|
|
Contribution Id |
||
| financial_type_id | INT UNSIGNED | 10 | √ | null |
|
|
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 |
|
| adjust_recur_start_date | TINYINT | 3 | 0 |
|
|
If true - user is able to adjust payment start date. |
||
| is_pay_later | TINYINT | 3 | √ | 0 |
|
|
if true - allows the user to send payment directly to the org later |
|
| is_partial_payment | TINYINT | 3 | √ | 0 |
|
|
is partial payment enabled for this online contribution page |
|
| 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 |
|
| is_email_receipt | TINYINT | 3 | √ | 0 |
|
|
if true, receipt is automatically emailed to contact on success |
|
| 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 |
|
| is_active | TINYINT | 3 | √ | null |
|
|
Is this property active? |
|
| 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 |
|
|
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 |
|
|
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 |
|
|
Billing block required for Contribution Page |
|
| title | VARCHAR | 255 | √ | null |
|
|
||
| intro_text | TEXT | 65535 | √ | null |
|
|
||
| pay_later_text | TEXT | 65535 | √ | null |
|
|
||
| pay_later_receipt | TEXT | 65535 | √ | null |
|
|
||
| initial_amount_label | VARCHAR | 255 | √ | null |
|
|
||
| initial_amount_help_text | TEXT | 65535 | √ | null |
|
|
||
| thankyou_title | VARCHAR | 255 | √ | null |
|
|
||
| thankyou_text | TEXT | 65535 | √ | null |
|
|
||
| thankyou_footer | TEXT | 65535 | √ | null |
|
|
||
| receipt_from_name | VARCHAR | 255 | √ | null |
|
|
||
| receipt_text | TEXT | 65535 | √ | null |
|
|
||
| footer_text | TEXT | 65535 | √ | null |
|
|
||
| frontend_title | VARCHAR | 255 | √ | null |
|
|
Contribution Page Public title |
select `civicrm`.`civicrm_contribution_page`.`id` AS `id`,`civicrm`.`civicrm_contribution_page`.`financial_type_id` AS `financial_type_id`,`civicrm`.`civicrm_contribution_page`.`payment_processor` AS `payment_processor`,`civicrm`.`civicrm_contribution_page`.`is_credit_card_only` AS `is_credit_card_only`,`civicrm`.`civicrm_contribution_page`.`is_monetary` AS `is_monetary`,`civicrm`.`civicrm_contribution_page`.`is_recur` AS `is_recur`,`civicrm`.`civicrm_contribution_page`.`is_confirm_enabled` AS `is_confirm_enabled`,`civicrm`.`civicrm_contribution_page`.`recur_frequency_unit` AS `recur_frequency_unit`,`civicrm`.`civicrm_contribution_page`.`is_recur_interval` AS `is_recur_interval`,`civicrm`.`civicrm_contribution_page`.`is_recur_installments` AS `is_recur_installments`,`civicrm`.`civicrm_contribution_page`.`adjust_recur_start_date` AS `adjust_recur_start_date`,`civicrm`.`civicrm_contribution_page`.`is_pay_later` AS `is_pay_later`,`civicrm`.`civicrm_contribution_page`.`is_partial_payment` AS `is_partial_payment`,`civicrm`.`civicrm_contribution_page`.`min_initial_amount` AS `min_initial_amount`,`civicrm`.`civicrm_contribution_page`.`is_allow_other_amount` AS `is_allow_other_amount`,`civicrm`.`civicrm_contribution_page`.`default_amount_id` AS `default_amount_id`,`civicrm`.`civicrm_contribution_page`.`min_amount` AS `min_amount`,`civicrm`.`civicrm_contribution_page`.`max_amount` AS `max_amount`,`civicrm`.`civicrm_contribution_page`.`goal_amount` AS `goal_amount`,`civicrm`.`civicrm_contribution_page`.`is_email_receipt` AS `is_email_receipt`,`civicrm`.`civicrm_contribution_page`.`receipt_from_email` AS `receipt_from_email`,`civicrm`.`civicrm_contribution_page`.`cc_receipt` AS `cc_receipt`,`civicrm`.`civicrm_contribution_page`.`bcc_receipt` AS `bcc_receipt`,`civicrm`.`civicrm_contribution_page`.`is_active` AS `is_active`,`civicrm`.`civicrm_contribution_page`.`amount_block_is_active` AS `amount_block_is_active`,`civicrm`.`civicrm_contribution_page`.`start_date` AS `start_date`,`civicrm`.`civicrm_contribution_page`.`end_date` AS `end_date`,`civicrm`.`civicrm_contribution_page`.`created_id` AS `created_id`,`civicrm`.`civicrm_contribution_page`.`created_date` AS `created_date`,`civicrm`.`civicrm_contribution_page`.`currency` AS `currency`,`civicrm`.`civicrm_contribution_page`.`campaign_id` AS `campaign_id`,`civicrm`.`civicrm_contribution_page`.`is_share` AS `is_share`,`civicrm`.`civicrm_contribution_page`.`is_billing_required` AS `is_billing_required`,`civicrm`.`civicrm_contribution_page`.`title_fr_CA` AS `title`,`civicrm`.`civicrm_contribution_page`.`intro_text_fr_CA` AS `intro_text`,`civicrm`.`civicrm_contribution_page`.`pay_later_text_fr_CA` AS `pay_later_text`,`civicrm`.`civicrm_contribution_page`.`pay_later_receipt_fr_CA` AS `pay_later_receipt`,`civicrm`.`civicrm_contribution_page`.`initial_amount_label_fr_CA` AS `initial_amount_label`,`civicrm`.`civicrm_contribution_page`.`initial_amount_help_text_fr_CA` AS `initial_amount_help_text`,`civicrm`.`civicrm_contribution_page`.`thankyou_title_fr_CA` AS `thankyou_title`,`civicrm`.`civicrm_contribution_page`.`thankyou_text_fr_CA` AS `thankyou_text`,`civicrm`.`civicrm_contribution_page`.`thankyou_footer_fr_CA` AS `thankyou_footer`,`civicrm`.`civicrm_contribution_page`.`receipt_from_name_fr_CA` AS `receipt_from_name`,`civicrm`.`civicrm_contribution_page`.`receipt_text_fr_CA` AS `receipt_text`,`civicrm`.`civicrm_contribution_page`.`footer_text_fr_CA` AS `footer_text`,`civicrm`.`civicrm_contribution_page`.`frontend_title_fr_CA` AS `frontend_title` from `civicrm`.`civicrm_contribution_page`