Table d44civi_9xzwf.civicrm_pledge Generated by
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_pledge_payment.pledge_id FK_civicrm_pledge_payment_pledge_id C
Pledge ID
contact_id int unsigned 10 FK_civicrm_pledge_contact_id C
Foreign key to .
financial_type_id int unsigned 10  √  null FK_civicrm_pledge_financial_type_id R
FK to Financial Type
contribution_page_id int unsigned 10  √  null FK_civicrm_pledge_contribution_page_id N
The Contribution Page which triggered this contribution
amount decimal 20,2 Total pledged amount.
original_installment_amount decimal 20,2 Original amount for each of the installments.
currency varchar 3  √  null 3 character string, value from config setting or input via user.
frequency_unit enum 5  √  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 The date the first scheduled pledge occurs.
create_date datetime 19 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).
honor_contact_id int unsigned 10  √  null FK_civicrm_pledge_honor_contact_id N
FK to contact ID. Used when pledge is made in honor of another contact. This is propagated to contribution records when pledge payments are made.
honor_type_id int unsigned 10  √  null Implicit FK to civicrm_option_value.
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 FK_civicrm_pledge_campaign_id N
The campaign for which this pledge has been initiated.

Table contained 3 rows at Wed Nov 11 17:14 EST 2015

Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
campaign_id Performance Asc FK_civicrm_pledge_campaign_id
contact_id Performance Asc FK_civicrm_pledge_contact_id
contribution_page_id Performance Asc FK_civicrm_pledge_contribution_page_id
financial_type_id Performance Asc FK_civicrm_pledge_financial_type_id
honor_contact_id Performance Asc FK_civicrm_pledge_honor_contact_id
status_id Performance Asc index_status

Close relationships  within of separation: