JContRelation
This information includes the contact on the left and right sides of the relationship and the type of relationship between the two contacts (such as "Attorney for" or "Employee of"). This table represents the Relations block on the Relations tab of a contact record.
Object: JContRelation (J_CONT_RELATION)
|
Attribute |
Database column name |
Field in UI |
End of path |
Bridge |
Links to object table: |
Data type |
Comments |
|---|---|---|---|---|---|---|---|
|
contact--> Before TeamConnect 3.3 SP2:leftContact--> |
LEFT_CONTACT_ID(NUMBER) |
Contact (left-side) |
x |
x |
object |
8 The contact that is on the left side of the relationship. --> Links to specific information for the contact record. Note: The distinction between right and left contact in Team Connect 3.4 is determined by a 3.4-specific attribute named relationDirection. |
|
|
primaryKey |
PRIMARY_KEY (NUMBER) |
x |
int |
The unique ID of the relation record. |
|||
|
contact--> Before TeamConnect 3.3 SP2: rightContact--> |
RIGHT_CONTACT_ |
Contact (rightside) |
x |
x |
object |
8 The contact that is on the right side of the relationship. --> Links to specific information for the contact record. Note: The distinction between right and left contact in Team Connect 3.4 is deter mined by a 3.4-specific attribute named relationDirection. |
|
|
relationType Before TeamConnect 3.3 SP2: typeID |
TYPE_ID (NUMBER) |
Relation |
x |
x |
object |
8 The type of the relationship. --> Links to definition information for the relation type. |
|
|
version |
VERSION (NUMBER) |
x |
int |
Indicates how many times the relation record was updated. |
LContRelationType
LContRelationType contains information about the relationship types defined for contact records. This information includes the name of the relation type, tree position, and display order. This table represents the Contact Relation Type system lookup table.
Object: LContRelationType (L_CONT_RELATION_TYPE)
|
Attribute |
Database column name |
Field in UI |
End of path |
Bridge |
Data type |
Comments |
|---|---|---|---|---|---|---|
|
childList--> |
n/a |
Do not apply. These lookup items cannot have a hierarchical structure. |
||||
|
parent--> |
PARENT_ID (NUMBER) |
|||||
|
displayOrder |
DISPLAY_ORDER (NUMBER) |
Order |
x |
int |
The order in which the table items will be listed in the GUI, lowest number first. |
|
|
name |
NAME (VARCHAR2) (50) |
Item Name |
x |
string (50) |
The name of the relation type. |
|
|
primaryKey |
PRIMARY_KEY (NUMBER) |
x |
int |
The unique ID of the relation type list item. |
||
|
treePosition |
TREE_POSITION (VARCHAR2) (250) |
Tree Position |
x |
string (250) |
The unique four-character alphanumeric code that is created when the relation type is defined. |
|
|
version |
VERSION (NUMBER) |
x |
int |
Indicates how many times the relation type list item was updated. |
||
| isActive | IS_ACTIVE (NUMBER) | boolean |