Database Table: PARTICIPNT

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000184 MEMBER_ID, PARTROLE_ID, TRADING_ID, TERMCOND_ID Unique Index
SQL030416035026550 PARTICIPNT_ID Primary Key
Constraints:
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable