Database Table: PARTROLEDS

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

Column Name Column Type Column Description
DESCRIPTION VARCHAR (4000)
NULL
Participant role description.
LANGUAGE_ID INTEGER
NOT NULL
For a list of language IDs, see the LANGUAGE table.
PARTROLE_ID INTEGER
NOT NULL
Participant role ID.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035027190 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

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