civicrm_pcp_block_en_US


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 0

PCP block Id

entity_table VARCHAR 64 null
entity_id INT UNSIGNED 10 null

FK to civicrm_contribution_page.id OR civicrm_event.id

target_entity_type VARCHAR 255 contribute

The type of entity that this pcp targets

target_entity_id INT UNSIGNED 10 null

The entity that this pcp targets

supporter_profile_id INT UNSIGNED 10 null

FK to civicrm_uf_group.id. Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?

is_approval_needed TINYINT 3 null

Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?

is_tellfriend_enabled TINYINT 3 null

Does Personal Campaign Page allow using tell a friend?

tellfriend_limit INT UNSIGNED 10 null

Maximum recipient fields allowed in tell a friend

is_active TINYINT 3 1

Is Personal Campaign Page Block enabled/active?

notify_email VARCHAR 255 null

If set, notification is automatically emailed to this email-address on create/update Personal Campaign Page

owner_notify_id INT 10 null

FK to option_value where option_group = pcp_owner_notification

link_text VARCHAR 255 null

Table contained 0 rows

View Definition


Possibly Referenced Tables/Views