WebSphere Commerce database table: PARTICIPNT

This table stores information about a participant for a TradingAgreement.


Column Description(s):
Column NameColumn TypeDescription
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 NameIndexed Column NamesIndex 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 NameColumn Name(s)Foreign Table NameForeign 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

Feedback