1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
5 <class>Participant
</class>
6 <name>civicrm_participant
</name>
12 <uniqueName>participant_id
</uniqueName>
13 <title>Participant ID
</title>
14 <type>int unsigned
</type>
15 <required>true
</required>
16 <comment>Participant Id
</comment>
18 <headerPattern>/(^(participant(.)?)?id$)/i
</headerPattern>
23 <autoincrement>true
</autoincrement>
26 <name>contact_id
</name>
27 <uniqueName>participant_contact_id
</uniqueName>
28 <type>int unsigned
</type>
29 <title>Contact ID
</title>
30 <headerPattern>/contact(.?id)?/i
</headerPattern>
32 <required>true
</required>
33 <comment>FK to Contact ID
</comment>
37 <name>contact_id
</name>
38 <table>civicrm_contact
</table>
40 <onDelete>CASCADE
</onDelete>
44 <type>int unsigned
</type>
47 <headerPattern>/event id$/i
</headerPattern>
48 <required>true
</required>
49 <comment>FK to Event ID
</comment>
54 <table>civicrm_event
</table>
56 <onDelete>CASCADE
</onDelete>
59 <name>status_id
</name>
60 <uniqueName>participant_status_id
</uniqueName>
61 <title>Participant Status
</title>
62 <headerPattern>/(participant.)?(status)$/i
</headerPattern>
64 <type>int unsigned
</type>
66 <required>true
</required>
68 <comment>Participant status ID. FK to civicrm_participant_status_type. Default of
1 should map to status = Registered.
</comment>
71 <table>civicrm_participant_status_type
</table>
72 <keyColumn>id
</keyColumn>
73 <labelColumn>label
</labelColumn>
80 <name>status_id
</name>
81 <table>civicrm_participant_status_type
</table>
86 <name>index_status_id
</name>
87 <fieldName>status_id
</fieldName>
92 <uniqueName>participant_role_id
</uniqueName>
93 <title>Participant Role
</title>
95 <optionGroupName>participant_role
</optionGroupName>
99 <multiple>1</multiple>
101 <serialize>SEPARATOR_TRIMMED
</serialize>
102 <headerPattern>/(participant.)?(role)$/i
</headerPattern>
103 <import>true
</import>
106 <export>true
</export>
107 <default>NULL
</default>
108 <comment>Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.
</comment>
112 <name>index_role_id
</name>
113 <fieldName>role_id
</fieldName>
117 <name>register_date
</name>
118 <uniqueName>participant_register_date
</uniqueName>
119 <title>Register date
</title>
120 <headerPattern>/^(r(egister\s)?date)$/i
</headerPattern>
121 <import>true
</import>
122 <type>datetime
</type>
123 <comment>When did contact register for event?
</comment>
126 <type>Select Date
</type>
127 <formatType>activityDateTime
</formatType>
132 <uniqueName>participant_source
</uniqueName>
133 <title>Participant Source
</title>
134 <headerPattern>/(participant.)?(source)$/i
</headerPattern>
135 <import>true
</import>
138 <comment>Source of this event registration.
</comment>
145 <name>fee_level
</name>
146 <uniqueName>participant_fee_level
</uniqueName>
147 <title>Fee level
</title>
148 <headerPattern>/^(f(ee\s)?level)$/i
</headerPattern>
150 <import>true
</import>
151 <serialize>SEPARATOR_BOOKEND
</serialize>
152 <comment>Populate with the label (text) associated with a fee level for paid events with multiple levels. Note that
153 we store the label value and not the key
</comment>
158 <uniqueName>participant_is_test
</uniqueName>
162 <import>true
</import>
166 <name>is_pay_later
</name>
167 <uniqueName>participant_is_pay_later
</uniqueName>
168 <title>Is Pay Later
</title>
171 <import>true
</import>
172 <headerPattern>/(is.)?(pay(.)?later)$/i
</headerPattern>
177 <name>fee_amount
</name>
178 <uniqueName>participant_fee_amount
</uniqueName>
179 <title>Fee Amount
</title>
181 <import>true
</import>
182 <headerPattern>/fee(.?am(ou)?nt)?/i
</headerPattern>
183 <dataPattern>/^\d+(\.\d{
2})?$/
</dataPattern>
184 <comment>actual processor fee if known - may be
0.
</comment>
188 <name>registered_by_id
</name>
189 <uniqueName>participant_registered_by_id
</uniqueName>
190 <type>int unsigned
</type>
191 <title>Registered By ID
</title>
192 <import>true
</import>
193 <default>NULL
</default>
194 <comment>FK to Participant ID
</comment>
196 <export>true
</export>
199 <name>registered_by_id
</name>
200 <table>civicrm_participant
</table>
203 <onDelete>SET NULL
</onDelete>
206 <name>discount_id
</name>
207 <uniqueName>participant_discount_id
</uniqueName>
208 <type>int unsigned
</type>
209 <title>Discount ID
</title>
210 <default>NULL
</default>
211 <comment>FK to Discount ID
</comment>
215 <name>discount_id
</name>
216 <table>civicrm_discount
</table>
219 <onDelete>SET NULL
</onDelete>
222 <name>fee_currency
</name>
223 <uniqueName>participant_fee_currency
</uniqueName>
224 <title>Fee Currency
</title>
227 <default>NULL
</default>
228 <import>true
</import>
229 <headerPattern>/(fee)?.?cur(rency)?/i
</headerPattern>
230 <dataPattern>/^[A-Z]{
3}$/i
</dataPattern>
231 <comment>3 character string, value derived from config setting.
</comment>
234 <table>civicrm_currency
</table>
235 <keyColumn>name
</keyColumn>
236 <labelColumn>full_name
</labelColumn>
237 <nameColumn>name
</nameColumn>
238 <abbrColumn>symbol
</abbrColumn>
245 <name>campaign_id
</name>
246 <uniqueName>participant_campaign_id
</uniqueName>
247 <type>int unsigned
</type>
248 <title>Campaign
</title>
249 <import>true
</import>
250 <comment>The campaign for which this participant has been registered.
</comment>
252 <table>civicrm_campaign
</table>
253 <keyColumn>id
</keyColumn>
254 <labelColumn>title
</labelColumn>
259 <name>campaign_id
</name>
260 <table>civicrm_campaign
</table>
262 <onDelete>SET NULL
</onDelete>
265 <name>discount_amount
</name>
266 <type>int unsigned
</type>
267 <title>Discount Amount
</title>
268 <comment>Discount Amount
</comment>
273 <type>int unsigned
</type>
274 <title>Event Cart ID
</title>
275 <comment>FK to civicrm_event_carts
</comment>
280 <table>civicrm_event_carts
</table>
282 <onDelete>SET NULL
</onDelete>
285 <name>must_wait
</name>
287 <title>Must Wait on List
</title>
288 <comment>On Waiting List
</comment>
292 <name>transferred_to_contact_id
</name>
293 <uniqueName>transferred_to_contact_id
</uniqueName>
294 <type>int unsigned
</type>
295 <default>NULL
</default>
296 <title>Transferred to Contact ID
</title>
297 <headerPattern>/transfer(.?id)?/i
</headerPattern>
298 <import>true
</import>
299 <comment>FK to Contact ID
</comment>
303 <name>transferred_to_contact_id
</name>
304 <table>civicrm_contact
</table>
306 <onDelete>SET NULL
</onDelete>