WebSphere Commerce database table: PARTROLE

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


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031252500 PARTROLE_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)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

Feedback