This table stores information about a participant for a TradingAgreement.
Column Description(s):
Column Name | Column 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; that is, 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 terms and conditions 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 |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000184 |
MEMBER_ID+PARTROLE_ID+TRADING_ID+TERMCOND_ID |
Unique Index |
SQL050212031252360 |
PARTICIPNT_ID |
Primary Key |
I0000678 |
PARTROLE_ID |
Non-Unique Index |
I0000679 |
TRADING_ID |
Non-Unique Index |
I0000680 |
TERMCOND_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_561 |
MEMBER_ID |
MEMBER |
MEMBER_ID |
Cascade |
F_560 |
PARTROLE_ID |
PARTROLE |
PARTROLE_ID |
Cascade |
F_558 |
TERMCOND_ID |
TERMCOND |
TERMCOND_ID |
Cascade |
F_559 |
TRADING_ID |
TRADING |
TRADING_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.