KINS_UPGRADE_LOGS

This table stores messages that were generated as a result of the upgrade.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

UPGRADE_LOG_ID

NOT NULL

NUMBER

System-generated identifier

CREATION_DATE

NOT NULL

DATE

Date record was created

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

UPGRADE_RUN_ID

NOT NULL

NUMBER

Identifier for the upgrade run that generated this message

VERSION_NUMBER

NOT NULL

VARCHAR2(20)

Version number of the product

PATCH_NUMBER

NULLABLE

VARCHAR2(20)

Patch number of the product

SOURCE

NOT NULL

VARCHAR2(200)

Script that resulted in this message

MESSAGE_TYPE

NOT NULL

VARCHAR2(30)

Indicates whether the message is a warning or error

MESSAGE

NULLABLE

CLOB

Text of the message

Indexes

Index Name

Index Type

Sequence

Column Name

KINS_UPGRADE_LOGS_N1

NONUNIQUE

1

UPGRADE_RUN_ID

KINS_UPGRADE_LOGS_N1

NONUNIQUE

2

SOURCE

KINS_UPGRADE_LOGS_U1

UNIQUE

1

UPGRADE_LOG_ID

Sequences

Sequence Name

Sequence Type

KINS_UPGRADE_LOGS_S

UPGRADE_LOG_ID