1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
3 <base>CRM/Pledge
</base>
5 <name>civicrm_pledge
</name>
10 <uniqueName>pledge_id
</uniqueName>
11 <title>Pledge ID
</title>
12 <type>int unsigned
</type>
13 <required>true
</required>
14 <comment>Pledge ID
</comment>
20 <autoincrement>true
</autoincrement>
23 <name>contact_id
</name>
24 <uniqueName>pledge_contact_id
</uniqueName>
25 <title>Contact ID
</title>
27 <type>int unsigned
</type>
28 <required>true
</required>
29 <comment>Foreign key to civicrm_contact.id .
</comment>
33 <name>contact_id
</name>
34 <table>civicrm_contact
</table>
37 <onDelete>CASCADE
</onDelete>
40 <name>contribution_type_id
</name>
41 <uniqueName>pledge_contribution_type_id
</uniqueName>
42 <export>false
</export>
43 <type>int unsigned
</type>
44 <comment>FK to Contribution Type. This is propagated to contribution record when pledge payments are made.
</comment>
49 <name>contribution_type_id
</name>
50 <table>civicrm_contribution_type
</table>
54 <onDelete>SET NULL
</onDelete>
57 <name>financial_type_id
</name>
59 <uniqueName>pledge_financial_type_id
</uniqueName>
60 <type>int unsigned
</type>
61 <comment>FK to Financial Type
</comment>
65 <name>financial_type_id
</name>
66 <table>civicrm_financial_type
</table>
71 <name>contribution_page_id
</name>
72 <uniqueName>pledge_contribution_page_id
</uniqueName>
73 <title>Pledge Contribution Page
</title>
74 <type>int unsigned
</type>
75 <comment>The Contribution Page which triggered this contribution
</comment>
79 <name>contribution_page_id
</name>
80 <table>civicrm_contribution_page
</table>
82 <onDelete>SET NULL
</onDelete>
86 <uniqueName>pledge_amount
</uniqueName>
87 <title>Total Pledged
</title>
89 <required>true
</required>
91 <comment>Total pledged amount.
</comment>
95 <name>original_installment_amount
</name>
96 <uniqueName>pledge_original_installment_amount
</uniqueName>
97 <title>Original Installment Amount
</title>
99 <required>true
</required>
100 <comment>Original amount for each of the installments.
</comment>
104 <name>currency
</name>
106 <title>Pledge Currency
</title>
108 <default>NULL
</default>
109 <comment>3 character string, value from config setting or input via user.
</comment>
113 <name>frequency_unit
</name>
114 <uniqueName>pledge_frequency_unit
</uniqueName>
115 <title>Pledge Frequency Unit
</title>
117 <values>day,week,month,year
</values>
118 <default>'month'
</default>
119 <comment>Time units for recurrence of pledge payments.
</comment>
123 <name>frequency_interval
</name>
124 <uniqueName>pledge_frequency_interval
</uniqueName>
125 <title>Pledge Frequency Interval
</title>
126 <type>int unsigned
</type>
127 <required>true
</required>
129 <comment>Number of time units for recurrence of pledge payments.
</comment>
133 <name>frequency_day
</name>
134 <type>int unsigned
</type>
135 <title>Pledge day
</title>
137 <required>true
</required>
138 <comment>Day in the period when the pledge payment is due e.g.
1st of month,
15th etc. Use this to set the scheduled dates for pledge payments.
</comment>
142 <name>installments
</name>
143 <type>int unsigned
</type>
144 <title>Pledge Number of Installments
</title>
146 <comment>Total number of payments to be made.
</comment>
150 <name>start_date
</name>
151 <type>datetime
</type>
152 <title>Pledge Start Date
</title>
153 <required>true
</required>
154 <comment>The date the first scheduled pledge occurs.
</comment>
158 <name>create_date
</name>
159 <type>datetime
</type>
160 <uniqueName>pledge_create_date
</uniqueName>
161 <title>Pledge Made
</title>
162 <required>true
</required>
163 <import>true
</import>
164 <comment>When this pledge record was created.
</comment>
168 <name>acknowledge_date
</name>
169 <type>datetime
</type>
170 <title>Pledge Acknowledged
</title>
171 <comment>When a pledge acknowledgement message was sent to the contributor.
</comment>
175 <name>modified_date
</name>
176 <type>datetime
</type>
177 <title>Pledge Modified Date
</title>
178 <comment>Last updated date for this pledge record.
</comment>
182 <name>cancel_date
</name>
183 <type>datetime
</type>
184 <title>Pledge Cancelled Date
</title>
185 <comment>Date this pledge was cancelled by contributor.
</comment>
189 <name>end_date
</name>
190 <type>datetime
</type>
191 <title>Pledge End Date
</title>
192 <comment>Date this pledge finished successfully (total pledge payments equal to or greater than pledged amount).
</comment>
196 <name>honor_contact_id
</name>
197 <type>int unsigned
</type>
198 <title>Pledge Honor Contact
</title>
199 <comment>FK to contact ID. Used when pledge is made in honor of another contact. This is propagated to contribution records when pledge payments are made.
</comment>
203 <name>honor_contact_id
</name>
204 <table>civicrm_contact
</table>
207 <onDelete>SET NULL
</onDelete>
210 <name>honor_type_id
</name>
211 <title>Honor Type
</title>
212 <type>int unsigned
</type>
213 <comment>Implicit FK to civicrm_option_value.
</comment>
215 <onDelete>SET NULL
</onDelete>
217 <optionGroupName>honor_type
</optionGroupName>
221 <name>max_reminders
</name>
222 <title>Maximum Number of Reminders
</title>
223 <type>int unsigned
</type>
225 <comment>The maximum number of payment reminders to send for any given payment.
</comment>
229 <name>initial_reminder_day
</name>
230 <title>Initial Reminder Day
</title>
231 <type>int unsigned
</type>
233 <comment>Send initial reminder this many days prior to the payment due date.
</comment>
237 <name>additional_reminder_day
</name>
238 <title>Additional Reminder Days
</title>
239 <type>int unsigned
</type>
241 <comment>Send additional reminder this many days after last one sent, up to maximum number of reminders.
</comment>
245 <name>status_id
</name>
246 <title>Pledge Status Id
</title>
247 <uniqueName>pledge_status_id
</uniqueName>
248 <import>true
</import>
249 <export>false
</export>
250 <type>int unsigned
</type>
251 <comment>Implicit foreign key to civicrm_option_values in the contribution_status option group.
</comment>
255 <name>index_status
</name>
256 <fieldName>status_id
</fieldName>
261 <uniqueName>pledge_is_test
</uniqueName>
262 <import>true
</import>
268 <name>campaign_id
</name>
269 <uniqueName>pledge_campaign_id
</uniqueName>
270 <type>int unsigned
</type>
271 <title>Campaign ID
</title>
272 <import>true
</import>
273 <comment>The campaign for which this pledge has been initiated.
</comment>
277 <name>campaign_id
</name>
278 <table>civicrm_campaign
</table>
280 <onDelete>SET NULL
</onDelete>