Share this page

# 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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: