Table d47civi_0z3xa.civicrm_pcp Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
civicrm_contribution_soft.pcp_id FK_civicrm_contribution_soft_pcp_id N
Personal Campaign Page ID
contact_id int unsigned 10
civicrm_contact.id FK_civicrm_pcp_contact_id C
FK to Contact ID
status_id int unsigned 10
title varchar 255  √  null
intro_text text 65535  √  null
page_text text 65535  √  null
donate_link_text varchar 255  √  null
page_id int unsigned 10 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 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 tinyint 3  √  0 Notify owner via email when someone donates to page?

Table contained 0 rows at mer. avr. 13 16:52 EDT 2016

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

Close relationships  within of separation: