Show/Hide Toolbars

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

TProject

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

TProject

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

LProjRelationType

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.