Table d47civi_0z3xa.civicrm_pledge_payment 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  √ 
pledge_id int unsigned 10
civicrm_pledge.id FK_civicrm_pledge_payment_pledge_id C
FK to Pledge table
contribution_id int unsigned 10  √  null
civicrm_contribution.id FK_civicrm_pledge_payment_contribution_id C
FK to contribution table.
scheduled_amount decimal 20,2 Pledged amount for this payment (the actual contribution amount might be different).
actual_amount decimal 20,2  √  null Actual amount that is paid as the Pledged installment amount.
currency varchar 3  √  null 3 character string, value from config setting or input via user.
scheduled_date datetime 19 The date the pledge payment is supposed to happen.
reminder_date datetime 19  √  null The date that the most recent payment reminder was sent.
reminder_count int unsigned 10  √  0 The number of payment reminders sent.
status_id int unsigned 10  √  null

Table contained 8 rows at mer. avr. 13 16:52 EDT 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
pledge_id Performance Asc FK_civicrm_pledge_payment_pledge_id
contribution_id + pledge_id Performance Asc/Asc index_contribution_pledge
status_id Performance Asc index_status

Close relationships  within of separation: