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>
89 <type>int unsigned
</type>
90 <title>Soft Contribution PCP
</title>
91 <default>NULL
</default>
92 <comment>FK to civicrm_pcp.id
</comment>
95 <table>civicrm_pcp
</table>
96 <keyColumn>id
</keyColumn>
97 <labelColumn>title
</labelColumn>
102 <table>civicrm_pcp
</table>
105 <onDelete>SET NULL
</onDelete>
108 <name>index_id
</name>
109 <fieldName>pcp_id
</fieldName>
113 <name>pcp_display_in_roll
</name>
115 <title>Soft Contribution Display on PCP
</title>
120 <name>pcp_roll_nickname
</name>
122 <title>Soft Contribution PCP Nickname
</title>
124 <default>NULL
</default>
128 <name>pcp_personal_note
</name>
130 <title>Soft Contribution PCP Note
</title>
132 <default>NULL
</default>
136 <name>soft_credit_type_id
</name>
137 <type>int unsigned
</type>
138 <default>NULL
</default>
139 <title>Soft Credit Type
</title>
141 <optionGroupName>soft_credit_type
</optionGroupName>
143 <comment>Soft Credit Type ID.Implicit FK to civicrm_option_value where option_group = soft_credit_type.
</comment>