Table d47civi_0z3xa.civicrm_pledge Generated by
SchemaSpy
Legend: SourceForge.net
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
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 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 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 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).
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 3 rows at mer. avr. 13 16:52 EDT 2016

Indexes:
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
status_id Performance Asc index_status

Close relationships  within of separation: