civicrm_pcp_block_en_US - civicrm Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

INT UNSIGNED

PCP block Id

entity_table

VARCHAR

√

null

entity_id

INT UNSIGNED

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

null

The entity that this pcp targets

supporter_profile_id

INT UNSIGNED

√

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

√

null

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

is_tellfriend_enabled

TINYINT

√

null

Does Personal Campaign Page allow using tell a friend?

tellfriend_limit

INT UNSIGNED

√

null

Maximum recipient fields allowed in tell a friend

is_active

TINYINT

√

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

√

null

FK to option_value where option_group = pcp_owner_notification

link_text

VARCHAR

255

√

null

Showing 1 to 13 of 13 entries

View Definition

 
select `civicrm`.`civicrm_pcp_block`.`id` AS `id`,`civicrm`.`civicrm_pcp_block`.`entity_table` AS `entity_table`,`civicrm`.`civicrm_pcp_block`.`entity_id` AS `entity_id`,`civicrm`.`civicrm_pcp_block`.`target_entity_type` AS `target_entity_type`,`civicrm`.`civicrm_pcp_block`.`target_entity_id` AS `target_entity_id`,`civicrm`.`civicrm_pcp_block`.`supporter_profile_id` AS `supporter_profile_id`,`civicrm`.`civicrm_pcp_block`.`is_approval_needed` AS `is_approval_needed`,`civicrm`.`civicrm_pcp_block`.`is_tellfriend_enabled` AS `is_tellfriend_enabled`,`civicrm`.`civicrm_pcp_block`.`tellfriend_limit` AS `tellfriend_limit`,`civicrm`.`civicrm_pcp_block`.`is_active` AS `is_active`,`civicrm`.`civicrm_pcp_block`.`notify_email` AS `notify_email`,`civicrm`.`civicrm_pcp_block`.`owner_notify_id` AS `owner_notify_id`,`civicrm`.`civicrm_pcp_block`.`link_text_en_US` AS `link_text` from `civicrm`.`civicrm_pcp_block`

Possibly Referenced Tables/Views

civicrm_pcp_block