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>
24 <autoincrement>true
</autoincrement>
27 <name>contact_id
</name>
28 <uniqueName>participant_contact_id
</uniqueName>
29 <type>int unsigned
</type>
30 <title>Contact ID
</title>
31 <headerPattern>/contact(.?id)?/i
</headerPattern>
33 <required>true
</required>
34 <comment>FK to Contact ID
</comment>
38 <name>contact_id
</name>
39 <table>civicrm_contact
</table>
41 <onDelete>CASCADE
</onDelete>
45 <type>int unsigned
</type>
48 <headerPattern>/event id$/i
</headerPattern>
49 <required>true
</required>
50 <comment>FK to Event ID
</comment>
55 <table>civicrm_event
</table>
57 <onDelete>CASCADE
</onDelete>
60 <name>status_id
</name>
61 <uniqueName>participant_status_id
</uniqueName>
62 <title>Participant Status
</title>
63 <headerPattern>/(participant.)?(status)$/i
</headerPattern>
65 <type>int unsigned
</type>
67 <required>true
</required>
69 <comment>Participant status ID. FK to civicrm_participant_status_type. Default of
1 should map to status = Registered.
</comment>
72 <table>civicrm_participant_status_type
</table>
73 <keyColumn>id
</keyColumn>
74 <labelColumn>label
</labelColumn>
81 <name>status_id
</name>
82 <table>civicrm_participant_status_type
</table>
87 <name>index_status_id
</name>
88 <fieldName>status_id
</fieldName>
93 <uniqueName>participant_role_id
</uniqueName>
94 <title>Participant Role
</title>
96 <optionGroupName>participant_role
</optionGroupName>
100 <multiple>1</multiple>
102 <serialize>SEPARATOR_TRIMMED
</serialize>
103 <headerPattern>/(participant.)?(role)$/i
</headerPattern>
104 <import>true
</import>
107 <export>true
</export>
108 <default>NULL
</default>
109 <comment>Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.
</comment>
113 <name>index_role_id
</name>
114 <fieldName>role_id
</fieldName>
118 <name>register_date
</name>
119 <uniqueName>participant_register_date
</uniqueName>
120 <title>Register date
</title>
121 <headerPattern>/^(r(egister\s)?date)$/i
</headerPattern>
122 <import>true
</import>
123 <type>datetime
</type>
124 <comment>When did contact register for event?
</comment>
127 <type>Select Date
</type>
128 <formatType>activityDateTime
</formatType>
133 <uniqueName>participant_source
</uniqueName>
134 <title>Participant Source
</title>
135 <headerPattern>/(participant.)?(source)$/i
</headerPattern>
136 <import>true
</import>
139 <comment>Source of this event registration.
</comment>
146 <name>fee_level
</name>
147 <uniqueName>participant_fee_level
</uniqueName>
148 <title>Fee level
</title>
149 <headerPattern>/^(f(ee\s)?level)$/i
</headerPattern>
151 <import>true
</import>
152 <serialize>SEPARATOR_BOOKEND
</serialize>
153 <comment>Populate with the label (text) associated with a fee level for paid events with multiple levels. Note that
154 we store the label value and not the key
</comment>
159 <uniqueName>participant_is_test
</uniqueName>
163 <import>true
</import>
167 <name>is_pay_later
</name>
168 <uniqueName>participant_is_pay_later
</uniqueName>
169 <title>Is Pay Later
</title>
172 <import>true
</import>
173 <headerPattern>/(is.)?(pay(.)?later)$/i
</headerPattern>
178 <name>fee_amount
</name>
179 <uniqueName>participant_fee_amount
</uniqueName>
180 <title>Fee Amount
</title>
182 <import>true
</import>
183 <headerPattern>/fee(.?am(ou)?nt)?/i
</headerPattern>
184 <dataPattern>/^\d+(\.\d{
2})?$/
</dataPattern>
185 <comment>actual processor fee if known - may be
0.
</comment>
189 <name>registered_by_id
</name>
190 <uniqueName>participant_registered_by_id
</uniqueName>
191 <type>int unsigned
</type>
192 <title>Registered By ID
</title>
193 <import>true
</import>
194 <default>NULL
</default>
195 <comment>FK to Participant ID
</comment>
197 <export>true
</export>
200 <name>registered_by_id
</name>
201 <table>civicrm_participant
</table>
204 <onDelete>SET NULL
</onDelete>
207 <name>discount_id
</name>
208 <uniqueName>participant_discount_id
</uniqueName>
209 <type>int unsigned
</type>
210 <title>Discount ID
</title>
211 <default>NULL
</default>
212 <comment>FK to Discount ID
</comment>
216 <name>discount_id
</name>
217 <table>civicrm_discount
</table>
220 <onDelete>SET NULL
</onDelete>
223 <name>fee_currency
</name>
224 <uniqueName>participant_fee_currency
</uniqueName>
225 <title>Fee Currency
</title>
228 <default>NULL
</default>
229 <import>true
</import>
230 <headerPattern>/(fee)?.?cur(rency)?/i
</headerPattern>
231 <dataPattern>/^[A-Z]{
3}$/i
</dataPattern>
232 <comment>3 character string, value derived from config setting.
</comment>
235 <table>civicrm_currency
</table>
236 <keyColumn>name
</keyColumn>
237 <labelColumn>full_name
</labelColumn>
238 <nameColumn>name
</nameColumn>
239 <abbrColumn>symbol
</abbrColumn>
246 <name>campaign_id
</name>
247 <uniqueName>participant_campaign_id
</uniqueName>
248 <type>int unsigned
</type>
249 <title>Campaign
</title>
250 <import>true
</import>
251 <comment>The campaign for which this participant has been registered.
</comment>
253 <table>civicrm_campaign
</table>
254 <keyColumn>id
</keyColumn>
255 <labelColumn>title
</labelColumn>
260 <name>campaign_id
</name>
261 <table>civicrm_campaign
</table>
263 <onDelete>SET NULL
</onDelete>
266 <name>discount_amount
</name>
267 <type>int unsigned
</type>
268 <title>Discount Amount
</title>
269 <comment>Discount Amount
</comment>
274 <type>int unsigned
</type>
275 <title>Event Cart ID
</title>
276 <comment>FK to civicrm_event_carts
</comment>
281 <table>civicrm_event_carts
</table>
283 <onDelete>SET NULL
</onDelete>
286 <name>must_wait
</name>
288 <title>Must Wait on List
</title>
289 <comment>On Waiting List
</comment>
293 <name>transferred_to_contact_id
</name>
294 <uniqueName>transferred_to_contact_id
</uniqueName>
295 <type>int unsigned
</type>
296 <default>NULL
</default>
297 <title>Transferred to Contact ID
</title>
298 <headerPattern>/transfer(.?id)?/i
</headerPattern>
299 <import>true
</import>
300 <comment>FK to Contact ID
</comment>
304 <name>transferred_to_contact_id
</name>
305 <table>civicrm_contact
</table>
307 <onDelete>SET NULL
</onDelete>