This table stores role information about a
participant for a TradingAgreement.
Column Descriptions:
Name | 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | PARTROLE_ID | Primary Key |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | 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 |