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 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 Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031252500 | PARTROLE_ID | Primary Key |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign 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 |