Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | INT UNSIGNED | 10 | √ | null |
|
|
Participant Payment Id |
|||
participant_id | INT UNSIGNED | 10 | null |
|
|
Participant Id (FK) |
||||
contribution_id | INT UNSIGNED | 10 | null |
|
|
FK to contribution table. |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |
FK_civicrm_participant_payment_participant_id | Performance | Asc | participant_id |
UI_contribution_participant | Must be unique | Asc/Asc | contribution_id + participant_id |