Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PARTROLE
This table stores role information about a participant for a TradingAgreement.
Column Name Column Type Description PARTROLE_ID INTEGER NOT NULL The role of the participant. This is a primary key. Possible values are...
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 SQL100520030406780 PARTROLE_ID Primary Key
Referenced By 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
_vcc_freeselect_bottom_