Columns
| 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. |
|
| 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 |
|
|
||
| TEXT | 65535 | √ | null |
|
|
|||
| receipt_from_name | VARCHAR | 255 | √ | null |
|
|
||
| receipt_text | TEXT | 65535 | √ | null |
|
|
||
| TEXT | 65535 | √ | null |
|
|
|||
| frontend_title | VARCHAR | 255 | √ | null |
|
|
Contribution Page Public title |