This table stores information about a participant
for a
TradingAgreement.
Column Descriptions:
| Name | Type | Description |
| PARTICIPNT_ID | BIGINT NOT NULL | Participant ID. This is a primary key. |
| MEMBER_ID | BIGINT | Member ID for the participant. If null, then
there are no restrictions for this participant and therefore any
participant can play the specified role in the TradingAgreement.
For example, a Buyer participant with a null member ID means
everyone is entitled to purchase under that contract. |
| PARTROLE_ID | INTEGER NOT NULL | Participant role ID. |
| TRADING_ID | BIGINT | TradingAgreement ID. If null, this is a
TermAndConditions level participant. In this case,
either
TRADING_ID or
TERMCOND_ID must be null. |
| TERMCOND_ID | BIGINT | TermAndConditions ID. If null, this is a
TradingAgreement level participant. In this case,
either
TRADING_ID or
TERMCOND_ID must be null. |
| INFORMATION | VARCHAR (4000) | Information about the participant. |
| TIMECREATED | TIMESTAMP | Time created. |
| TIMEUPDATED | TIMESTAMP | Time updated. |
| OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | PARTICIPNT_ID | Primary Key |
| I0000184 | MEMBER_ID+PARTROLE_ID+TRADING_ID+TERMCOND_ID | Unique Index |
| I0000678 | PARTROLE_ID | Non-Unique Index |
| I0000679 | TRADING_ID | Non-Unique Index |
| I0000680 | TERMCOND_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_558 | TERMCOND_ID | TERMCOND | TERMCOND_ID | Cascade |
| F_559 | TRADING_ID | TRADING | TRADING_ID | Cascade |
| F_560 | PARTROLE_ID | PARTROLE | PARTROLE_ID | Cascade |
| F_561 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |