civicrm_participant

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_participant.registered_by_id FK_civicrm_participant_registered_by_idN
civicrm_participant_payment.participant_id FK_civicrm_participant_payment_participant_idC

Participant Id
contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_participant_contact_idC

FK to Contact ID
event_id INT UNSIGNED 10 null
civicrm_event.id FK_civicrm_participant_event_idC

FK to Event ID
status_id INT UNSIGNED 10 1
civicrm_participant_status_type.id FK_civicrm_participant_status_idR

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
civicrm_participant.id FK_civicrm_participant_registered_by_idN

FK to Participant ID
discount_id INT UNSIGNED 10 √ null
civicrm_discount.id FK_civicrm_participant_discount_idN

FK to Discount ID
fee_currency VARCHAR 3 √ null

3 character string, value derived from config setting.
campaign_id INT UNSIGNED 10 √ null
civicrm_campaign.id FK_civicrm_participant_campaign_idN

The campaign for which this participant has been registered.
discount_amount INT UNSIGNED 10 √ null

Discount Amount
cart_id INT UNSIGNED 10 √ null
civicrm_event_carts.id FK_civicrm_participant_cart_idN

FK to civicrm_event_carts
must_wait INT 10 √ null

On Waiting List
transferred_to_contact_id INT UNSIGNED 10 √ null
civicrm_contact.id FK_civicrm_participant_transferred_to_contact_idN

Contact to which the event registration is transferred

Indexes

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

Relationships

Close relationships within degrees of separation