Table d47civi_0z3xa.civicrm_pcp_block 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  √  PCP block Id
entity_table varchar 64  √  null
entity_id int unsigned 10 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 The entity that this pcp targets
supporter_profile_id int unsigned 10  √  null
civicrm_uf_group.id FK_civicrm_pcp_block_supporter_profile_id N
FK to civicrm_uf_group.id. Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?
owner_notify_id int unsigned 10  √  0 FK to civicrm_option_group with name = PCP owner notifications
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
link_text varchar 255  √  null Link text for PCP.
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

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

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

Close relationships  within of separation: