Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
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 |
|||
| link_text_en_US | VARCHAR | 255 | √ | null |
|
|
||||
| link_text_fr_CA | VARCHAR | 255 | √ | null |
|
|
||||
| owner_notify_id | INT | 10 | √ | null |
|
|
FK to option_value where option_group = pcp_owner_notification |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK_civicrm_pcp_block_supporter_profile_id | Performance | Asc | supporter_profile_id |
Relationships
Close relationships within degrees of separation
