KNTA_REF_RELATIONSHIPS

This table stores the list of possible relationships available for each supported source-entity-to-target-entity combinations. It also contains the reverse relationship information where it is applicable.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_ENTITIES_NLS

ENTITY_ID

ENTITY_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_REF_RELATIONSHIPS_NLS

REF_RELATIONSHIP_ID

REVERSE_RELATIONSHIP_ID

Column Descriptions

Column Name

Null?

Data Type

Description

REF_RELATIONSHIP_ID

NOT NULL

NUMBER

System-generated identifier

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

RELATIONSHIP_NAME

NOT NULL

VARCHAR2(80)

Relationship for this source-to-target entity type combination

ENTITY_ID

NOT NULL

NUMBER

Entity type of the source entity

TARGET_TYPE_CODE

NOT NULL

VARCHAR2(30)

Entity type of the target entity

RELATIONSHIP_DESCRIPTION

NULLABLE

VARCHAR2(240)

Description of the relationship name defined when a relationship is being displayed. It contains tokens [SOURCE_ID] and [TARGET_ID] to be replaced by the system to show the relevant information for the source and target entity

CREATION_DESCRIPTION

NULLABLE

VARCHAR2(240)

Description of the relationship name when the relationship is being created. It contains tokens [SOURCE_ID] and [TARGET_ID] to be replaced by the system to show the relevant information for the source and target entity

REVERSE_RELATIONSHIP_ID

NULLABLE

NUMBER

A reference to this table for its reverse relationship information if applicable

REL_BEHAVIOR_CODE

NOT NULL

VARCHAR2(30)

Categorizes the type of relationship between the source entity and target entity (for example, informational)

READ_ONLY_FLAG

NOT NULL

VARCHAR2(1)

Y or N flag to indicate if the relationship could be modified or deleted

SHOW_TARGET_TYPE_FLAG

NOT NULL

VARCHAR2(1)

Y or N flag to indicate whether the relationship is allowed to be used by user to create such relationship. This flag is for internal use.

DEFINITION_LANGUAGE

NOT NULL

VARCHAR2(40)

Definition language

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_REF_RELATIONSHIPS_U1

UNIQUE

1

REF_RELATIONSHIP_ID

Sequences

This table uses no sequences.