KNTA_PREPARED_COMMAND_STEPS

This table stores the actual execution steps after the steps are parsed and special commands have been expanded. The commands may contain runtime tokens that will be parsed only at runtime.

Foreign Keys

 

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_PREPARED_COMMANDS

PREPARED_COMMAND_ID

PREPARED_COMMAND_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

PREPARED_COMMAND_STEP_ID

NOT NULL

NUMBER

System-generated identifier

PREPARED_COMMAND_ID

NOT NULL

NUMBER

Identifier for the prepared command to which this step belongs

SEQ

NOT NULL

NUMBER

Sequence in which the command steps will be executed

COMMAND

NULLABLE

VARCHAR2(4000)

Actual command that will be executed

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

PREPARED_SPECIAL_COMMAND_ID

NULLABLE

NUMBER

Identifier for the prepared special command to which this step belongs

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_PREPARED_COMMAND_STEPS_N1

NONUNIQUE

1

PREPARED_COMMAND_ID

KNTA_PREPARED_COMMAND_STEPS_U1

UNIQUE

1

PREPARED_COMMAND_STEP_ID

Sequences

Sequence Name

Sequence Type

KNTA_PREPARED_COMMAND_STEPS_S

PREPARED_COMMAND_STEP_ID