Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
Pledge ID |
|
| entity_table | VARCHAR | 64 | √ | null |
|
|
physical tablename for entity being joined to pledge, e.g. civicrm_contact |
|
| entity_id | INT UNSIGNED | 10 | null |
|
|
FK to entity table specified in entity_table column. |
||
| pledge_frequency_unit | VARCHAR | 128 | √ | null |
|
|
Delimited list of supported frequency units |
|
| is_pledge_interval | TINYINT | 3 | √ | 0 |
|
|
Is frequency interval exposed on the contribution form. |
|
| 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. |
|
| pledge_start_date | VARCHAR | 64 | √ | null |
|
|
The date that the first scheduled pledge occurs. |
|
| is_pledge_start_date_visible | TINYINT | 3 | 0 |
|
|
If true - recurring start date is shown. |
||
| is_pledge_start_date_editable | TINYINT | 3 | 0 |
|
|
If true - recurring start date is editable. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| index_entity | Performance | Asc/Asc | entity_table + entity_id |
Diagram producer might be missing
No diagrams were produced please see application output for any errors