civicrm_pledge


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_pledge_payment.pledge_id FK_civicrm_pledge_payment_pledge_id C

Pledge ID

contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_pledge_contact_id C

Foreign key to civicrm_contact.id .

financial_type_id INT UNSIGNED 10 null
civicrm_financial_type.id FK_civicrm_pledge_financial_type_id R

FK to Financial Type

contribution_page_id INT UNSIGNED 10 null
civicrm_contribution_page.id FK_civicrm_pledge_contribution_page_id N

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
civicrm_campaign.id FK_civicrm_pledge_campaign_id N

The campaign for which this pledge has been initiated.

Table contained 0 rows

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