Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
Soft Contribution ID |
|||
| contribution_id | INT UNSIGNED | 10 | null |
|
|
FK to contribution table. |
||||
| contact_id | INT UNSIGNED | 10 | null |
|
|
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 |
|
|
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. |
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
Close relationships within degrees of separation
