Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_participant.registered_by_id FK_civicrm_participant_registered_by_id N
civicrm_participant_payment.participant_id FK_civicrm_participant_payment_participant_id C

Participant Id

contact_id INT UNSIGNED 10 null FK_civicrm_participant_contact_id C

FK to Contact ID

event_id INT UNSIGNED 10 null FK_civicrm_participant_event_id C

FK to Event ID

status_id INT UNSIGNED 10 1 FK_civicrm_participant_status_id R

Participant status ID. FK to civicrm_participant_status_type. Default of 1 should map to status = Registered.

role_id VARCHAR 128 null

Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.

register_date DATETIME 19 null

When did contact register for event?

source VARCHAR 128 null

Source of this event registration.

fee_level TEXT 65535 null

Populate with the label (text) associated with a fee level for paid events with multiple levels. Note that we store the label value and not the key

is_test TINYINT 3 0
is_pay_later TINYINT 3 0
fee_amount DECIMAL 20,2 null

actual processor fee if known - may be 0.

registered_by_id INT UNSIGNED 10 null FK_civicrm_participant_registered_by_id N

FK to Participant ID

discount_id INT UNSIGNED 10 null FK_civicrm_participant_discount_id N

FK to Discount ID

fee_currency VARCHAR 3 null

3 character string, value derived from config setting.

campaign_id INT UNSIGNED 10 null FK_civicrm_participant_campaign_id N

The campaign for which this participant has been registered.

discount_amount INT UNSIGNED 10 null

Discount Amount

cart_id INT UNSIGNED 10 null FK_civicrm_participant_cart_id N

FK to civicrm_event_carts

must_wait INT 10 null

On Waiting List

transferred_to_contact_id INT UNSIGNED 10 null FK_civicrm_participant_transferred_to_contact_id N

Contact to which the event registration is transferred

Table contained 0 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_participant_campaign_id Performance Asc campaign_id
FK_civicrm_participant_cart_id Performance Asc cart_id
FK_civicrm_participant_contact_id Performance Asc contact_id
FK_civicrm_participant_discount_id Performance Asc discount_id
FK_civicrm_participant_event_id Performance Asc event_id
FK_civicrm_participant_registered_by_id Performance Asc registered_by_id
FK_civicrm_participant_transferred_to_contact_id Performance Asc transferred_to_contact_id
index_role_id Performance Asc role_id
index_status_id Performance Asc status_id