1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
6 <name>civicrm_event
</name>
9 <icon>fa-calendar
</icon>
12 <type>int unsigned
</type>
13 <title>Event ID
</title>
14 <required>true
</required>
15 <comment>Event
</comment>
20 <autoincrement>true
</autoincrement>
24 <uniqueName>event_title
</uniqueName>
27 <title>Event Title
</title>
28 <headerPattern>/(event.)?title$/i
</headerPattern>
30 <localizable>true
</localizable>
31 <comment>Event Title (e.g. Fall Fundraiser Dinner)
</comment>
40 <title>Event Summary
</title>
46 <localizable>true
</localizable>
47 <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>
51 <name>description
</name>
53 <uniqueName>event_description
</uniqueName>
54 <title>Event Description
</title>
56 <type>RichTextEditor
</type>
60 <localizable>true
</localizable>
61 <comment>Full description of event. Text and html allowed. Displayed on built-in Event Information screens.
</comment>
65 <name>event_type_id
</name>
66 <type>int unsigned
</type>
67 <uniqueName>event_type_id
</uniqueName>
68 <title>Event Type
</title>
71 <optionGroupName>event_type
</optionGroupName>
76 <comment>Event Type ID.Implicit FK to civicrm_option_value where option_group = event_type.
</comment>
80 <name>index_event_type_id
</name>
81 <fieldName>event_type_id
</fieldName>
85 <name>participant_listing_id
</name>
86 <type>int unsigned
</type>
87 <uniqueName>participant_listing_id
</uniqueName>
88 <title>Participant Listing
</title>
89 <default>NULL
</default>
91 <optionGroupName>participant_listing
</optionGroupName>
93 <comment>Should we expose the participant list? Implicit FK to civicrm_option_value where option_group = participant_listing.
</comment>
100 <name>index_participant_listing_id
</name>
101 <fieldName>participant_listing_id
</fieldName>
105 <name>is_public
</name>
107 <title>Is Event Public
</title>
109 <comment>Public events will be included in the iCal feeds. Access to private event information may be limited using ACLs.
</comment>
112 <type>CheckBox
</type>
116 <name>start_date
</name>
117 <type>datetime
</type>
118 <uniqueName>event_start_date
</uniqueName>
119 <title>Event Start Date
</title>
120 <headerPattern>/^start|(s(tart\s)?date)$/i
</headerPattern>
121 <import>true
</import>
122 <comment>Date and time that event starts.
</comment>
125 <type>Select Date
</type>
126 <formatType>activityDateTime
</formatType>
130 <name>end_date
</name>
131 <type>datetime
</type>
132 <uniqueName>event_end_date
</uniqueName>
133 <title>Event End Date
</title>
134 <headerPattern>/^end|(e(nd\s)?date)$/i
</headerPattern>
135 <import>true
</import>
136 <comment>Date and time that event ends. May be NULL if no defined end date/time
</comment>
139 <type>Select Date
</type>
140 <formatType>activityDateTime
</formatType>
144 <name>is_online_registration
</name>
146 <title>Is Online Registration
</title>
148 <comment>If true, include registration link on Event Info page.
</comment>
151 <type>CheckBox
</type>
155 <name>registration_link_text
</name>
157 <title>Event Registration Link Text
</title>
159 <localizable>true
</localizable>
160 <comment>Text for link to Event Registration form which is displayed on Event Information screen when is_online_registration is true.
</comment>
167 <name>registration_start_date
</name>
168 <type>datetime
</type>
169 <comment>Date and time that online registration starts.
</comment>
172 <type>Select Date
</type>
173 <formatType>activityDateTime
</formatType>
177 <name>registration_end_date
</name>
178 <type>datetime
</type>
179 <comment>Date and time that online registration ends.
</comment>
182 <type>Select Date
</type>
183 <formatType>activityDateTime
</formatType>
187 <name>max_participants
</name>
188 <type>int unsigned
</type>
189 <title>Max Participants
</title>
190 <default>NULL
</default>
191 <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 <name>event_full_text
</name>
200 <title>Event Information
</title>
202 <type>TextArea
</type>
206 <localizable>true
</localizable>
207 <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>
211 <name>is_monetary
</name>
212 <title>Is this a PAID event?
</title>
215 <comment>If true, one or more fee amounts must be set and a Payment Processor must be configured for Online Event Registration.
</comment>
218 <type>CheckBox
</type>
222 <name>contribution_type_id
</name>
223 <type>int unsigned
</type>
225 <comment>Contribution type assigned to paid event registrations for this event. Required if is_monetary is true.
</comment>
230 <name>financial_type_id
</name>
231 <type>int unsigned
</type>
232 <title>Financial Type
</title>
233 <default>NULL
</default>
234 <comment>Financial type assigned to paid event registrations for this event. Required if is_monetary is true.
</comment>
236 <table>civicrm_financial_type
</table>
237 <keyColumn>id
</keyColumn>
238 <labelColumn>name
</labelColumn>
246 <name>payment_processor
</name>
249 <serialize>SEPARATOR_TRIMMED
</serialize>
250 <comment>Payment Processors configured for this Event (if is_monetary is true)
</comment>
252 <table>civicrm_payment_processor
</table>
253 <keyColumn>id
</keyColumn>
254 <labelColumn>name
</labelColumn>
263 <title>Map Enabled
</title>
266 <comment>Include a map block on the Event Information page when geocode info is available and a mapping provider has been specified?
</comment>
269 <type>CheckBox
</type>
273 <name>is_active
</name>
274 <title>Is Active
</title>
277 <comment>Is this Event enabled or disabled/cancelled?
</comment>
280 <type>CheckBox
</type>
284 <name>fee_label
</name>
286 <import>true
</import>
287 <title>Fee Label
</title>
288 <headerPattern>/^fee|(f(ee\s)?label)$/i
</headerPattern>
290 <localizable>true
</localizable>
297 <name>is_show_location
</name>
299 <title>show location
</title>
301 <comment>If true, show event location.
</comment>
304 <type>CheckBox
</type>
308 <name>loc_block_id
</name>
309 <type>int unsigned
</type>
310 <title>Location Block ID
</title>
311 <comment>FK to Location Block ID
</comment>
315 <name>loc_block_id
</name>
316 <table>civicrm_loc_block
</table>
318 <onDelete>SET NULL
</onDelete>
322 <name>receipt_text
</name>
325 <type>TextArea
</type>
330 <comment>Receipt Text for off-line event participation
</comment>
335 <name>default_role_id
</name>
336 <uniqueName>default_role_id
</uniqueName>
337 <title>Default Role
</title>
338 <import>true
</import>
339 <type>int unsigned
</type>
342 <optionGroupName>participant_role
</optionGroupName>
344 <comment>Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.
</comment>
351 <name>intro_text
</name>
354 <type>RichTextEditor
</type>
358 <title>Introductory Message
</title>
359 <localizable>true
</localizable>
360 <comment>Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.
</comment>
364 <name>footer_text
</name>
365 <title>Footer Message
</title>
368 <type>RichTextEditor
</type>
372 <localizable>true
</localizable>
373 <comment>Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.
</comment>
377 <name>confirm_title
</name>
379 <title>Confirmation Title
</title>
381 <default>NULL
</default>
382 <localizable>true
</localizable>
383 <comment>Title for Confirmation page.
</comment>
390 <name>confirm_text
</name>
393 <type>RichTextEditor
</type>
397 <title>Confirm Text
</title>
398 <localizable>true
</localizable>
399 <comment>Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.
</comment>
403 <name>confirm_footer_text
</name>
405 <title>Footer Text
</title>
407 <type>RichTextEditor
</type>
411 <localizable>true
</localizable>
412 <comment>Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.
</comment>
416 <name>is_email_confirm
</name>
418 <title>Is confirm email
</title>
420 <comment>If true, confirmation is automatically emailed to contact on successful registration.
</comment>
423 <type>CheckBox
</type>
427 <name>confirm_email_text
</name>
429 <title>Confirmation Email Text
</title>
431 <type>TextArea
</type>
435 <localizable>true
</localizable>
436 <comment>text to include above standard event info on confirmation email. emails are text-only, so do not allow html for now
</comment>
440 <name>confirm_from_name
</name>
442 <title>Confirm From Name
</title>
444 <localizable>true
</localizable>
445 <comment>FROM email name used for confirmation emails.
</comment>
452 <name>confirm_from_email
</name>
454 <title>Confirm From Email
</title>
456 <comment>FROM email address used for confirmation emails.
</comment>
463 <name>cc_confirm
</name>
466 <comment>comma-separated list of email addresses to cc each time a confirmation is sent
</comment>
473 <name>bcc_confirm
</name>
476 <comment>comma-separated list of email addresses to bcc each time a confirmation is sent
</comment>
483 <name>default_fee_id
</name>
484 <type>int unsigned
</type>
485 <title>Default Fee ID
</title>
486 <comment>FK to civicrm_option_value.
</comment>
490 <name>default_discount_fee_id
</name>
491 <type>int unsigned
</type>
492 <title>Default Discount Fee ID
</title>
493 <comment>FK to civicrm_option_value.
</comment>
497 <name>thankyou_title
</name>
499 <title>ThankYou Title
</title>
501 <default>NULL
</default>
502 <localizable>true
</localizable>
503 <comment>Title for ThankYou page.
</comment>
510 <name>thankyou_text
</name>
513 <type>RichTextEditor
</type>
517 <title>ThankYou Text
</title>
518 <localizable>true
</localizable>
519 <comment>ThankYou Text.
</comment>
523 <name>thankyou_footer_text
</name>
525 <title>Footer Text
</title>
527 <type>RichTextEditor
</type>
531 <localizable>true
</localizable>
532 <comment>Footer message.
</comment>
536 <name>is_pay_later
</name>
537 <title>Pay Later Allowed
</title>
540 <comment>if true - allows the user to send payment directly to the org later
</comment>
543 <type>CheckBox
</type>
547 <name>pay_later_text
</name>
548 <title>Pay Later Text
</title>
550 <localizable>true
</localizable>
551 <comment>The text displayed to the user in the main form
</comment>
554 <type>RichTextEditor
</type>
558 <name>pay_later_receipt
</name>
559 <title>Pay Later Receipt Text
</title>
561 <localizable>true
</localizable>
562 <comment>The receipt sent to the user instead of the normal receipt text
</comment>
569 <name>is_partial_payment
</name>
570 <title>Partial Payments Enabled
</title>
573 <comment>is partial payment enabled for this event
</comment>
576 <type>CheckBox
</type>
580 <name>initial_amount_label
</name>
581 <title>Initial Amount Label
</title>
584 <localizable>true
</localizable>
585 <comment>Initial amount label for partial payment
</comment>
592 <name>initial_amount_help_text
</name>
593 <title>Initial Amount Help Text
</title>
595 <localizable>true
</localizable>
596 <comment>Initial amount help text for partial payment
</comment>
603 <name>min_initial_amount
</name>
604 <title>Minimum Initial Amount
</title>
606 <comment>Minimum initial amount for partial payment
</comment>
613 <name>is_multiple_registrations
</name>
614 <title>Allow Multiple Registrations
</title>
617 <comment>if true - allows the user to register multiple participants for event
</comment>
620 <type>CheckBox
</type>
624 <name>max_additional_participants
</name>
625 <type>int unsigned
</type>
626 <title>Maximum number of additional participants per registration
</title>
628 <comment>Maximum number of additional participants that can be registered on a single booking
</comment>
632 <name>allow_same_participant_emails
</name>
634 <title>Does Event allow multiple registrations from same email address?
</title>
636 <comment>if true - allows the user to register multiple registrations from same email address.
</comment>
639 <type>CheckBox
</type>
643 <name>has_waitlist
</name>
644 <title>Waitlist Enabled
</title>
646 <comment>Whether the event has waitlist support.
</comment>
649 <type>CheckBox
</type>
653 <name>requires_approval
</name>
655 <comment>Whether participants require approval before they can finish registering.
</comment>
658 <type>CheckBox
</type>
662 <name>expiration_time
</name>
663 <type>int unsigned
</type>
664 <comment>Expire pending but unconfirmed registrations after this many hours.
</comment>
671 <name>allow_selfcancelxfer
</name>
674 <title>Allow Self-service Cancellation or Transfer
</title>
675 <comment>Allow self service cancellation or transfer for event?
</comment>
678 <type>CheckBox
</type>
682 <name>selfcancelxfer_time
</name>
683 <type>int unsigned
</type>
685 <title>Self-service Cancellation or Transfer Time
</title>
686 <comment>Number of hours prior to event start date to allow self-service cancellation or transfer.
</comment>
693 <name>waitlist_text
</name>
696 <type>TextArea
</type>
700 <localizable>true
</localizable>
701 <comment>Text to display when the event is full, but participants can signup for a waitlist.
</comment>
705 <name>approval_req_text
</name>
708 <type>TextArea
</type>
712 <localizable>true
</localizable>
713 <comment>Text to display when the approval is required to complete registration for an event.
</comment>
717 <name>is_template
</name>
718 <title>Is an Event Template
</title>
721 <required>true
</required>
722 <comment>whether the event has template
</comment>
725 <type>CheckBox
</type>
729 <name>template_title
</name>
730 <uniqueName>template_title
</uniqueName>
732 <import>true
</import>
733 <title>Event Template Title
</title>
734 <headerPattern>/(template.)?title$/i
</headerPattern>
736 <localizable>true
</localizable>
737 <comment>Event Template Title
</comment>
744 <name>created_id
</name>
745 <type>int unsigned
</type>
746 <title>Created By Contact ID
</title>
747 <comment>FK to civicrm_contact, who created this event
</comment>
751 <name>created_id
</name>
752 <table>civicrm_contact
</table>
755 <onDelete>SET NULL
</onDelete>
758 <name>created_date
</name>
759 <type>datetime
</type>
760 <title>Event Created Date
</title>
761 <comment>Date and time that event was created.
</comment>
765 <name>currency
</name>
768 <import>true
</import>
769 <headerPattern>/cur(rency)?/i
</headerPattern>
770 <dataPattern>/^[A-Z]{
3}$/i
</dataPattern>
771 <comment>3 character string, value from config setting or input via user.
</comment>
774 <table>civicrm_currency
</table>
775 <keyColumn>name
</keyColumn>
776 <labelColumn>full_name
</labelColumn>
777 <nameColumn>name
</nameColumn>
778 <abbrColumn>symbol
</abbrColumn>
785 <name>campaign_id
</name>
786 <type>int unsigned
</type>
787 <title>Campaign
</title>
788 <comment>The campaign for which this event has been created.
</comment>
790 <table>civicrm_campaign
</table>
791 <keyColumn>id
</keyColumn>
792 <labelColumn>title
</labelColumn>
796 <type>EntityRef
</type>
800 <name>campaign_id
</name>
801 <table>civicrm_campaign
</table>
803 <onDelete>SET NULL
</onDelete>
806 <name>is_share
</name>
807 <title>Is shared through social media
</title>
810 <comment>Can people share the event through social media?
</comment>
813 <type>CheckBox
</type>
817 <name>is_confirm_enabled
</name>
818 <title>Is the booking confirmation screen enabled?
</title>
821 <comment>If false, the event booking confirmation screen gets skipped
</comment>
824 <type>CheckBox
</type>
828 <name>parent_event_id
</name>
829 <type>int unsigned
</type>
830 <title>Parent Event ID
</title>
831 <default>NULL
</default>
832 <comment>Implicit FK to civicrm_event: parent event
</comment>
834 <type>EntityRef
</type>
839 <name>index_parent_event_id
</name>
840 <fieldName>parent_event_id
</fieldName>
844 <name>slot_label_id
</name>
845 <type>int unsigned
</type>
846 <title>Subevent Slot Label ID
</title>
847 <default>NULL
</default>
848 <comment>Subevent slot label. Implicit FK to civicrm_option_value where option_group = conference_slot.
</comment>
855 <name>dedupe_rule_group_id
</name>
856 <type>int unsigned
</type>
857 <title>Dedupe Rule
</title>
858 <default>NULL
</default>
859 <comment>Rule to use when matching registrations for this event
</comment>
861 <table>civicrm_dedupe_rule_group
</table>
862 <keyColumn>id
</keyColumn>
863 <nameColumn>name
</nameColumn>
864 <labelColumn>title
</labelColumn>
872 <name>dedupe_rule_group_id
</name>
873 <table>civicrm_dedupe_rule_group
</table>
878 <name>is_billing_required
</name>
879 <title>Is billing block required
</title>
882 <comment>if true than billing block is required this event
</comment>
885 <type>CheckBox
</type>