WebSphere Commerce database table: PARTROLE

This table stores role information about a participant for a TradingAgreement.

Column Descriptions
Column Name Column Type Description
PARTROLE_ID INTEGER NOT NULL The role of the participant. This is a primary key. Possible values are as follows:
0 = creator
1 = seller
2 = buyer
3 = supplier
4 = approver
5 = account holder
6 = buyer contact
7 = seller contact
8 = attorney
9 = administrator
10 = distributor
11 = service provider
12 = reseller
13 = host
14 = recipient
15 = service representative
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235225250 PARTROLE_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_244 PARTROLE_ID CNTRDISPLY PARTROLE_ID Cascade
F_560 PARTROLE_ID PARTICIPNT PARTROLE_ID Cascade
F_563 PARTROLE_ID PARTROLEDS PARTROLE_ID Cascade
Related reference