JprojRelation
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/ |
||||||||
|
leftProject |
LEFT_ |
Project |
x |
object |
The project on the left side of the relationship. |
x |
|||
|
primaryKey |
PRIMARY_ KEY (NUMBER) |
x |
int |
The unique ID of this item. |
|||||
|
right |
RIGHT_ |
Project |
x |
object |
The project on the right side of the relationship. |
x |
|||
|
relation Type--> Before TeamConnect 3.3 SP2: |
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. |
|||||
LProjRelationType
LProjRelationType contains information about the project relation types defined for custom objects, such as the name of the relation and the tree position. This table represents the Project Relation Type system lookup table.
Object: LProjRelationType (L_PROJ_RELATION_TYPE)
|
Attribute |
Database column name |
Field in UI |
End of path |
Bridge |
Links to object table: |
Data type |
Comments |
Commonly used in: |
|
|---|---|---|---|---|---|---|---|---|---|
|
Rules |
Temp/ |
||||||||
|
childList--> |
n/a |
Do not apply. These lookup items cannot have a hierarchical structure. |
|||||||
|
primaryKey |
PRIMARY_ KEY (NUMBER) |
x |
int |
The unique ID of this item. |
|||||
|
parent--> |
PARENT_ ID (NUMBER) |
Do not apply. These lookup items cannot have a hierarchical structure. |
|||||||
|
display Order |
DISPLAY_ORDER (NUMBER) |
Order (System Lookup Tables, Project Relation Type) |
x |
int |
Indicates the order in which this relation appears in the Type of relationship list in the Relations block of a project. |
||||
| isActive | IS_ACTIVE (NUMBER) | boolean | |||||||
| isCopyable | IS_COPYABLE (NUMBER) | boolean | |||||||
| isVisible | IS_VISIBLE (NUMBER) | boolean | |||||||
| objectDefinitionId | OBJECT_DEFINITION_ID (NUMBER) | number | |||||||
|
name |
NAME (VARCHAR2) (50) |
Item Name (System Lookup Tables, Project Relation Type) |
x |
string (50) |
The name of the relationship type. |
||||
|
tree |
TREE_ |
Tree Position (System Lookup Tables, Project Relation Type) |
x |
string (250) |
The unique four- character alphanumeric code that is created when the relation is defined. |
||||
|
version |
VERSION (NUMBER) |
x |
int |
Indicates the number of times the item has been updated. |
|||||