1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
6 <name>civicrm_event
</name>
11 <type>int unsigned
</type>
12 <title>Event ID
</title>
13 <required>true
</required>
14 <comment>Event
</comment>
19 <autoincrement>true
</autoincrement>
23 <uniqueName>event_title
</uniqueName>
26 <title>Event Title
</title>
27 <headerPattern>/(event.)?title$/i
</headerPattern>
29 <localizable>true
</localizable>
30 <comment>Event Title (e.g. Fall Fundraiser Dinner)
</comment>
36 <title>Event Summary
</title>
37 <htmlType>textarea
</htmlType>
40 <localizable>true
</localizable>
41 <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>
45 <name>description
</name>
47 <uniqueName>event_description
</uniqueName>
48 <title>Event Description
</title>
49 <htmlType>textarea
</htmlType>
52 <localizable>true
</localizable>
53 <comment>Full description of event. Text and html allowed. Displayed on built-in Event Information screens.
</comment>
57 <name>event_type_id
</name>
58 <type>int unsigned
</type>
59 <uniqueName>event_type_id
</uniqueName>
60 <title>Event Type ID
</title>
63 <optionGroupName>event_type
</optionGroupName>
65 <comment>Event Type ID.Implicit FK to civicrm_option_value where option_group = event_type.
</comment>
69 <name>index_event_type_id
</name>
70 <fieldName>event_type_id
</fieldName>
74 <name>participant_listing_id
</name>
75 <type>int unsigned
</type>
76 <uniqueName>participant_listing_id
</uniqueName>
77 <title>Participant Listing ID
</title>
79 <comment>Should we expose the participant list? Implicit FK to civicrm_option_value where option_group = participant_listing.
</comment>
83 <name>index_participant_listing_id
</name>
84 <fieldName>participant_listing_id
</fieldName>
88 <name>is_public
</name>
90 <title>Is Event Public
</title>
92 <comment>Public events will be included in the iCal feeds. Access to private event information may be limited using ACLs.
</comment>
96 <name>start_date
</name>
98 <uniqueName>event_start_date
</uniqueName>
99 <title>Event Start Date
</title>
100 <headerPattern>/^start|(s(tart\s)?date)$/i
</headerPattern>
101 <import>true
</import>
102 <comment>Date and time that event starts.
</comment>
106 <name>end_date
</name>
107 <type>datetime
</type>
108 <uniqueName>event_end_date
</uniqueName>
109 <title>Event End Date
</title>
110 <headerPattern>/^end|(e(nd\s)?date)$/i
</headerPattern>
111 <import>true
</import>
112 <comment>Date and time that event ends. May be NULL if no defined end date/time
</comment>
116 <name>is_online_registration
</name>
118 <title>Is Online Registration
</title>
120 <comment>If true, include registration link on Event Info page.
</comment>
124 <name>registration_link_text
</name>
126 <title>Event Registration Link Text
</title>
128 <localizable>true
</localizable>
129 <comment>Text for link to Event Registration form which is displayed on Event Information screen when is_online_registration is true.
</comment>
133 <name>registration_start_date
</name>
134 <type>datetime
</type>
135 <comment>Date and time that online registration starts.
</comment>
139 <name>registration_end_date
</name>
140 <type>datetime
</type>
141 <comment>Date and time that online registration ends.
</comment>
145 <name>max_participants
</name>
146 <type>int unsigned
</type>
147 <title>Max Participants
</title>
148 <default>NULL
</default>
149 <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>
153 <name>event_full_text
</name>
155 <title>Event Information
</title>
156 <htmlType>textarea
</htmlType>
159 <localizable>true
</localizable>
160 <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>
164 <name>is_monetary
</name>
165 <title>Is this a PAID event?
</title>
168 <comment>If true, one or more fee amounts must be set and a Payment Processor must be configured for Online Event Registration.
</comment>
172 <name>contribution_type_id
</name>
173 <type>int unsigned
</type>
175 <comment>Contribution type assigned to paid event registrations for this event. Required if is_monetary is true.
</comment>
180 <name>financial_type_id
</name>
181 <type>int unsigned
</type>
182 <title>Financial Type ID
</title>
183 <default>NULL
</default>
184 <comment>Financial type assigned to paid event registrations for this event. Required if is_monetary is true.
</comment>
186 <table>civicrm_financial_type
</table>
187 <keyColumn>id
</keyColumn>
188 <labelColumn>name
</labelColumn>
193 <name>payment_processor
</name>
196 <comment>Payment Processors configured for this Event (if is_monetary is true)
</comment>
198 <table>civicrm_payment_processor
</table>
199 <keyColumn>id
</keyColumn>
200 <labelColumn>name
</labelColumn>
206 <title>Map Enabled
</title>
209 <comment>Include a map block on the Event Information page when geocode info is available and a mapping provider has been specified?
</comment>
213 <name>is_active
</name>
214 <title>Is Active
</title>
217 <comment>Is this Event enabled or disabled/cancelled?
</comment>
221 <name>fee_label
</name>
223 <import>true
</import>
224 <title>Fee Label
</title>
225 <headerPattern>/^fee|(f(ee\s)?label)$/i
</headerPattern>
227 <localizable>true
</localizable>
231 <name>is_show_location
</name>
233 <title>show location
</title>
235 <comment>If true, show event location.
</comment>
239 <name>loc_block_id
</name>
240 <type>int unsigned
</type>
241 <title>Location Block ID
</title>
242 <comment>FK to Location Block ID
</comment>
246 <name>loc_block_id
</name>
247 <table>civicrm_loc_block
</table>
249 <onDelete>SET NULL
</onDelete>
253 <name>receipt_text
</name>
255 <htmlType>textarea
</htmlType>
259 <comment>Receipt Text for off-line event participation
</comment>
264 <name>default_role_id
</name>
265 <uniqueName>default_role_id
</uniqueName>
266 <title>Participant Role
</title>
267 <import>true
</import>
268 <type>int unsigned
</type>
270 <comment>Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.
</comment>
274 <name>intro_text
</name>
276 <htmlType>textarea
</htmlType>
279 <title>Introductory Message
</title>
280 <localizable>true
</localizable>
281 <comment>Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.
</comment>
285 <name>footer_text
</name>
286 <title>Footer Message
</title>
288 <htmlType>textarea
</htmlType>
291 <localizable>true
</localizable>
292 <comment>Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.
</comment>
296 <name>confirm_title
</name>
298 <title>Confirmation Title
</title>
300 <default>NULL
</default>
301 <localizable>true
</localizable>
302 <comment>Title for Confirmation page.
</comment>
306 <name>confirm_text
</name>
308 <htmlType>textarea
</htmlType>
311 <title>Confirm Text
</title>
312 <localizable>true
</localizable>
313 <comment>Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.
</comment>
317 <name>confirm_footer_text
</name>
319 <title>Footer Text
</title>
320 <htmlType>textarea
</htmlType>
323 <localizable>true
</localizable>
324 <comment>Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.
</comment>
328 <name>is_email_confirm
</name>
330 <title>Is confirm email
</title>
332 <comment>If true, confirmation is automatically emailed to contact on successful registration.
</comment>
336 <name>confirm_email_text
</name>
338 <title>Confirmation Email Text
</title>
339 <htmlType>textarea
</htmlType>
342 <localizable>true
</localizable>
343 <comment>text to include above standard event info on confirmation email. emails are text-only, so do not allow html for now
</comment>
347 <name>confirm_from_name
</name>
349 <title>Confirm From Name
</title>
351 <localizable>true
</localizable>
352 <comment>FROM email name used for confirmation emails.
</comment>
356 <name>confirm_from_email
</name>
358 <title>Confirm From Email
</title>
360 <comment>FROM email address used for confirmation emails.
</comment>
364 <name>cc_confirm
</name>
367 <comment>comma-separated list of email addresses to cc each time a confirmation is sent
</comment>
371 <name>bcc_confirm
</name>
374 <comment>comma-separated list of email addresses to bcc each time a confirmation is sent
</comment>
378 <name>default_fee_id
</name>
379 <type>int unsigned
</type>
380 <title>Default Fee ID
</title>
381 <comment>FK to civicrm_option_value.
</comment>
385 <name>default_discount_fee_id
</name>
386 <type>int unsigned
</type>
387 <title>Default Discount Fee ID
</title>
388 <comment>FK to civicrm_option_value.
</comment>
392 <name>thankyou_title
</name>
394 <title>ThankYou Title
</title>
396 <default>NULL
</default>
397 <localizable>true
</localizable>
398 <comment>Title for ThankYou page.
</comment>
402 <name>thankyou_text
</name>
404 <htmlType>textarea
</htmlType>
407 <title>ThankYou Text
</title>
408 <localizable>true
</localizable>
409 <comment>ThankYou Text.
</comment>
413 <name>thankyou_footer_text
</name>
415 <title>Footer Text
</title>
416 <htmlType>textarea
</htmlType>
419 <localizable>true
</localizable>
420 <comment>Footer message.
</comment>
424 <name>is_pay_later
</name>
425 <title>Pay Later Allowed
</title>
428 <comment>if true - allows the user to send payment directly to the org later
</comment>
432 <name>pay_later_text
</name>
433 <title>Pay Later Text
</title>
435 <localizable>true
</localizable>
436 <comment>The text displayed to the user in the main form
</comment>
440 <name>pay_later_receipt
</name>
441 <title>Pay Later Receipt Text
</title>
443 <localizable>true
</localizable>
444 <comment>The receipt sent to the user instead of the normal receipt text
</comment>
448 <name>is_partial_payment
</name>
449 <title>Partial Payments Enabled
</title>
452 <comment>is partial payment enabled for this event
</comment>
456 <name>initial_amount_label
</name>
457 <title>Initial Amount Label
</title>
460 <localizable>true
</localizable>
461 <comment>Initial amount label for partial payment
</comment>
465 <name>initial_amount_help_text
</name>
466 <title>Initial Amount Help Text
</title>
468 <localizable>true
</localizable>
469 <comment>Initial amount help text for partial payment
</comment>
473 <name>min_initial_amount
</name>
474 <title>Minimum Initial Amount
</title>
476 <comment>Minimum initial amount for partial payment
</comment>
480 <name>is_multiple_registrations
</name>
481 <title>Allow Multiple Registrations
</title>
484 <comment>if true - allows the user to register multiple participants for event
</comment>
488 <name>allow_same_participant_emails
</name>
490 <title>Does Event allow multiple registrations from same email address?
</title>
492 <comment>if true - allows the user to register multiple registrations from same email address.
</comment>
496 <name>has_waitlist
</name>
497 <title>Waitlist Enabled
</title>
499 <comment>Whether the event has waitlist support.
</comment>
503 <name>requires_approval
</name>
505 <comment>Whether participants require approval before they can finish registering.
</comment>
509 <name>expiration_time
</name>
510 <type>int unsigned
</type>
511 <comment>Expire pending but unconfirmed registrations after this many hours.
</comment>
515 <name>waitlist_text
</name>
517 <htmlType>textarea
</htmlType>
520 <localizable>true
</localizable>
521 <comment>Text to display when the event is full, but participants can signup for a waitlist.
</comment>
525 <name>approval_req_text
</name>
527 <htmlType>textarea
</htmlType>
530 <localizable>true
</localizable>
531 <comment>Text to display when the approval is required to complete registration for an event.
</comment>
535 <name>is_template
</name>
536 <title>Is an Event Template
</title>
539 <comment>whether the event has template
</comment>
543 <name>template_title
</name>
544 <uniqueName>template_title
</uniqueName>
546 <import>true
</import>
547 <title>Event Template Title
</title>
548 <headerPattern>/(template.)?title$/i
</headerPattern>
550 <localizable>true
</localizable>
551 <comment>Event Template Title
</comment>
555 <name>created_id
</name>
556 <type>int unsigned
</type>
557 <title>Created By Contact ID
</title>
558 <comment>FK to civicrm_contact, who created this event
</comment>
562 <name>created_id
</name>
563 <table>civicrm_contact
</table>
566 <onDelete>SET NULL
</onDelete>
569 <name>created_date
</name>
570 <type>datetime
</type>
571 <title>Event Created Date
</title>
572 <comment>Date and time that event was created.
</comment>
576 <name>currency
</name>
579 <import>true
</import>
580 <headerPattern>/cur(rency)?/i
</headerPattern>
581 <dataPattern>/^[A-Z]{
3}$/i
</dataPattern>
582 <comment>3 character string, value from config setting or input via user.
</comment>
585 <table>civicrm_currency
</table>
586 <keyColumn>name
</keyColumn>
587 <labelColumn>full_name
</labelColumn>
588 <nameColumn>numeric_code
</nameColumn>
592 <name>campaign_id
</name>
593 <type>int unsigned
</type>
594 <title>Campaign ID
</title>
595 <comment>The campaign for which this event has been created.
</comment>
599 <name>campaign_id
</name>
600 <table>civicrm_campaign
</table>
602 <onDelete>SET NULL
</onDelete>
605 <name>is_share
</name>
606 <title>Is shared through social media
</title>
609 <comment>Can people share the event through social media?
</comment>
613 <name>parent_event_id
</name>
614 <type>int unsigned
</type>
615 <title>Parent Event ID
</title>
616 <default>NULL
</default>
617 <comment>Implicit FK to civicrm_event: parent event
</comment>
621 <name>index_parent_event_id
</name>
622 <fieldName>parent_event_id
</fieldName>
626 <name>slot_label_id
</name>
627 <type>int unsigned
</type>
628 <title>Subevent Slot Label ID
</title>
629 <default>NULL
</default>
630 <comment>Subevent slot label. Implicit FK to civicrm_option_value where option_group = conference_slot.
</comment>