WebSphere Commerce database table: PARTROLEDS

This table stores descriptions for the role a participant plays a TradingAgreement.

Column Descriptions
Column Name Column Type Description
PARTROLE_ID INTEGER NOT NULL Participant role ID.
LANGUAGE_ID INTEGER NOT NULL Language this description pertains to. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR(4000) Participant role description.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235225430 PARTROLE_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_562 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_563 PARTROLE_ID PARTROLE PARTROLE_ID Cascade
Related reference