Reference > Database > WebSphere Commerce database tables > P


WebSphere Commerce database table: PARTICIPNT

This table stores information about a participant for a TradingAgreement.

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 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 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.

Indexes
Index Name Indexed Column Names Index Type
I0000184 MEMBER_ID+PARTROLE_ID+TRADING_ID+TERMCOND_ID Unique Index
SQL100520030406620 PARTICIPNT_ID Primary Key
I0000678 PARTROLE_ID Non-Unique Index
I0000679 TRADING_ID Non-Unique Index
I0000680 TERMCOND_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names 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

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search