civicrm_event

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_events_in_carts.event_id FK_civicrm_events_in_carts_event_idC
civicrm_participant.event_id FK_civicrm_participant_event_idC

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
civicrm_loc_block.id FK_civicrm_event_loc_block_idN

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
civicrm_contact.id FK_civicrm_event_created_idN

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
civicrm_campaign.id FK_civicrm_event_campaign_idN

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
civicrm_dedupe_rule_group.id FK_civicrm_event_dedupe_rule_group_idR

Rule to use when matching registrations for this event
title_en_US VARCHAR 255 √ null
summary_en_US TEXT 65535 √ null
description_en_US TEXT 65535 √ null
registration_link_text_en_US VARCHAR 255 √ null
event_full_text_en_US TEXT 65535 √ null
fee_label_en_US VARCHAR 255 √ null
intro_text_en_US TEXT 65535 √ null
footer_text_en_US TEXT 65535 √ null
confirm_title_en_US VARCHAR 255 √ null
confirm_text_en_US TEXT 65535 √ null
confirm_footer_text_en_US TEXT 65535 √ null
confirm_email_text_en_US TEXT 65535 √ null
confirm_from_name_en_US VARCHAR 255 √ null
thankyou_title_en_US VARCHAR 255 √ null
thankyou_text_en_US TEXT 65535 √ null
thankyou_footer_text_en_US TEXT 65535 √ null
pay_later_text_en_US TEXT 65535 √ null
pay_later_receipt_en_US TEXT 65535 √ null
initial_amount_label_en_US VARCHAR 255 √ null
initial_amount_help_text_en_US TEXT 65535 √ null
waitlist_text_en_US TEXT 65535 √ null
approval_req_text_en_US TEXT 65535 √ null
template_title_en_US VARCHAR 255 √ null
title_fr_CA VARCHAR 255 √ null
summary_fr_CA TEXT 65535 √ null
description_fr_CA TEXT 65535 √ null
registration_link_text_fr_CA VARCHAR 255 √ null
event_full_text_fr_CA TEXT 65535 √ null
fee_label_fr_CA VARCHAR 255 √ null
intro_text_fr_CA TEXT 65535 √ null
footer_text_fr_CA TEXT 65535 √ null
confirm_title_fr_CA VARCHAR 255 √ null
confirm_text_fr_CA TEXT 65535 √ null
confirm_footer_text_fr_CA TEXT 65535 √ null
confirm_email_text_fr_CA TEXT 65535 √ null
confirm_from_name_fr_CA VARCHAR 255 √ null
thankyou_title_fr_CA VARCHAR 255 √ null
thankyou_text_fr_CA TEXT 65535 √ null
thankyou_footer_text_fr_CA TEXT 65535 √ null
pay_later_text_fr_CA TEXT 65535 √ null
pay_later_receipt_fr_CA TEXT 65535 √ null
initial_amount_label_fr_CA VARCHAR 255 √ null
initial_amount_help_text_fr_CA TEXT 65535 √ null
waitlist_text_fr_CA TEXT 65535 √ null
approval_req_text_fr_CA TEXT 65535 √ null
template_title_fr_CA VARCHAR 255 √ null
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?

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_event_campaign_id Performance Asc campaign_id
FK_civicrm_event_created_id Performance Asc created_id
FK_civicrm_event_dedupe_rule_group_id Performance Asc dedupe_rule_group_id
FK_civicrm_event_loc_block_id Performance Asc loc_block_id
index_event_type_id Performance Asc event_type_id
index_parent_event_id Performance Asc parent_event_id
index_participant_listing_id Performance Asc participant_listing_id

Relationships

Close relationships within degrees of separation