Add "labelField" metadata to entities
[civicrm-core.git] / xml / schema / Event / Event.xml
CommitLineData
3f3a3ba0 1<?xml version="1.0" encoding="iso-8859-1" ?>
6a488035 2
3f3a3ba0
CW
3<table>
4 <base>CRM/Event</base>
5 <class>Event</class>
6 <name>civicrm_event</name>
7 <add>1.7</add>
6a488035 8 <log>true</log>
449c4e6b 9 <icon>fa-calendar</icon>
8ab43c93 10 <labelField>title</labelField>
d31fb4e3 11 <component>CiviEvent</component>
a7bd99ff 12 <paths>
5c385299 13 <add>civicrm/event/add?reset=1</add>
a7bd99ff
CW
14 <view>civicrm/event/info?reset=1&amp;id=[id]</view>
15 </paths>
3f3a3ba0
CW
16 <field>
17 <name>id</name>
18 <type>int unsigned</type>
e51b7372 19 <title>Event ID</title>
3f3a3ba0
CW
20 <required>true</required>
21 <comment>Event</comment>
22 <add>1.7</add>
23 </field>
24 <primaryKey>
25 <name>id</name>
26 <autoincrement>true</autoincrement>
27 </primaryKey>
28 <field>
29 <name>title</name>
6a488035 30 <uniqueName>event_title</uniqueName>
3f3a3ba0 31 <type>varchar</type>
6a488035
TO
32 <import>true</import>
33 <title>Event Title</title>
34 <headerPattern>/(event.)?title$/i</headerPattern>
3f3a3ba0 35 <length>255</length>
6a488035
TO
36 <localizable>true</localizable>
37 <comment>Event Title (e.g. Fall Fundraiser Dinner)</comment>
614d72ec 38 <html>
39 <type>Text</type>
40 </html>
3f3a3ba0
CW
41 <add>1.7</add>
42 </field>
43 <field>
6a488035 44 <name>summary</name>
3f3a3ba0
CW
45 <type>text</type>
46 <title>Event Summary</title>
7deea513 47 <html>
48 <type>TextArea</type>
817807ab 49 <rows>4</rows>
50 <cols>60</cols>
7deea513 51 </html>
6a488035
TO
52 <localizable>true</localizable>
53 <comment>Brief summary of event. Text and html allowed. Displayed on Event Registration form and can be used on other CMS pages which need an event summary.</comment>
3f3a3ba0
CW
54 <add>1.7</add>
55 </field>
56 <field>
57 <name>description</name>
58 <type>text</type>
6a488035 59 <uniqueName>event_description</uniqueName>
3f3a3ba0 60 <title>Event Description</title>
7deea513 61 <html>
c413e8dc 62 <type>RichTextEditor</type>
817807ab 63 <rows>8</rows>
64 <cols>60</cols>
7deea513 65 </html>
6a488035
TO
66 <localizable>true</localizable>
67 <comment>Full description of event. Text and html allowed. Displayed on built-in Event Information screens.</comment>
68 <add>1.7</add>
69 </field>
70 <field>
71 <name>event_type_id</name>
72 <type>int unsigned</type>
73 <uniqueName>event_type_id</uniqueName>
7c759b5e 74 <title>Event Type</title>
6a488035
TO
75 <default>0</default>
76 <pseudoconstant>
6a488035 77 <optionGroupName>event_type</optionGroupName>
6a488035 78 </pseudoconstant>
614d72ec 79 <html>
e0991796 80 <type>Select</type>
614d72ec 81 </html>
3f3a3ba0
CW
82 <comment>Event Type ID.Implicit FK to civicrm_option_value where option_group = event_type.</comment>
83 <add>1.7</add>
84 </field>
6a488035
TO
85 <index>
86 <name>index_event_type_id</name>
87 <fieldName>event_type_id</fieldName>
88 <add>1.8</add>
89 </index>
3f3a3ba0
CW
90 <field>
91 <name>participant_listing_id</name>
92 <type>int unsigned</type>
6a488035 93 <uniqueName>participant_listing_id</uniqueName>
7c759b5e 94 <title>Participant Listing</title>
5d4300ea 95 <default>NULL</default>
7c759b5e
CW
96 <pseudoconstant>
97 <optionGroupName>participant_listing</optionGroupName>
98 </pseudoconstant>
3f3a3ba0
CW
99 <comment>Should we expose the participant list? Implicit FK to civicrm_option_value where option_group = participant_listing.</comment>
100 <add>2.0</add>
614d72ec 101 <html>
102 <type>Select</type>
103 </html>
3f3a3ba0 104 </field>
6a488035
TO
105 <index>
106 <name>index_participant_listing_id</name>
107 <fieldName>participant_listing_id</fieldName>
108 <add>2.0</add>
109 </index>
3f3a3ba0
CW
110 <field>
111 <name>is_public</name>
112 <type>boolean</type>
113 <title>Is Event Public</title>
114 <default>1</default>
115 <comment>Public events will be included in the iCal feeds. Access to private event information may be limited using ACLs.</comment>
116 <add>1.7</add>
614d72ec 117 <html>
118 <type>CheckBox</type>
119 </html>
3f3a3ba0 120 </field>
6a488035
TO
121 <field>
122 <name>start_date</name>
123 <type>datetime</type>
124 <uniqueName>event_start_date</uniqueName>
125 <title>Event Start Date</title>
126 <headerPattern>/^start|(s(tart\s)?date)$/i</headerPattern>
127 <import>true</import>
128 <comment>Date and time that event starts.</comment>
129 <add>1.7</add>
614d72ec 130 <html>
131 <type>Select Date</type>
c03ba827 132 <formatType>activityDateTime</formatType>
614d72ec 133 </html>
6a488035
TO
134 </field>
135 <field>
136 <name>end_date</name>
137 <type>datetime</type>
138 <uniqueName>event_end_date</uniqueName>
139 <title>Event End Date</title>
140 <headerPattern>/^end|(e(nd\s)?date)$/i</headerPattern>
141 <import>true</import>
142 <comment>Date and time that event ends. May be NULL if no defined end date/time</comment>
143 <add>1.7</add>
614d72ec 144 <html>
145 <type>Select Date</type>
c03ba827 146 <formatType>activityDateTime</formatType>
614d72ec 147 </html>
6a488035 148 </field>
3f3a3ba0
CW
149 <field>
150 <name>is_online_registration</name>
151 <type>boolean</type>
6a488035 152 <title>Is Online Registration</title>
3f3a3ba0
CW
153 <default>0</default>
154 <comment>If true, include registration link on Event Info page.</comment>
155 <add>1.7</add>
614d72ec 156 <html>
157 <type>CheckBox</type>
158 </html>
6a488035 159 </field>
3f3a3ba0
CW
160 <field>
161 <name>registration_link_text</name>
162 <type>varchar</type>
6a488035 163 <title>Event Registration Link Text</title>
3f3a3ba0 164 <length>255</length>
6a488035
TO
165 <localizable>true</localizable>
166 <comment>Text for link to Event Registration form which is displayed on Event Information screen when is_online_registration is true.</comment>
3f3a3ba0 167 <add>1.7</add>
614d72ec 168 <html>
169 <type>Text</type>
170 </html>
3f3a3ba0 171 </field>
6a488035
TO
172 <field>
173 <name>registration_start_date</name>
174 <type>datetime</type>
175 <comment>Date and time that online registration starts.</comment>
176 <add>1.8</add>
614d72ec 177 <html>
178 <type>Select Date</type>
c03ba827 179 <formatType>activityDateTime</formatType>
614d72ec 180 </html>
6a488035
TO
181 </field>
182 <field>
183 <name>registration_end_date</name>
184 <type>datetime</type>
185 <comment>Date and time that online registration ends.</comment>
186 <add>1.8</add>
614d72ec 187 <html>
188 <type>Select Date</type>
c03ba827 189 <formatType>activityDateTime</formatType>
614d72ec 190 </html>
6a488035 191 </field>
3f3a3ba0
CW
192 <field>
193 <name>max_participants</name>
194 <type>int unsigned</type>
6a488035
TO
195 <title>Max Participants</title>
196 <default>NULL</default>
3f3a3ba0
CW
197 <comment>Maximum number of registered participants to allow. After max is reached, a custom Event Full message is displayed. If NULL, allow unlimited number of participants.</comment>
198 <add>1.7</add>
614d72ec 199 <html>
200 <type>Text</type>
201 </html>
6a488035 202 </field>
3f3a3ba0
CW
203 <field>
204 <name>event_full_text</name>
205 <type>text</type>
6a488035 206 <title>Event Information</title>
7deea513 207 <html>
208 <type>TextArea</type>
817807ab 209 <rows>4</rows>
210 <cols>60</cols>
7deea513 211 </html>
6a488035 212 <localizable>true</localizable>
3f3a3ba0
CW
213 <comment>Message to display on Event Information page and INSTEAD OF Event Registration form if maximum participants are signed up. Can include email address/info about getting on a waiting list, etc. Text and html allowed.</comment>
214 <add>1.7</add>
6a488035 215 </field>
3f3a3ba0
CW
216 <field>
217 <name>is_monetary</name>
6a488035 218 <title>Is this a PAID event?</title>
3f3a3ba0 219 <type>boolean</type>
6a488035 220 <default>0</default>
3f3a3ba0
CW
221 <comment>If true, one or more fee amounts must be set and a Payment Processor must be configured for Online Event Registration.</comment>
222 <add>1.7</add>
614d72ec 223 <html>
224 <type>CheckBox</type>
225 </html>
3f3a3ba0 226 </field>
3f3a3ba0
CW
227 <field>
228 <name>financial_type_id</name>
229 <type>int unsigned</type>
7c759b5e 230 <title>Financial Type</title>
6a488035 231 <default>NULL</default>
6d68a4cb
CW
232 <comment>Financial type assigned to paid event registrations for this event. Required if is_monetary is true.</comment>
233 <pseudoconstant>
234 <table>civicrm_financial_type</table>
235 <keyColumn>id</keyColumn>
236 <labelColumn>name</labelColumn>
237 </pseudoconstant>
614d72ec 238 <html>
e0991796 239 <type>Select</type>
614d72ec 240 </html>
3f3a3ba0 241 <add>4.3</add>
6a488035
TO
242 </field>
243 <field>
244 <name>payment_processor</name>
245 <type>varchar</type>
246 <length>128</length>
476627e4 247 <serialize>SEPARATOR_TRIMMED</serialize>
6a488035 248 <comment>Payment Processors configured for this Event (if is_monetary is true)</comment>
6d68a4cb
CW
249 <pseudoconstant>
250 <table>civicrm_payment_processor</table>
251 <keyColumn>id</keyColumn>
252 <labelColumn>name</labelColumn>
253 </pseudoconstant>
614d72ec 254 <html>
e0991796 255 <type>Select</type>
614d72ec 256 </html>
6a488035
TO
257 <add>1.8</add>
258 </field>
3f3a3ba0 259 <field>
6a488035
TO
260 <name>is_map</name>
261 <title>Map Enabled</title>
3f3a3ba0 262 <type>boolean</type>
6a488035 263 <default>0</default>
3f3a3ba0
CW
264 <comment>Include a map block on the Event Information page when geocode info is available and a mapping provider has been specified?</comment>
265 <add>1.7</add>
614d72ec 266 <html>
267 <type>CheckBox</type>
268 </html>
3f3a3ba0 269 </field>
6a488035
TO
270 <field>
271 <name>is_active</name>
272 <title>Is Active</title>
273 <type>boolean</type>
274 <default>0</default>
3f3a3ba0
CW
275 <comment>Is this Event enabled or disabled/cancelled?</comment>
276 <add>1.7</add>
614d72ec 277 <html>
278 <type>CheckBox</type>
279 </html>
6a488035
TO
280 </field>
281 <field>
282 <name>fee_label</name>
283 <type>varchar</type>
284 <import>true</import>
285 <title>Fee Label</title>
286 <headerPattern>/^fee|(f(ee\s)?label)$/i</headerPattern>
287 <length>255</length>
288 <localizable>true</localizable>
614d72ec 289 <html>
290 <type>Text</type>
291 </html>
6a488035 292 <add>1.8</add>
3f3a3ba0
CW
293 </field>
294 <field>
295 <name>is_show_location</name>
296 <type>boolean</type>
6a488035 297 <title>show location</title>
3f3a3ba0
CW
298 <default>1</default>
299 <comment>If true, show event location.</comment>
300 <add>1.7</add>
614d72ec 301 <html>
302 <type>CheckBox</type>
303 </html>
3f3a3ba0 304 </field>
6a488035
TO
305 <field>
306 <name>loc_block_id</name>
307 <type>int unsigned</type>
308 <title>Location Block ID</title>
309 <comment>FK to Location Block ID</comment>
310 <add>2.0</add>
311 </field>
312 <foreignKey>
313 <name>loc_block_id</name>
314 <table>civicrm_loc_block</table>
315 <key>id</key>
316 <onDelete>SET NULL</onDelete>
317 <add>2.0</add>
318 </foreignKey>
3f3a3ba0
CW
319 <field>
320 <name>default_role_id</name>
6a488035 321 <uniqueName>default_role_id</uniqueName>
35b13852 322 <title>Default Role</title>
6a488035 323 <import>true</import>
3f3a3ba0 324 <type>int unsigned</type>
6a488035 325 <default>1</default>
7c759b5e
CW
326 <pseudoconstant>
327 <optionGroupName>participant_role</optionGroupName>
328 </pseudoconstant>
3f3a3ba0
CW
329 <comment>Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.</comment>
330 <add>2.0</add>
614d72ec 331 <html>
332 <type>Select</type>
333 </html>
6a488035 334 </field>
3f3a3ba0
CW
335 <field>
336 <name>intro_text</name>
337 <type>text</type>
7deea513 338 <html>
c413e8dc 339 <type>RichTextEditor</type>
817807ab 340 <rows>6</rows>
341 <cols>50</cols>
7deea513 342 </html>
6a488035
TO
343 <title>Introductory Message</title>
344 <localizable>true</localizable>
345 <comment>Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.</comment>
3f3a3ba0
CW
346 <add>1.7</add>
347 </field>
348 <field>
349 <name>footer_text</name>
6a488035 350 <title>Footer Message</title>
3f3a3ba0 351 <type>text</type>
7deea513 352 <html>
c413e8dc 353 <type>RichTextEditor</type>
817807ab 354 <rows>6</rows>
355 <cols>50</cols>
7deea513 356 </html>
6a488035
TO
357 <localizable>true</localizable>
358 <comment>Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.</comment>
3f3a3ba0
CW
359 <add>1.7</add>
360 </field>
361 <field>
362 <name>confirm_title</name>
363 <type>varchar</type>
6a488035 364 <title>Confirmation Title</title>
3f3a3ba0 365 <length>255</length>
6a488035
TO
366 <default>NULL</default>
367 <localizable>true</localizable>
368 <comment>Title for Confirmation page.</comment>
614d72ec 369 <html>
370 <type>Text</type>
371 </html>
3f3a3ba0
CW
372 <add>1.7</add>
373 </field>
374 <field>
375 <name>confirm_text</name>
376 <type>text</type>
7deea513 377 <html>
c413e8dc 378 <type>RichTextEditor</type>
817807ab 379 <rows>6</rows>
380 <cols>50</cols>
7deea513 381 </html>
6a488035
TO
382 <title>Confirm Text</title>
383 <localizable>true</localizable>
384 <comment>Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.</comment>
3f3a3ba0
CW
385 <add>1.7</add>
386 </field>
387 <field>
388 <name>confirm_footer_text</name>
389 <type>text</type>
6a488035 390 <title>Footer Text</title>
7deea513 391 <html>
c413e8dc 392 <type>RichTextEditor</type>
817807ab 393 <rows>6</rows>
394 <cols>50</cols>
7deea513 395 </html>
6a488035
TO
396 <localizable>true</localizable>
397 <comment>Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.</comment>
3f3a3ba0
CW
398 <add>1.7</add>
399 </field>
400 <field>
401 <name>is_email_confirm</name>
402 <type>boolean</type>
6a488035 403 <title>Is confirm email</title>
3f3a3ba0
CW
404 <default>0</default>
405 <comment>If true, confirmation is automatically emailed to contact on successful registration.</comment>
406 <add>1.7</add>
614d72ec 407 <html>
408 <type>CheckBox</type>
409 </html>
3f3a3ba0
CW
410 </field>
411 <field>
412 <name>confirm_email_text</name>
413 <type>text</type>
6a488035 414 <title>Confirmation Email Text</title>
7deea513 415 <html>
416 <type>TextArea</type>
817807ab 417 <rows>4</rows>
418 <cols>50</cols>
7deea513 419 </html>
6a488035
TO
420 <localizable>true</localizable>
421 <comment>text to include above standard event info on confirmation email. emails are text-only, so do not allow html for now</comment>
3f3a3ba0
CW
422 <add>1.7</add>
423 </field>
424 <field>
425 <name>confirm_from_name</name>
426 <type>varchar</type>
6a488035 427 <title>Confirm From Name</title>
3f3a3ba0 428 <length>255</length>
6a488035
TO
429 <localizable>true</localizable>
430 <comment>FROM email name used for confirmation emails.</comment>
3f3a3ba0 431 <add>1.7</add>
614d72ec 432 <html>
433 <type>Text</type>
434 </html>
6a488035 435 </field>
3f3a3ba0
CW
436 <field>
437 <name>confirm_from_email</name>
438 <type>varchar</type>
6a488035 439 <title>Confirm From Email</title>
3f3a3ba0 440 <length>255</length>
6a488035 441 <comment>FROM email address used for confirmation emails.</comment>
3f3a3ba0 442 <add>1.7</add>
614d72ec 443 <html>
444 <type>Text</type>
445 </html>
3f3a3ba0
CW
446 </field>
447 <field>
448 <name>cc_confirm</name>
449 <type>varchar</type>
450 <length>255</length>
6a488035 451 <comment>comma-separated list of email addresses to cc each time a confirmation is sent</comment>
614d72ec 452 <html>
453 <type>Text</type>
454 </html>
3f3a3ba0 455 <add>1.7</add>
6a488035 456 </field>
3f3a3ba0
CW
457 <field>
458 <name>bcc_confirm</name>
459 <type>varchar</type>
460 <length>255</length>
6a488035 461 <comment>comma-separated list of email addresses to bcc each time a confirmation is sent</comment>
614d72ec 462 <html>
463 <type>Text</type>
464 </html>
3f3a3ba0 465 <add>1.7</add>
6a488035
TO
466 </field>
467 <field>
468 <name>default_fee_id</name>
469 <type>int unsigned</type>
470 <title>Default Fee ID</title>
471 <comment>FK to civicrm_option_value.</comment>
472 <add>1.7</add>
473 </field>
474 <field>
475 <name>default_discount_fee_id</name>
476 <type>int unsigned</type>
477 <title>Default Discount Fee ID</title>
478 <comment>FK to civicrm_option_value.</comment>
479 <add>1.7</add>
480 </field>
3f3a3ba0
CW
481 <field>
482 <name>thankyou_title</name>
483 <type>varchar</type>
6a488035 484 <title>ThankYou Title</title>
3f3a3ba0 485 <length>255</length>
6a488035
TO
486 <default>NULL</default>
487 <localizable>true</localizable>
488 <comment>Title for ThankYou page.</comment>
3f3a3ba0 489 <add>1.7</add>
614d72ec 490 <html>
491 <type>Text</type>
492 </html>
3f3a3ba0
CW
493 </field>
494 <field>
495 <name>thankyou_text</name>
496 <type>text</type>
7deea513 497 <html>
c413e8dc 498 <type>RichTextEditor</type>
817807ab 499 <rows>6</rows>
500 <cols>50</cols>
7deea513 501 </html>
6a488035
TO
502 <title>ThankYou Text</title>
503 <localizable>true</localizable>
504 <comment>ThankYou Text.</comment>
3f3a3ba0
CW
505 <add>1.7</add>
506 </field>
507 <field>
508 <name>thankyou_footer_text</name>
509 <type>text</type>
6a488035 510 <title>Footer Text</title>
7deea513 511 <html>
c413e8dc 512 <type>RichTextEditor</type>
817807ab 513 <rows>6</rows>
514 <cols>50</cols>
7deea513 515 </html>
6a488035
TO
516 <localizable>true</localizable>
517 <comment>Footer message.</comment>
3f3a3ba0
CW
518 <add>1.7</add>
519 </field>
520 <field>
6a488035
TO
521 <name>is_pay_later</name>
522 <title>Pay Later Allowed</title>
523 <type>boolean</type>
524 <default>0</default>
3f3a3ba0
CW
525 <comment>if true - allows the user to send payment directly to the org later</comment>
526 <add>2.0</add>
614d72ec 527 <html>
528 <type>CheckBox</type>
529 </html>
6a488035 530 </field>
3f3a3ba0 531 <field>
6a488035
TO
532 <name>pay_later_text</name>
533 <title>Pay Later Text</title>
534 <type>text</type>
535 <localizable>true</localizable>
3f3a3ba0 536 <comment>The text displayed to the user in the main form</comment>
6a488035 537 <add>2.0</add>
614d72ec 538 <html>
c413e8dc 539 <type>RichTextEditor</type>
614d72ec 540 </html>
6a488035
TO
541 </field>
542 <field>
543 <name>pay_later_receipt</name>
544 <title>Pay Later Receipt Text</title>
545 <type>text</type>
546 <localizable>true</localizable>
3f3a3ba0 547 <comment>The receipt sent to the user instead of the normal receipt text</comment>
6a488035 548 <add>2.0</add>
614d72ec 549 <html>
550 <type>Text</type>
551 </html>
6a488035 552 </field>
3f3a3ba0 553 <field>
6a488035
TO
554 <name>is_partial_payment</name>
555 <title>Partial Payments Enabled</title>
3f3a3ba0
CW
556 <type>boolean</type>
557 <default>0</default>
558 <comment>is partial payment enabled for this event</comment>
559 <add>4.3</add>
614d72ec 560 <html>
561 <type>CheckBox</type>
562 </html>
6a488035 563 </field>
3f3a3ba0 564 <field>
6a488035
TO
565 <name>initial_amount_label</name>
566 <title>Initial Amount Label</title>
567 <type>varchar</type>
3f3a3ba0 568 <length>255</length>
6a488035 569 <localizable>true</localizable>
3f3a3ba0
CW
570 <comment>Initial amount label for partial payment</comment>
571 <add>4.3</add>
614d72ec 572 <html>
573 <type>Text</type>
574 </html>
6a488035 575 </field>
3f3a3ba0 576 <field>
6a488035
TO
577 <name>initial_amount_help_text</name>
578 <title>Initial Amount Help Text</title>
579 <type>text</type>
580 <localizable>true</localizable>
3f3a3ba0
CW
581 <comment>Initial amount help text for partial payment</comment>
582 <add>4.3</add>
614d72ec 583 <html>
584 <type>Text</type>
585 </html>
6a488035 586 </field>
3f3a3ba0 587 <field>
6a488035
TO
588 <name>min_initial_amount</name>
589 <title>Minimum Initial Amount</title>
590 <type>decimal</type>
3f3a3ba0
CW
591 <comment>Minimum initial amount for partial payment</comment>
592 <add>4.3</add>
614d72ec 593 <html>
594 <type>Text</type>
595 </html>
6a488035 596 </field>
3f3a3ba0 597 <field>
6a488035
TO
598 <name>is_multiple_registrations</name>
599 <title>Allow Multiple Registrations</title>
600 <type>boolean</type>
601 <default>0</default>
3f3a3ba0
CW
602 <comment>if true - allows the user to register multiple participants for event</comment>
603 <add>2.1</add>
614d72ec 604 <html>
605 <type>CheckBox</type>
606 </html>
6a488035 607 </field>
f1bc01e0
J
608 <field>
609 <name>max_additional_participants</name>
610 <type>int unsigned</type>
611 <title>Maximum number of additional participants per registration</title>
612 <default>0</default>
613 <comment>Maximum number of additional participants that can be registered on a single booking</comment>
675cca92 614 <add>4.7</add>
f1bc01e0 615 </field>
3f3a3ba0
CW
616 <field>
617 <name>allow_same_participant_emails</name>
618 <type>boolean</type>
6a488035 619 <title>Does Event allow multiple registrations from same email address?</title>
3f3a3ba0
CW
620 <default>0</default>
621 <comment>if true - allows the user to register multiple registrations from same email address.</comment>
622 <add>2.2</add>
614d72ec 623 <html>
624 <type>CheckBox</type>
625 </html>
3f3a3ba0 626 </field>
6a488035
TO
627 <field>
628 <name>has_waitlist</name>
629 <title>Waitlist Enabled</title>
630 <type>boolean</type>
631 <comment>Whether the event has waitlist support.</comment>
632 <add>3.0</add>
614d72ec 633 <html>
634 <type>CheckBox</type>
635 </html>
6a488035
TO
636 </field>
637 <field>
638 <name>requires_approval</name>
639 <type>boolean</type>
640 <comment>Whether participants require approval before they can finish registering.</comment>
641 <add>3.0</add>
614d72ec 642 <html>
643 <type>CheckBox</type>
644 </html>
6a488035
TO
645 </field>
646 <field>
647 <name>expiration_time</name>
648 <type>int unsigned</type>
649 <comment>Expire pending but unconfirmed registrations after this many hours.</comment>
650 <add>3.0</add>
614d72ec 651 <html>
652 <type>Text</type>
653 </html>
6a488035 654 </field>
7dbb67ae
DG
655 <field>
656 <name>allow_selfcancelxfer</name>
657 <type>boolean</type>
658 <default>0</default>
659 <title>Allow Self-service Cancellation or Transfer</title>
660 <comment>Allow self service cancellation or transfer for event?</comment>
661 <add>4.7</add>
662 <html>
663 <type>CheckBox</type>
664 </html>
665 </field>
666 <field>
667 <name>selfcancelxfer_time</name>
a54cf42b 668 <type>int</type>
7dbb67ae
DG
669 <default>0</default>
670 <title>Self-service Cancellation or Transfer Time</title>
671 <comment>Number of hours prior to event start date to allow self-service cancellation or transfer.</comment>
672 <add>4.7</add>
673 <html>
674 <type>Text</type>
675 </html>
676 </field>
6a488035
TO
677 <field>
678 <name>waitlist_text</name>
679 <type>text</type>
7deea513 680 <html>
681 <type>TextArea</type>
817807ab 682 <rows>4</rows>
683 <cols>60</cols>
7deea513 684 </html>
6a488035
TO
685 <localizable>true</localizable>
686 <comment>Text to display when the event is full, but participants can signup for a waitlist.</comment>
687 <add>3.0</add>
688 </field>
689 <field>
690 <name>approval_req_text</name>
691 <type>text</type>
7deea513 692 <html>
693 <type>TextArea</type>
817807ab 694 <rows>4</rows>
695 <cols>60</cols>
7deea513 696 </html>
6a488035
TO
697 <localizable>true</localizable>
698 <comment>Text to display when the approval is required to complete registration for an event.</comment>
699 <add>3.0</add>
700 </field>
701 <field>
702 <name>is_template</name>
703 <title>Is an Event Template</title>
704 <type>boolean</type>
705 <default>0</default>
99f13d8d 706 <required>true</required>
6a488035
TO
707 <comment>whether the event has template</comment>
708 <add>3.0</add>
614d72ec 709 <html>
710 <type>CheckBox</type>
711 </html>
6a488035 712 </field>
3f3a3ba0
CW
713 <field>
714 <name>template_title</name>
6a488035 715 <uniqueName>template_title</uniqueName>
3f3a3ba0 716 <type>varchar</type>
6a488035
TO
717 <import>true</import>
718 <title>Event Template Title</title>
719 <headerPattern>/(template.)?title$/i</headerPattern>
3f3a3ba0 720 <length>255</length>
6a488035
TO
721 <localizable>true</localizable>
722 <comment>Event Template Title</comment>
614d72ec 723 <html>
724 <type>Text</type>
725 </html>
3f3a3ba0 726 <add>3.0</add>
6a488035
TO
727 </field>
728 <field>
729 <name>created_id</name>
730 <type>int unsigned</type>
731 <title>Created By Contact ID</title>
732 <comment>FK to civicrm_contact, who created this event</comment>
733 <add>3.0</add>
734 </field>
735 <foreignKey>
736 <name>created_id</name>
737 <table>civicrm_contact</table>
738 <key>id</key>
739 <add>3.0</add>
740 <onDelete>SET NULL</onDelete>
741 </foreignKey>
742 <field>
743 <name>created_date</name>
744 <type>datetime</type>
745 <title>Event Created Date</title>
746 <comment>Date and time that event was created.</comment>
747 <add>3.0</add>
748 </field>
3f3a3ba0
CW
749 <field>
750 <name>currency</name>
751 <type>varchar</type>
6a488035
TO
752 <length>3</length>
753 <import>true</import>
754 <headerPattern>/cur(rency)?/i</headerPattern>
755 <dataPattern>/^[A-Z]{3}$/i</dataPattern>
756 <comment>3 character string, value from config setting or input via user.</comment>
757 <add>3.3</add>
bd44e0df
AS
758 <pseudoconstant>
759 <table>civicrm_currency</table>
760 <keyColumn>name</keyColumn>
a38a89fc 761 <labelColumn>full_name</labelColumn>
c3de5c5a 762 <nameColumn>name</nameColumn>
a8fdb24e 763 <abbrColumn>symbol</abbrColumn>
bd44e0df 764 </pseudoconstant>
614d72ec 765 <html>
e0991796 766 <type>Select</type>
614d72ec 767 </html>
6a488035
TO
768 </field>
769 <field>
770 <name>campaign_id</name>
771 <type>int unsigned</type>
e1ab2e91 772 <title>Campaign</title>
6a488035 773 <comment>The campaign for which this event has been created.</comment>
3e3eacd0
CW
774 <pseudoconstant>
775 <table>civicrm_campaign</table>
776 <keyColumn>id</keyColumn>
777 <labelColumn>title</labelColumn>
3e3eacd0 778 </pseudoconstant>
3f3a3ba0 779 <add>3.4</add>
614d72ec 780 <html>
916b6181 781 <type>EntityRef</type>
614d72ec 782 </html>
6a488035
TO
783 </field>
784 <foreignKey>
785 <name>campaign_id</name>
786 <table>civicrm_campaign</table>
787 <key>id</key>
788 <onDelete>SET NULL</onDelete>
789 </foreignKey>
790 <field>
791 <name>is_share</name>
792 <title>Is shared through social media</title>
793 <type>boolean</type>
794 <default>1</default>
795 <comment>Can people share the event through social media?</comment>
3f3a3ba0 796 <add>4.1</add>
614d72ec 797 <html>
798 <type>CheckBox</type>
799 </html>
6a488035 800 </field>
1909126f 801 <field>
802 <name>is_confirm_enabled</name>
803 <title>Is the booking confirmation screen enabled?</title>
804 <type>boolean</type>
805 <default>1</default>
806 <comment>If false, the event booking confirmation screen gets skipped</comment>
807 <add>4.5</add>
808 <html>
809 <type>CheckBox</type>
810 </html>
811 </field>
6a488035
TO
812 <field>
813 <name>parent_event_id</name>
814 <type>int unsigned</type>
815 <title>Parent Event ID</title>
816 <default>NULL</default>
817 <comment>Implicit FK to civicrm_event: parent event</comment>
614d72ec 818 <html>
916b6181 819 <type>EntityRef</type>
614d72ec 820 </html>
6a488035
TO
821 <add>4.1</add>
822 </field>
823 <index>
824 <name>index_parent_event_id</name>
825 <fieldName>parent_event_id</fieldName>
826 <add>4.1</add>
827 </index>
828 <field>
829 <name>slot_label_id</name>
3f3a3ba0
CW
830 <type>int unsigned</type>
831 <title>Subevent Slot Label ID</title>
6a488035 832 <default>NULL</default>
3f3a3ba0 833 <comment>Subevent slot label. Implicit FK to civicrm_option_value where option_group = conference_slot.</comment>
6a488035 834 <add>4.1</add>
614d72ec 835 <html>
836 <type>Select</type>
837 </html>
6a488035 838 </field>
03390e26 839 <field>
840 <name>dedupe_rule_group_id</name>
841 <type>int unsigned</type>
842 <title>Dedupe Rule</title>
843 <default>NULL</default>
844 <comment>Rule to use when matching registrations for this event</comment>
845 <pseudoconstant>
846 <table>civicrm_dedupe_rule_group</table>
847 <keyColumn>id</keyColumn>
848 <nameColumn>name</nameColumn>
849 <labelColumn>title</labelColumn>
850 </pseudoconstant>
851 <add>4.5</add>
852 <html>
853 <type>Select</type>
854 </html>
855 </field>
856 <foreignKey>
857 <name>dedupe_rule_group_id</name>
858 <table>civicrm_dedupe_rule_group</table>
859 <key>id</key>
860 <add>4.5</add>
861 </foreignKey>
e45f6ab0
PB
862 <field>
863 <name>is_billing_required</name>
115fa278 864 <title>Is billing block required</title>
e45f6ab0
PB
865 <type>boolean</type>
866 <default>0</default>
115fa278 867 <comment>if true than billing block is required this event</comment>
868 <add>4.6</add>
e45f6ab0
PB
869 <html>
870 <type>CheckBox</type>
871 </html>
872 </field>
6a488035 873</table>