1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
5 <class>Participant
</class>
6 <name>civicrm_participant
</name>
10 <component>CiviEvent
</component>
13 <uniqueName>participant_id
</uniqueName>
14 <title>Participant ID
</title>
15 <type>int unsigned
</type>
16 <required>true
</required>
17 <comment>Participant Id
</comment>
19 <headerPattern>/(^(participant(.)?)?id$)/i
</headerPattern>
27 <autoincrement>true
</autoincrement>
30 <name>contact_id
</name>
31 <uniqueName>participant_contact_id
</uniqueName>
32 <type>int unsigned
</type>
33 <title>Contact ID
</title>
34 <headerPattern>/contact(.?id)?/i
</headerPattern>
36 <required>true
</required>
37 <comment>FK to Contact ID
</comment>
39 <label>Contact
</label>
44 <name>contact_id
</name>
45 <table>civicrm_contact
</table>
47 <onDelete>CASCADE
</onDelete>
51 <type>int unsigned
</type>
52 <title>Event ID
</title>
54 <headerPattern>/event id$/i
</headerPattern>
55 <required>true
</required>
56 <comment>FK to Event ID
</comment>
64 <table>civicrm_event
</table>
66 <onDelete>CASCADE
</onDelete>
69 <name>status_id
</name>
70 <uniqueName>participant_status_id
</uniqueName>
71 <title>Participant Status ID
</title>
72 <headerPattern>/(participant.)?(status)$/i
</headerPattern>
74 <type>int unsigned
</type>
76 <required>true
</required>
78 <comment>Participant status ID. FK to civicrm_participant_status_type. Default of
1 should map to status = Registered.
</comment>
81 <table>civicrm_participant_status_type
</table>
82 <keyColumn>id
</keyColumn>
83 <labelColumn>label
</labelColumn>
87 <label>Participant Status
</label>
91 <name>status_id
</name>
92 <table>civicrm_participant_status_type
</table>
97 <name>index_status_id
</name>
98 <fieldName>status_id
</fieldName>
103 <uniqueName>participant_role_id
</uniqueName>
104 <title>Participant Role
</title>
106 <optionGroupName>participant_role
</optionGroupName>
110 <multiple>1</multiple>
112 <serialize>SEPARATOR_TRIMMED
</serialize>
113 <headerPattern>/(participant.)?(role)$/i
</headerPattern>
114 <import>true
</import>
117 <export>true
</export>
118 <default>NULL
</default>
119 <comment>Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.
</comment>
123 <name>index_role_id
</name>
124 <fieldName>role_id
</fieldName>
128 <name>register_date
</name>
129 <uniqueName>participant_register_date
</uniqueName>
130 <title>Register date
</title>
131 <headerPattern>/^(r(egister\s)?date)$/i
</headerPattern>
132 <import>true
</import>
133 <type>datetime
</type>
134 <comment>When did contact register for event?
</comment>
137 <type>Select Date
</type>
138 <formatType>activityDateTime
</formatType>
143 <uniqueName>participant_source
</uniqueName>
144 <title>Participant Source
</title>
145 <headerPattern>/(participant.)?(source)$/i
</headerPattern>
146 <import>true
</import>
149 <comment>Source of this event registration.
</comment>
156 <name>fee_level
</name>
157 <uniqueName>participant_fee_level
</uniqueName>
158 <title>Fee level
</title>
159 <headerPattern>/^(f(ee\s)?level)$/i
</headerPattern>
161 <import>true
</import>
162 <serialize>SEPARATOR_BOOKEND
</serialize>
163 <comment>Populate with the label (text) associated with a fee level for paid events with multiple levels. Note that
164 we store the label value and not the key
</comment>
169 <uniqueName>participant_is_test
</uniqueName>
173 <import>true
</import>
177 <name>is_pay_later
</name>
178 <uniqueName>participant_is_pay_later
</uniqueName>
179 <title>Is Pay Later
</title>
182 <import>true
</import>
183 <headerPattern>/(is.)?(pay(.)?later)$/i
</headerPattern>
188 <name>fee_amount
</name>
189 <uniqueName>participant_fee_amount
</uniqueName>
190 <title>Fee Amount
</title>
192 <import>true
</import>
193 <headerPattern>/fee(.?am(ou)?nt)?/i
</headerPattern>
194 <dataPattern>/^\d+(\.\d{
2})?$/
</dataPattern>
195 <comment>actual processor fee if known - may be
0.
</comment>
199 <name>registered_by_id
</name>
200 <uniqueName>participant_registered_by_id
</uniqueName>
201 <type>int unsigned
</type>
202 <title>Registered By Participant ID
</title>
203 <import>true
</import>
204 <default>NULL
</default>
205 <comment>FK to Participant ID
</comment>
207 <label>Registered By
</label>
210 <export>true
</export>
213 <name>registered_by_id
</name>
214 <table>civicrm_participant
</table>
217 <onDelete>SET NULL
</onDelete>
220 <name>discount_id
</name>
221 <uniqueName>participant_discount_id
</uniqueName>
222 <type>int unsigned
</type>
223 <title>Discount ID
</title>
224 <default>NULL
</default>
225 <comment>FK to Discount ID
</comment>
227 <label>Discount
</label>
232 <name>discount_id
</name>
233 <table>civicrm_discount
</table>
236 <onDelete>SET NULL
</onDelete>
239 <name>fee_currency
</name>
240 <uniqueName>participant_fee_currency
</uniqueName>
241 <title>Fee Currency
</title>
244 <default>NULL
</default>
245 <import>true
</import>
246 <headerPattern>/(fee)?.?cur(rency)?/i
</headerPattern>
247 <dataPattern>/^[A-Z]{
3}$/i
</dataPattern>
248 <comment>3 character string, value derived from config setting.
</comment>
251 <table>civicrm_currency
</table>
252 <keyColumn>name
</keyColumn>
253 <labelColumn>full_name
</labelColumn>
254 <nameColumn>name
</nameColumn>
255 <abbrColumn>symbol
</abbrColumn>
262 <name>campaign_id
</name>
263 <uniqueName>participant_campaign_id
</uniqueName>
264 <type>int unsigned
</type>
265 <title>Campaign ID
</title>
266 <import>true
</import>
267 <comment>The campaign for which this participant has been registered.
</comment>
269 <label>Campaign
</label>
274 <name>campaign_id
</name>
275 <table>civicrm_campaign
</table>
277 <onDelete>SET NULL
</onDelete>
280 <name>discount_amount
</name>
281 <type>int unsigned
</type>
282 <title>Discount Amount
</title>
283 <comment>Discount Amount
</comment>
288 <type>int unsigned
</type>
289 <title>Event Cart ID
</title>
290 <comment>FK to civicrm_event_carts
</comment>
292 <label>Event Cart
</label>
298 <table>civicrm_event_carts
</table>
300 <onDelete>SET NULL
</onDelete>
303 <name>must_wait
</name>
305 <title>Must Wait on List
</title>
306 <comment>On Waiting List
</comment>
310 <name>transferred_to_contact_id
</name>
311 <uniqueName>transferred_to_contact_id
</uniqueName>
312 <type>int unsigned
</type>
313 <default>NULL
</default>
314 <title>Transferred to Contact ID
</title>
315 <headerPattern>/transfer(.?id)?/i
</headerPattern>
316 <import>true
</import>
317 <comment>FK to Contact ID
</comment>
319 <label>Transferred to
</label>
324 <name>transferred_to_contact_id
</name>
325 <table>civicrm_contact
</table>
327 <onDelete>SET NULL
</onDelete>