This table stores role information about a participant for a TradingAgreement.
Column Name | Column Type | Column 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 |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035026850 | PARTROLE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
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 |