1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Contribute
</base>
5 <class>ContributionSoft
</class>
6 <name>civicrm_contribution_soft
</name>
11 <uniqueName>contribution_soft_id
</uniqueName>
12 <title>Soft Contribution ID
</title>
13 <type>int unsigned
</type>
14 <required>true
</required>
16 <title>Soft Contribution ID
</title>
17 <comment>Soft Contribution ID
</comment>
22 <autoincrement>true
</autoincrement>
25 <name>contribution_id
</name>
26 <title>Soft Contribution - Contribution
</title>
27 <type>int unsigned
</type>
28 <required>true
</required>
29 <comment>FK to contribution table.
</comment>
33 <name>contribution_id
</name>
34 <table>civicrm_contribution
</table>
37 <onDelete>CASCADE
</onDelete>
40 <name>contact_id
</name>
41 <uniqueName>contribution_soft_contact_id
</uniqueName>
42 <title>Contact ID
</title>
43 <type>int unsigned
</type>
44 <required>true
</required>
46 <headerPattern>/contact(.?id)?/i
</headerPattern>
47 <dataPattern>/^\d+$/
</dataPattern>
48 <comment>FK to Contact ID
</comment>
52 <name>contact_id
</name>
53 <table>civicrm_contact
</table>
56 <onDelete>CASCADE
</onDelete>
60 <title>Soft Contribution Amount
</title>
62 <required>true
</required>
64 <headerPattern>/total(.?am(ou)?nt)?/i
</headerPattern>
65 <dataPattern>/^\d+(\.\d{
2})?$/
</dataPattern>
66 <comment>Amount of this soft contribution.
</comment>
72 <title>Soft Contribution Currency
</title>
74 <default>NULL
</default>
75 <comment>3 character string, value from config setting or input via user.
</comment>
78 <table>civicrm_currency
</table>
79 <keyColumn>name
</keyColumn>
80 <labelColumn>full_name
</labelColumn>
81 <nameColumn>name
</nameColumn>
82 <abbrColumn>symbol
</abbrColumn>
90 <type>int unsigned
</type>
91 <title>Soft Contribution PCP
</title>
92 <default>NULL
</default>
93 <comment>FK to civicrm_pcp.id
</comment>
96 <table>civicrm_pcp
</table>
97 <keyColumn>id
</keyColumn>
98 <labelColumn>title
</labelColumn>
103 <table>civicrm_pcp
</table>
106 <onDelete>SET NULL
</onDelete>
109 <name>index_id
</name>
110 <fieldName>pcp_id
</fieldName>
114 <name>pcp_display_in_roll
</name>
116 <title>Soft Contribution Display on PCP
</title>
121 <name>pcp_roll_nickname
</name>
123 <title>Soft Contribution PCP Nickname
</title>
125 <default>NULL
</default>
129 <name>pcp_personal_note
</name>
131 <title>Soft Contribution PCP Note
</title>
134 <type>TextArea
</type>
136 <default>NULL
</default>
140 <name>soft_credit_type_id
</name>
141 <type>int unsigned
</type>
142 <default>NULL
</default>
143 <title>Soft Credit Type
</title>
145 <optionGroupName>soft_credit_type
</optionGroupName>
147 <comment>Soft Credit Type ID.Implicit FK to civicrm_option_value where option_group = soft_credit_type.
</comment>