1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
5 <class>Participant
</class>
6 <name>civicrm_participant
</name>
11 <uniqueName>participant_id
</uniqueName>
12 <title>Participant ID
</title>
13 <type>int unsigned
</type>
14 <required>true
</required>
15 <comment>Participant Id
</comment>
17 <headerPattern>/(^(participant(.)?)?id$)/i
</headerPattern>
22 <autoincrement>true
</autoincrement>
25 <name>contact_id
</name>
26 <uniqueName>participant_contact_id
</uniqueName>
27 <type>int unsigned
</type>
28 <title>Contact ID
</title>
29 <headerPattern>/contact(.?id)?/i
</headerPattern>
31 <required>true
</required>
32 <comment>FK to Contact ID
</comment>
36 <name>contact_id
</name>
37 <table>civicrm_contact
</table>
39 <onDelete>CASCADE
</onDelete>
43 <type>int unsigned
</type>
46 <headerPattern>/event id$/i
</headerPattern>
47 <required>true
</required>
48 <comment>FK to Event ID
</comment>
53 <table>civicrm_event
</table>
55 <onDelete>CASCADE
</onDelete>
58 <name>status_id
</name>
59 <uniqueName>participant_status_id
</uniqueName>
60 <title>Participant Status
</title>
61 <headerPattern>/(participant.)?(status)$/i
</headerPattern>
63 <type>int unsigned
</type>
65 <required>true
</required>
67 <comment>Participant status ID. FK to civicrm_participant_status_type. Default of
1 should map to status = Registered.
</comment>
70 <table>civicrm_participant_status_type
</table>
71 <keyColumn>id
</keyColumn>
72 <labelColumn>label
</labelColumn>
79 <name>status_id
</name>
80 <table>civicrm_participant_status_type
</table>
85 <name>index_status_id
</name>
86 <fieldName>status_id
</fieldName>
91 <uniqueName>participant_role_id
</uniqueName>
92 <title>Participant Role
</title>
94 <optionGroupName>participant_role
</optionGroupName>
98 <multiple>1</multiple>
100 <serialize>SEPARATOR_TRIMMED
</serialize>
101 <headerPattern>/(participant.)?(role)$/i
</headerPattern>
102 <import>true
</import>
105 <export>true
</export>
106 <default>NULL
</default>
107 <comment>Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.
</comment>
111 <name>index_role_id
</name>
112 <fieldName>role_id
</fieldName>
116 <name>register_date
</name>
117 <uniqueName>participant_register_date
</uniqueName>
118 <title>Register date
</title>
119 <headerPattern>/^(r(egister\s)?date)$/i
</headerPattern>
120 <import>true
</import>
121 <type>datetime
</type>
122 <comment>When did contact register for event?
</comment>
125 <type>Select Date
</type>
126 <formatType>activityDateTime
</formatType>
131 <uniqueName>participant_source
</uniqueName>
132 <title>Participant Source
</title>
133 <headerPattern>/(participant.)?(source)$/i
</headerPattern>
134 <import>true
</import>
137 <comment>Source of this event registration.
</comment>
144 <name>fee_level
</name>
145 <uniqueName>participant_fee_level
</uniqueName>
146 <title>Fee level
</title>
147 <headerPattern>/^(f(ee\s)?level)$/i
</headerPattern>
149 <import>true
</import>
150 <serialize>SEPARATOR_BOOKEND
</serialize>
151 <comment>Populate with the label (text) associated with a fee level for paid events with multiple levels. Note that
152 we store the label value and not the key
</comment>
157 <uniqueName>participant_is_test
</uniqueName>
161 <import>true
</import>
165 <name>is_pay_later
</name>
166 <uniqueName>participant_is_pay_later
</uniqueName>
167 <title>Is Pay Later
</title>
170 <import>true
</import>
171 <headerPattern>/(is.)?(pay(.)?later)$/i
</headerPattern>
176 <name>fee_amount
</name>
177 <uniqueName>participant_fee_amount
</uniqueName>
178 <title>Fee Amount
</title>
180 <import>true
</import>
181 <headerPattern>/fee(.?am(ou)?nt)?/i
</headerPattern>
182 <dataPattern>/^\d+(\.\d{
2})?$/
</dataPattern>
183 <comment>actual processor fee if known - may be
0.
</comment>
187 <name>registered_by_id
</name>
188 <uniqueName>participant_registered_by_id
</uniqueName>
189 <type>int unsigned
</type>
190 <title>Registered By ID
</title>
191 <import>true
</import>
192 <default>NULL
</default>
193 <comment>FK to Participant ID
</comment>
195 <export>true
</export>
198 <name>registered_by_id
</name>
199 <table>civicrm_participant
</table>
202 <onDelete>SET NULL
</onDelete>
205 <name>discount_id
</name>
206 <uniqueName>participant_discount_id
</uniqueName>
207 <type>int unsigned
</type>
208 <title>Discount ID
</title>
209 <default>NULL
</default>
210 <comment>FK to Discount ID
</comment>
214 <name>discount_id
</name>
215 <table>civicrm_discount
</table>
218 <onDelete>SET NULL
</onDelete>
221 <name>fee_currency
</name>
222 <uniqueName>participant_fee_currency
</uniqueName>
223 <title>Fee Currency
</title>
226 <default>NULL
</default>
227 <import>true
</import>
228 <headerPattern>/(fee)?.?cur(rency)?/i
</headerPattern>
229 <dataPattern>/^[A-Z]{
3}$/i
</dataPattern>
230 <comment>3 character string, value derived from config setting.
</comment>
233 <table>civicrm_currency
</table>
234 <keyColumn>name
</keyColumn>
235 <labelColumn>full_name
</labelColumn>
236 <nameColumn>name
</nameColumn>
243 <name>campaign_id
</name>
244 <uniqueName>participant_campaign_id
</uniqueName>
245 <type>int unsigned
</type>
246 <title>Campaign
</title>
247 <import>true
</import>
248 <comment>The campaign for which this participant has been registered.
</comment>
250 <table>civicrm_campaign
</table>
251 <keyColumn>id
</keyColumn>
252 <labelColumn>title
</labelColumn>
257 <name>campaign_id
</name>
258 <table>civicrm_campaign
</table>
260 <onDelete>SET NULL
</onDelete>
263 <name>discount_amount
</name>
264 <type>int unsigned
</type>
265 <title>Discount Amount
</title>
266 <comment>Discount Amount
</comment>
271 <type>int unsigned
</type>
272 <title>Event Cart ID
</title>
273 <comment>FK to civicrm_event_carts
</comment>
278 <table>civicrm_event_carts
</table>
280 <onDelete>SET NULL
</onDelete>
283 <name>must_wait
</name>
285 <title>Must Wait on List
</title>
286 <comment>On Waiting List
</comment>
290 <name>transferred_to_contact_id
</name>
291 <uniqueName>transferred_to_contact_id
</uniqueName>
292 <type>int unsigned
</type>
293 <default>NULL
</default>
294 <title>Transferred to Contact ID
</title>
295 <headerPattern>/transfer(.?id)?/i
</headerPattern>
296 <import>true
</import>
297 <comment>FK to Contact ID
</comment>
301 <name>transferred_to_contact_id
</name>
302 <table>civicrm_contact
</table>
304 <onDelete>SET NULL
</onDelete>