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.