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.