Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_contribution_soft.pcp_id FK_civicrm_contribution_soft_pcp_id N

Personal Campaign Page ID

contact_id INT UNSIGNED 10 null FK_civicrm_pcp_contact_id C

FK to Contact ID

status_id INT UNSIGNED 10 null
title VARCHAR 255 null
intro_text TEXT 65535 null
page_text TEXT 65535 null
VARCHAR 255 null
page_id INT UNSIGNED 10 null

The Contribution or Event Page which triggered this pcp

page_type VARCHAR 64 contribute

The type of PCP this is: contribute or event

pcp_block_id INT UNSIGNED 10 null

The pcp block that this pcp page was created from

is_thermometer INT UNSIGNED 10 0
is_honor_roll INT UNSIGNED 10 0
goal_amount DECIMAL 20,2 null

Goal amount of this Personal Campaign Page.

currency VARCHAR 3 null

3 character string, value from config setting or input via user.

is_active TINYINT 3 0

Is Personal Campaign Page enabled/active?

is_notify INT 10 0

Table contained 0 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_pcp_contact_id Performance Asc contact_id