KENV_ENV_GROUP_ENVS

This table stores records of which environments are linked to a particular environment group. The execution order of the environments is also stored in the case of the environment group having a serial execution order.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KENV_ENVIRONMENTS

ENVIRONMENT_ID

ENVIRONMENT_ID

KENV_ENV_GROUPS

ENV_GROUP_ID

ENV_GROUP_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

ENV_GROUP_ENV_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

ENV_GROUP_ID

NOT NULL

NUMBER

Environment group ID that is linked to the environment

ENVIRONMENT_ID

NOT NULL

NUMBER

Environment ID that is linked to the environment group

EXECUTION_SEQ

NULLABLE

NUMBER

Sequence that this environment should be executed when the environment group has a serial execution order

Indexes

Index Name

Index Type

Sequence

Column Name

KENV_ENV_GROUP_ENVS_N1

NONUNIQUE

1

ENV_GROUP_ID

KENV_ENV_GROUP_ENVS_N2

NONUNIQUE

1

ENVIRONMENT_ID

KENV_ENV_GROUP_ENVS_U1

UNIQUE

1

ENV_GROUP_ENV_ID

Sequences

Sequence Name

Sequence Type

KENV_ENV_GROUP_ENVS_S

ENV_GROUP_ENV_ID