KNTA_DOCUMENTS

This table stores data for documents such as file size, author, description, checked out user and date.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_PARAM_SET_FIELDS_NLS

PARAMETER_SET_FIELD_ID

DOCUMENT_HOLDER_ID

KNTA_PARAM_SET_FIELDS_NLS

PARAMETER_SET_FIELD_ID

DOCUMENT_TYPE_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_ENTITIES_NLS

ENTITY_ID

PARENT_ENTITY_ID

Column Descriptions

Column Name

Null?

Data Type

Description

DOCUMENT_ID

NOT NULL

NUMBER

System-generated identifier

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

NAME

NOT NULL

VARCHAR2(200)

File name minus extension

EXTENSION

NULLABLE

VARCHAR2(50)

Extension

CHECKED_OUT_BY

NULLABLE

NUMBER

User id

CHECKED_OUT_DATE

NULLABLE

DATE

Date

CHECKED_IN_BY

NOT NULL

NUMBER

User id

CHECKED_IN_DATE

NOT NULL

DATE

Date

DESCRIPTION

NULLABLE

VARCHAR2(1800)

Description

AUTHOR

NULLABLE

VARCHAR2(200)

Author, free-form text

FILESIZE

NOT NULL

NUMBER

File size

VERSION_NUMBER

NOT NULL

NUMBER

Version number

KEYWORDS

NULLABLE

VARCHAR2(1800)

Key words

VERSION_COMMENT

NULLABLE

VARCHAR2(200)

Version comment

PARENT_ENTITY_ID

NULLABLE

NUMBER

For example, request

PARENT_PRIMARY_KEY

NULLABLE

NUMBER

For example, containing request ID

DOCUMENT_TYPE_ID

NULLABLE

VARCHAR2(30)

Reference or component

DOCUMENT_HOLDER_ID

NULLABLE

NUMBER

Component index (for example, Field ID of a request)

MIGRATION_STATUS

NOT NULL

NUMBER

This field is only used during DMS Migration: 0 = not migrated, 1 = in the queue for migration, 2 = migrated successfully, 3 = migration failed

LAST_FLAGGED_TIME

NOT NULL

DATE

This field is only used during DMS Migration. It contains the date at which the document was put in the documents migration queue, and is used to detect migration timeouts.

ENGINE_UUID

NULLABLE

VARCHAR2(128)

This field is only used during DMS Migration. It contains an ID uniquely identifying the PPM Node on which migration is running.

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_DOCUMENTS_N1

NONUNIQUE

1

PARENT_ENTITY_ID

KNTA_DOCUMENTS_N1

NONUNIQUE

2

PARENT_PRIMARY_KEY

KNTA_DOCUMENTS_N2

NONUNIQUE

1

DOCUMENT_TYPE_ID

KNTA_DOCUMENTS_N2

NONUNIQUE

2

DOCUMENT_HOLDER_ID

KNTA_DOCUMENTS_U1

UNIQUE

1

DOCUMENT_ID

Sequences

Sequence Name

Sequence Type

KNTA_DOCUMENTS_S

DOCUMENT_ID