civicrm_pledge_block


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.

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
index_entity Performance Asc/Asc entity_table + entity_id