KNTA_REFERENCES

This table stores the actual References created. It contains the full information of the source and the target of the reference added and its relationship.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_PARAMETER_SET_CONTEXTS

PARAMETER_SET_CONTEXT_ID

PARAMETER_SET_CONTEXT_ID

KNTA_REF_RELATIONSHIPS_NLS

REF_RELATIONSHIP_ID

REF_RELATIONSHIP_ID

KNTA_REFERENCES

REFERENCE_ID

REVERSE_REFERENCE_ID

KNTA_ENTITIES_NLS

ENTITY_ID

SOURCE_ENTITY_ID

PM_PROJECTS

PROJECT_ID

SOURCE_ID

KCRT_REQUESTS

REQUEST_ID

SOURCE_ID

KDLV_PACKAGES

PACKAGE_ID

SOURCE_ID

KREL_RELEASES

RELEASE_ID

SOURCE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

REFERENCE_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

TARGET_TYPE_CODE

NOT NULL

VARCHAR2(30)

Entity ID of the target reference type

REF_RELATIONSHIP_ID

NULLABLE

NUMBER

Relationship ID of this reference

SOURCE_ENTITY_ID

NOT NULL

NUMBER

Entity ID of the entity that owns this reference

SOURCE_ID

NOT NULL

NUMBER

ID of the source entity member

ORIGINAL_SOURCE_ID

NOT NULL

NUMBER

Originating source entity member ID

REVERSE_REFERENCE_ID

NULLABLE

NUMBER

A reference to this table for its reverse reference row if it exists

ENABLED_FLAG

NOT NULL

VARCHAR2(1)

Flag that determines whether this reference is enabled/in-effect

PARAMETER_SET_CONTEXT_ID

NULLABLE

NUMBER

Set Context ID used to tell what fields to show in the dynamic panel

PARAMETER1-20

NULLABLE

VARCHAR2(500)

Target entity member ID

VISIBLE_PARAMETER1-20

NULLABLE

VARCHAR2(500)

Target reference name

OVERRIDE_CODE

NULLABLE

VARCHAR2(30)

Indicates whether a dependent reference has been overridden or not, and if so, the source of the override (user or system)

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_REFERENCES_N1

NONUNIQUE

1

SOURCE_ENTITY_ID

KNTA_REFERENCES_N1

NONUNIQUE

2

SOURCE_ID

KNTA_REFERENCES_N2

NONUNIQUE

1

REF_RELATIONSHIP_ID

KNTA_REFERENCES_N3

NONUNIQUE

1

SOURCE_ID

KNTA_REFERENCES_N4

NONUNIQUE

1

ORIGINAL_SOURCE_ID

KNTA_REFERENCES_U1

UNIQUE

1

REFERENCE_ID

Sequences

Sequence Name

Sequence Type

KNTA_REFERENCES_S

REFERENCE_ID