| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | 0 |
|
|
Event |
||
| event_type_id | INT UNSIGNED | 10 | √ | 0 |
|
|
Event Type ID.Implicit FK to civicrm_option_value where option_group = event_type. |
|
| participant_listing_id | INT UNSIGNED | 10 | √ | 0 |
|
|
Should we expose the participant list? Implicit FK to civicrm_option_value where option_group = participant_listing. |
|
| is_public | TINYINT | 3 | √ | 1 |
|
|
Public events will be included in the iCal feeds. Access to private event information may be limited using ACLs. |
|
| start_date | DATETIME | 19 | √ | null |
|
|
Date and time that event starts. |
|
| end_date | DATETIME | 19 | √ | null |
|
|
Date and time that event ends. May be NULL if no defined end date/time |
|
| is_online_registration | TINYINT | 3 | √ | 0 |
|
|
If true, include registration link on Event Info page. |
|
| registration_start_date | DATETIME | 19 | √ | null |
|
|
Date and time that online registration starts. |
|
| registration_end_date | DATETIME | 19 | √ | null |
|
|
Date and time that online registration ends. |
|
| max_participants | INT UNSIGNED | 10 | √ | null |
|
|
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. |
|
| is_monetary | TINYINT | 3 | √ | 0 |
|
|
If true, one or more fee amounts must be set and a Payment Processor must be configured for Online Event Registration. |
|
| financial_type_id | INT UNSIGNED | 10 | √ | null |
|
|
Financial type assigned to paid event registrations for this event. Required if is_monetary is true. |
|
| payment_processor | VARCHAR | 128 | √ | null |
|
|
Payment Processors configured for this Event (if is_monetary is true) |
|
| is_map | TINYINT | 3 | √ | 0 |
|
|
Include a map block on the Event Information page when geocode info is available and a mapping provider has been specified? |
|
| is_active | TINYINT | 3 | √ | 0 |
|
|
Is this Event enabled or disabled/cancelled? |
|
| is_show_location | TINYINT | 3 | √ | 1 |
|
|
If true, show event location. |
|
| loc_block_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to Location Block ID |
|
| default_role_id | INT UNSIGNED | 10 | √ | 1 |
|
|
Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role. |
|
| is_email_confirm | TINYINT | 3 | √ | 0 |
|
|
If true, confirmation is automatically emailed to contact on successful registration. |
|
| confirm_from_email | VARCHAR | 255 | √ | null |
|
|
FROM email address used for confirmation emails. |
|
| cc_confirm | VARCHAR | 255 | √ | null |
|
|
comma-separated list of email addresses to cc each time a confirmation is sent |
|
| bcc_confirm | VARCHAR | 255 | √ | null |
|
|
comma-separated list of email addresses to bcc each time a confirmation is sent |
|
| default_fee_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to civicrm_option_value. |
|
| default_discount_fee_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to civicrm_option_value. |
|
| is_pay_later | TINYINT | 3 | √ | 0 |
|
|
if true - allows the user to send payment directly to the org later |
|
| is_partial_payment | TINYINT | 3 | √ | 0 |
|
|
is partial payment enabled for this event |
|
| min_initial_amount | DECIMAL | 20,2 | √ | null |
|
|
Minimum initial amount for partial payment |
|
| is_multiple_registrations | TINYINT | 3 | √ | 0 |
|
|
if true - allows the user to register multiple participants for event |
|
| max_additional_participants | INT UNSIGNED | 10 | √ | 0 |
|
|
Maximum number of additional participants that can be registered on a single booking |
|
| allow_same_participant_emails | TINYINT | 3 | √ | 0 |
|
|
if true - allows the user to register multiple registrations from same email address. |
|
| has_waitlist | TINYINT | 3 | √ | null |
|
|
Whether the event has waitlist support. |
|
| requires_approval | TINYINT | 3 | √ | null |
|
|
Whether participants require approval before they can finish registering. |
|
| expiration_time | INT UNSIGNED | 10 | √ | null |
|
|
Expire pending but unconfirmed registrations after this many hours. |
|
| is_template | TINYINT | 3 | 0 |
|
|
whether the event has template |
||
| created_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to civicrm_contact, who created this event |
|
| created_date | DATETIME | 19 | √ | null |
|
|
Date and time that event was created. |
|
| currency | VARCHAR | 3 | √ | null |
|
|
3 character string, value from config setting or input via user. |
|
| campaign_id | INT UNSIGNED | 10 | √ | null |
|
|
The campaign for which this event has been created. |
|
| is_share | TINYINT | 3 | √ | 1 |
|
|
Can people share the event through social media? |
|
| is_confirm_enabled | TINYINT | 3 | √ | 1 |
|
|
If false, the event booking confirmation screen gets skipped |
|
| parent_event_id | INT UNSIGNED | 10 | √ | null |
|
|
Implicit FK to civicrm_event: parent event |
|
| slot_label_id | INT UNSIGNED | 10 | √ | null |
|
|
Subevent slot label. Implicit FK to civicrm_option_value where option_group = conference_slot. |
|
| dedupe_rule_group_id | INT UNSIGNED | 10 | √ | null |
|
|
Rule to use when matching registrations for this event |
|
| is_billing_required | TINYINT | 3 | √ | 0 |
|
|
Billing block required for Event |
|
| selfcancelxfer_time | INT UNSIGNED | 10 | √ | 0 |
|
|
Number of hours prior to event start date to allow self-service cancellation or transfer. |
|
| allow_selfcancelxfer | TINYINT | 3 | √ | 0 |
|
|
Allow self service cancellation or transfer for event? |
|
| title | VARCHAR | 255 | √ | null |
|
|
||
| summary | TEXT | 65535 | √ | null |
|
|
||
| description | TEXT | 65535 | √ | null |
|
|
||
| registration_link_text | VARCHAR | 255 | √ | null |
|
|
||
| event_full_text | TEXT | 65535 | √ | null |
|
|
||
| fee_label | VARCHAR | 255 | √ | null |
|
|
||
| intro_text | TEXT | 65535 | √ | null |
|
|
||
| footer_text | TEXT | 65535 | √ | null |
|
|
||
| confirm_title | VARCHAR | 255 | √ | null |
|
|
||
| confirm_text | TEXT | 65535 | √ | null |
|
|
||
| confirm_footer_text | TEXT | 65535 | √ | null |
|
|
||
| confirm_email_text | TEXT | 65535 | √ | null |
|
|
||
| confirm_from_name | VARCHAR | 255 | √ | null |
|
|
||
| thankyou_title | VARCHAR | 255 | √ | null |
|
|
||
| thankyou_text | TEXT | 65535 | √ | null |
|
|
||
| thankyou_footer_text | TEXT | 65535 | √ | null |
|
|
||
| pay_later_text | TEXT | 65535 | √ | null |
|
|
||
| pay_later_receipt | TEXT | 65535 | √ | null |
|
|
||
| initial_amount_label | VARCHAR | 255 | √ | null |
|
|
||
| initial_amount_help_text | TEXT | 65535 | √ | null |
|
|
||
| waitlist_text | TEXT | 65535 | √ | null |
|
|
||
| approval_req_text | TEXT | 65535 | √ | null |
|
|
||
| template_title | VARCHAR | 255 | √ | null |
|
|
select `civicrm`.`civicrm_event`.`id` AS `id`,`civicrm`.`civicrm_event`.`event_type_id` AS `event_type_id`,`civicrm`.`civicrm_event`.`participant_listing_id` AS `participant_listing_id`,`civicrm`.`civicrm_event`.`is_public` AS `is_public`,`civicrm`.`civicrm_event`.`start_date` AS `start_date`,`civicrm`.`civicrm_event`.`end_date` AS `end_date`,`civicrm`.`civicrm_event`.`is_online_registration` AS `is_online_registration`,`civicrm`.`civicrm_event`.`registration_start_date` AS `registration_start_date`,`civicrm`.`civicrm_event`.`registration_end_date` AS `registration_end_date`,`civicrm`.`civicrm_event`.`max_participants` AS `max_participants`,`civicrm`.`civicrm_event`.`is_monetary` AS `is_monetary`,`civicrm`.`civicrm_event`.`financial_type_id` AS `financial_type_id`,`civicrm`.`civicrm_event`.`payment_processor` AS `payment_processor`,`civicrm`.`civicrm_event`.`is_map` AS `is_map`,`civicrm`.`civicrm_event`.`is_active` AS `is_active`,`civicrm`.`civicrm_event`.`is_show_location` AS `is_show_location`,`civicrm`.`civicrm_event`.`loc_block_id` AS `loc_block_id`,`civicrm`.`civicrm_event`.`default_role_id` AS `default_role_id`,`civicrm`.`civicrm_event`.`is_email_confirm` AS `is_email_confirm`,`civicrm`.`civicrm_event`.`confirm_from_email` AS `confirm_from_email`,`civicrm`.`civicrm_event`.`cc_confirm` AS `cc_confirm`,`civicrm`.`civicrm_event`.`bcc_confirm` AS `bcc_confirm`,`civicrm`.`civicrm_event`.`default_fee_id` AS `default_fee_id`,`civicrm`.`civicrm_event`.`default_discount_fee_id` AS `default_discount_fee_id`,`civicrm`.`civicrm_event`.`is_pay_later` AS `is_pay_later`,`civicrm`.`civicrm_event`.`is_partial_payment` AS `is_partial_payment`,`civicrm`.`civicrm_event`.`min_initial_amount` AS `min_initial_amount`,`civicrm`.`civicrm_event`.`is_multiple_registrations` AS `is_multiple_registrations`,`civicrm`.`civicrm_event`.`max_additional_participants` AS `max_additional_participants`,`civicrm`.`civicrm_event`.`allow_same_participant_emails` AS `allow_same_participant_emails`,`civicrm`.`civicrm_event`.`has_waitlist` AS `has_waitlist`,`civicrm`.`civicrm_event`.`requires_approval` AS `requires_approval`,`civicrm`.`civicrm_event`.`expiration_time` AS `expiration_time`,`civicrm`.`civicrm_event`.`is_template` AS `is_template`,`civicrm`.`civicrm_event`.`created_id` AS `created_id`,`civicrm`.`civicrm_event`.`created_date` AS `created_date`,`civicrm`.`civicrm_event`.`currency` AS `currency`,`civicrm`.`civicrm_event`.`campaign_id` AS `campaign_id`,`civicrm`.`civicrm_event`.`is_share` AS `is_share`,`civicrm`.`civicrm_event`.`is_confirm_enabled` AS `is_confirm_enabled`,`civicrm`.`civicrm_event`.`parent_event_id` AS `parent_event_id`,`civicrm`.`civicrm_event`.`slot_label_id` AS `slot_label_id`,`civicrm`.`civicrm_event`.`dedupe_rule_group_id` AS `dedupe_rule_group_id`,`civicrm`.`civicrm_event`.`is_billing_required` AS `is_billing_required`,`civicrm`.`civicrm_event`.`selfcancelxfer_time` AS `selfcancelxfer_time`,`civicrm`.`civicrm_event`.`allow_selfcancelxfer` AS `allow_selfcancelxfer`,`civicrm`.`civicrm_event`.`title_fr_CA` AS `title`,`civicrm`.`civicrm_event`.`summary_fr_CA` AS `summary`,`civicrm`.`civicrm_event`.`description_fr_CA` AS `description`,`civicrm`.`civicrm_event`.`registration_link_text_fr_CA` AS `registration_link_text`,`civicrm`.`civicrm_event`.`event_full_text_fr_CA` AS `event_full_text`,`civicrm`.`civicrm_event`.`fee_label_fr_CA` AS `fee_label`,`civicrm`.`civicrm_event`.`intro_text_fr_CA` AS `intro_text`,`civicrm`.`civicrm_event`.`footer_text_fr_CA` AS `footer_text`,`civicrm`.`civicrm_event`.`confirm_title_fr_CA` AS `confirm_title`,`civicrm`.`civicrm_event`.`confirm_text_fr_CA` AS `confirm_text`,`civicrm`.`civicrm_event`.`confirm_footer_text_fr_CA` AS `confirm_footer_text`,`civicrm`.`civicrm_event`.`confirm_email_text_fr_CA` AS `confirm_email_text`,`civicrm`.`civicrm_event`.`confirm_from_name_fr_CA` AS `confirm_from_name`,`civicrm`.`civicrm_event`.`thankyou_title_fr_CA` AS `thankyou_title`,`civicrm`.`civicrm_event`.`thankyou_text_fr_CA` AS `thankyou_text`,`civicrm`.`civicrm_event`.`thankyou_footer_text_fr_CA` AS `thankyou_footer_text`,`civicrm`.`civicrm_event`.`pay_later_text_fr_CA` AS `pay_later_text`,`civicrm`.`civicrm_event`.`pay_later_receipt_fr_CA` AS `pay_later_receipt`,`civicrm`.`civicrm_event`.`initial_amount_label_fr_CA` AS `initial_amount_label`,`civicrm`.`civicrm_event`.`initial_amount_help_text_fr_CA` AS `initial_amount_help_text`,`civicrm`.`civicrm_event`.`waitlist_text_fr_CA` AS `waitlist_text`,`civicrm`.`civicrm_event`.`approval_req_text_fr_CA` AS `approval_req_text`,`civicrm`.`civicrm_event`.`template_title_fr_CA` AS `template_title` from `civicrm`.`civicrm_event`