KENV_OBJECTS
This table stores all of the objects that can be compared using the Environment Comparison Reports. Objects can either be Oracle database objects, SQL Server database objects, or file system objects. When you compare an object, you also compare all of the objects within its hierarchy; for example, when comparing tables in two environments, you also compare the columns for the tables.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_USERS |
USER_ID |
CREATED_BY |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
KENV_OBJECTS |
OBJECT_ID |
PARENT_OBJECT_ID |
KENV_OBJECT_ATTRIBUTES |
OBJECT_ATTRIBUTE_ID |
PRIMARY_KEY_ATTRIBUTE_ID |
KENV_OBJECT_ATTRIBUTES |
OBJECT_ATTRIBUTE_ID |
USER_KEY_ATTRIBUTE_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
OBJECT_ID |
NOT NULL |
NUMBER |
System-generated identifier |
USER_KEY_ATTRIBUTE_ID |
NOT NULL |
NUMBER |
Attribute identifier for the displayed unique key for the object |
PRIMARY_KEY_ATTRIBUTE_ID |
NOT NULL |
NUMBER |
Attribute identifier for the primary key for the object |
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 |
DESCRIPTION |
NULLABLE |
VARCHAR2(240) |
A description for the object |
ORIGINAL_ENABLED_FLAG |
NOT NULL |
VARCHAR2(1) |
Original value of Enabled Flag for seeded rows |
ENABLED_FLAG |
NOT NULL |
VARCHAR2(1) |
Indicates whether the object can be used in comparisons |
OBJECT_LEVEL |
NOT NULL |
NUMBER |
Level within the object hierarchy |
OBJECT_SOURCE |
NOT NULL |
VARCHAR2(80) |
Source of the object (Oracle, SQL Server, or file system) |
TABLE_NAME |
NULLABLE |
VARCHAR2(80) |
For database objects, the name of the table |
PARENT_OBJECT_ID |
NULLABLE |
NUMBER |
If the Object Level is not 0, the identifier for the parent object within the hierarchy |
SELECT_CONDITION |
NULLABLE |
VARCHAR2(2000) |
For database objects, the WHERE condition that restricts what objects are queried |
SELECT_SQL |
NULLABLE |
CLOB |
For database objects, the specific SQL used to query the objects |
SELECT_ORDERBY |
NULLABLE |
VARCHAR2(2000) |
For database objects, the ORDER BY clause used to sort the objects |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KENV_OBJECTS_U1 |
UNIQUE |
1 |
OBJECT_ID |
Sequences
This table uses no sequences.