Columns
| 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. |
|
| 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 |
|
|
||
| TEXT | 65535 | √ | null |
|
|
|||
| confirm_title | VARCHAR | 255 | √ | null |
|
|
||
| confirm_text | TEXT | 65535 | √ | null |
|
|
||
| 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 |
|
|
||
| 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 |
|
|