KNTA_DOCUMENT_VERSIONS

This table is used by PPM Center Database DMS to store the version metadata such as Version comment, file size, and so on.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

DOCUMENT_ID

NOT NULL

NUMBER

Document ID

VERSION_NUMBER

NOT NULL

NUMBER

Document version number

CREATION_DATE

NOT NULL

DATE

Date record was created

CREATED_BY

NOT NULL

NUMBER

Identifier for the user that created the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user that last updated the record

EXTENSION

NULLABLE

VARCHAR2(50)

File extension of the file contained in this document version

CHECKED_IN_BY

NOT NULL

NUMBER

User ID of the PPM User that checked in this document version

CHECKED_IN_DATE

NOT NULL

DATE

Check in date of this document version

FILESIZE

NOT NULL

NUMBER

Size (in bytes) of the file contained in this document version

VERSION_COMMENT

NULLABLE

VARCHAR2(200)

Version Comment input by the user when checking in this document version.

Indexes

Index Name

Index Type

Sequence

Column Name

SYS_C007891967

UNIQUE

1

VERSION_NUMBER

SYS_C007891967

UNIQUE

2

DOCUMENT_ID

Sequences

This table does not use any sequences.