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.