PARTROLE

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

Column Descriptions:

NameTypeDescription
PARTROLE_IDINTEGER NOT NULLThe 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
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PARTROLE_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_244PARTROLE_IDCNTRDISPLYPARTROLE_IDCascade
F_560PARTROLE_IDPARTICIPNTPARTROLE_IDCascade
F_563PARTROLE_IDPARTROLEDSPARTROLE_IDCascade