Table d45civi_b72v5.civicrm_contribution_soft 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  √  Soft Contribution ID
contribution_id int unsigned 10
civicrm_contribution.id FK_civicrm_contribution_soft_contribution_id C
FK to contribution table.
contact_id int unsigned 10
civicrm_contact.id FK_civicrm_contribution_soft_contact_id C
FK to Contact ID
amount decimal 20,2 Amount of this soft contribution.
currency varchar 3  √  null 3 character string, value from config setting or input via user.
pcp_id int unsigned 10  √  null
civicrm_pcp.id FK_civicrm_contribution_soft_pcp_id N
FK to civicrm_pcp.id
pcp_display_in_roll tinyint 3  √  0
pcp_roll_nickname varchar 255  √  null
pcp_personal_note varchar 255  √  null
soft_credit_type_id int unsigned 10  √  null Soft Credit Type ID.Implicit FK to civicrm_option_value where option_group = soft_credit_type.

Table contained 2 rows at Wed Nov 11 17:12 EST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
contact_id Performance Asc FK_civicrm_contribution_soft_contact_id
contribution_id Performance Asc FK_civicrm_contribution_soft_contribution_id
pcp_id Performance Asc index_id

Close relationships  within of separation: