KNTA_DOCUMENT_HISTORY_CONTENTS

This table is used by PPM Center Database DMS to store the history documents versions contents (that is to say, all versions except the latest version) of all documents, as well as their metadata (for full text search).

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, as in KNTA_DOCUMENTS

VERSION_NUMBER

NOT NULL

NUMBER

Version of the document

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

DOC_CONTENT

NULLABLE

BLOB

BLOB column stores the binary contents of this document version file

EXTENSION

NULLABLE

VARCHAR2(50)

Extension of the file checked in for this document version

VERSION_COMMENT

NULLABLE

VARCHAR2(200)

Version comment submitted by the user when this version was submitted

FULL_TEXT_META

NULLABLE

VARCHAR2(1)

Flag field used for indexing (multi-column metadata TEXT index). A trigger will update it every time any of the indexed metadata columns are updated.

Indexes

Index Name

Index Type

Sequence

Column Name

SYS_C007891982

UNIQUE

1

VERSION_NUMBER

SYS_C007891982

UNIQUE

2

DOCUMENT_ID

Sequences

This table does not use any sequences.