KVER_REVISIONS

This table stores all of the revision information that happens with Version Control.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KVER_FILES

FILE_ID

FILE_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

REVISION_ID

NOT NULL

NUMBER

Unique ID for each revision

FILE_ID

NOT NULL

NUMBER

Unique ID for each file

LAST_UPDATED_BY

NOT NULL

VARCHAR2(30)

The last person to perform a check in

LAST_UPDATE_DATE

NOT NULL

DATE

Date of last check in

CREATED_BY

NOT NULL

VARCHAR2(30)

Person who created the file

CREATION_DATE

NOT NULL

DATE

Date the file was created

LOCKED_FLAG

NOT NULL

VARCHAR2(1)

Lock status of the file (Y/N)

REVISION_NUMBER

NOT NULL

VARCHAR2(30)

Revision number for the version of the file

LOG_MSG

NULLABLE

VARCHAR2(200)

Log message for each revision checked into the Version Control

DESCRIPTION

NULLABLE

VARCHAR2(200)

Description associated with the file

REFERENCE_ID

NULLABLE

VARCHAR2(30)

Reference number associated with each file (generally the Change Request number)

REFERENCE_TYPE_CODE

NULLABLE

VARCHAR2(30)

Entity code associated with the reference type (generally a "1" for a package)

Indexes

Index Name

Index Type

Sequence

Column Name

KVER_REVISIONS_N1

NONUNIQUE

1

FILE_ID

KVER_REVISIONS_N2

NONUNIQUE

1

REVISION_NUMBER

KVER_REVISIONS_N3

NONUNIQUE

1

LOCKED_FLAG

KVER_REVISIONS_U1

UNIQUE

1

REVISION_ID

Sequences

Sequence Name

Sequence Type

KVER_REVISIONS_S

REVISION_ID