JProjRelation contains information about the project relations in a project record.
This information includes the project on the left and right sides of the relationship and the type of relationship between the two projects (such as related). This table represents the Relations block on the Relations tab of a project record.
Object: ProjRelation (J_PROJ_RELATION)
Attribute |
Database column name |
Field in UI |
End of path |
Bridge |
Links to object table: |
Data type |
Comments |
Commonly used in: |
|
Rules |
Temp/Wiz |
||||||||
leftProject--> |
LEFT_PROJECT_ID (NUMBER) |
Project (left side, Relations block) |
|
x |
object |
The project on the left side of the relationship. |
|
x |
|
primaryKey |
PRIMARY_KEY (NUMBER) |
|
x |
|
|
int |
The unique ID of this item. |
|
|
rightProject--> |
RIGHT_PROJECT_ID (NUMBER) |
Project (right side, Relations block) |
|
x |
object |
The project on the right side of the relationship. |
|
x |
|
relationType--> Before TeamConnect 3.3 SP2: type--> |
TYPE_ID (NUMBER) |
Relation (Relations block) |
x |
x |
object |
8 The type of relationship between the two projects. --> Links to specific definition information for the relation. |
|
x |
|
version |
VERSION (NUMBER) |
|
x |
|
|
int |
Indicates the number of times the item has been updated. |
|
|