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