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 |
|
|