| 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. |
