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 |