Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
Pledge ID |
|||
| contact_id | INT UNSIGNED | 10 | null |
|
|
Foreign key to civicrm_contact.id . |
||||
| financial_type_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to Financial Type |
|||
| contribution_page_id | INT UNSIGNED | 10 | √ | null |
|
|
The Contribution Page which triggered this contribution |
|||
| amount | DECIMAL | 20,2 | null |
|
|
Total pledged amount. |
||||
| original_installment_amount | DECIMAL | 20,2 | null |
|
|
Original amount for each of the installments. |
||||
| currency | VARCHAR | 3 | √ | null |
|
|
3 character string, value from config setting or input via user. |
|||
| frequency_unit | VARCHAR | 8 | √ | month |
|
|
Time units for recurrence of pledge payments. |
|||
| frequency_interval | INT UNSIGNED | 10 | 1 |
|
|
Number of time units for recurrence of pledge payments. |
||||
| 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. |
||||
| installments | INT UNSIGNED | 10 | √ | 1 |
|
|
Total number of payments to be made. |
|||
| start_date | DATETIME | 19 | null |
|
|
The date the first scheduled pledge occurs. |
||||
| create_date | DATETIME | 19 | null |
|
|
When this pledge record was created. |
||||
| acknowledge_date | DATETIME | 19 | √ | null |
|
|
When a pledge acknowledgement message was sent to the contributor. |
|||
| modified_date | DATETIME | 19 | √ | null |
|
|
Last updated date for this pledge record. |
|||
| cancel_date | DATETIME | 19 | √ | null |
|
|
Date this pledge was cancelled by contributor. |
|||
| end_date | DATETIME | 19 | √ | null |
|
|
Date this pledge finished successfully (total pledge payments equal to or greater than pledged amount). |
|||
| max_reminders | INT UNSIGNED | 10 | √ | 1 |
|
|
The maximum number of payment reminders to send for any given payment. |
|||
| initial_reminder_day | INT UNSIGNED | 10 | √ | 5 |
|
|
Send initial reminder this many days prior to the payment due date. |
|||
| additional_reminder_day | INT UNSIGNED | 10 | √ | 5 |
|
|
Send additional reminder this many days after last one sent, up to maximum number of reminders. |
|||
| status_id | INT UNSIGNED | 10 | √ | null |
|
|
Implicit foreign key to civicrm_option_values in the contribution_status option group. |
|||
| is_test | TINYINT | 3 | √ | 0 |
|
|
||||
| campaign_id | INT UNSIGNED | 10 | √ | null |
|
|
The campaign for which this pledge has been initiated. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK_civicrm_pledge_campaign_id | Performance | Asc | campaign_id |
| FK_civicrm_pledge_contact_id | Performance | Asc | contact_id |
| FK_civicrm_pledge_contribution_page_id | Performance | Asc | contribution_page_id |
| FK_civicrm_pledge_financial_type_id | Performance | Asc | financial_type_id |
| index_status | Performance | Asc | status_id |
Relationships
Close relationships within degrees of separation
