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_