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