Share this page

# KNTA_DOCUMENT_TIP_CONTENTS

This table is used by PPM Center Database DMS to store the tip content (that is to say, the latest version) of all documents, as well as their metadata.

## 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 Number of the tip version (latest version)
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
FULL_NAME | NOT NULL | VARCHAR2(250) | Full name of the file, that is to say, "filename.extension"
DESCRIPTION | NULLABLE | VARCHAR2(1800) | Document description (input by user upon document creation)
AUTHOR | NULLABLE | VARCHAR2(200) | Document author (free text field, not related to PPM Users)
KEYWORDS | NULLABLE | VARCHAR2(1800) | Keywords linked to the document
DOC_CONTENT | NULLABLE | BLOB | BLOB column stores the binary contents of the document tip version
VERSION_COMMENT | NULLABLE | VARCHAR2(200) | Version comment submitted by user when checking in the tip version (copied from KNTA_DOCUMENT_VERSIONS, used for indexing)
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_C007891975 | UNIQUE | 1 | 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: