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

FK to Pledge table

contribution_id INT UNSIGNED 10 null FK_civicrm_pledge_payment_contribution_id C

FK to contribution table.

scheduled_amount DECIMAL 20,2 null

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 null

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 0 rows


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