This table stores information about a participant for a TradingAgreement.
Column Name | Column Type | Column Description |
---|---|---|
INFORMATION | VARCHAR (4000) NULL |
Information about the participant. |
MEMBER_ID | BIGINT NULL |
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. |
PARTICIPNT_ID | BIGINT NOT NULL |
Participant ID. This is a primary key. |
PARTROLE_ID | INTEGER NOT NULL |
Participant role ID. |
TERMCOND_ID | BIGINT NULL |
TermAndConditions ID. If null, this is a TradingAgreement level participant. In this case, either TRADING_ID or TERMCOND_ID must be null. |
TIMECREATED | TIMESTAMP NULL |
Time created. |
TIMEUPDATED | TIMESTAMP NULL |
Time updated. |
TRADING_ID | BIGINT NULL |
TradingAgreement ID. If null, this is a terms and conditions level participant. In this case, either TRADING_ID or TERMCOND_ID must be null. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000184 | MEMBER_ID, PARTROLE_ID, TRADING_ID, TERMCOND_ID | Unique Index |
SQL030416035026550 | PARTICIPNT_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint 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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|