Table d47civi_0z3xa.civicrm_participant Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
civicrm_participant.registered_by_id FK_civicrm_participant_registered_by_id N
civicrm_participant_payment.participant_id FK_civicrm_participant_payment_participant_id C
civicrm_value_food_preference_2.entity_id FK_civicrm_value_food_preference_2_entity_id C
Participant Id
contact_id int unsigned 10
civicrm_contact.id FK_civicrm_participant_contact_id C
FK to Contact ID
event_id int unsigned 10
civicrm_event.id FK_civicrm_participant_event_id C
FK to Event ID
status_id int unsigned 10 1
civicrm_participant_status_type.id 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
civicrm_participant.id FK_civicrm_participant_registered_by_id N
FK to Participant ID
discount_id int unsigned 10  √  null
civicrm_discount.id 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
civicrm_campaign.id 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
civicrm_event_carts.id 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
civicrm_contact.id FK_civicrm_participant_transferred_to_contact_id N
FK to Contact ID

Table contained 50 rows at mer. avr. 13 16:52 EDT 2016

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

Close relationships  within of separation: