civicrm_contribution_soft


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null

Soft Contribution ID

contribution_id INT UNSIGNED 10 null
civicrm_contribution.id FK_civicrm_contribution_soft_contribution_id C

FK to contribution table.

contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_contribution_soft_contact_id C

FK to Contact ID

amount DECIMAL 20,2 null

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

Indexes

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

Relationships