ITG_NOTES

This table stores notes information for PPM entities.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_USERS

USER_ID

OWNER_ID

Back to top

Column Descriptions

Column Name

Null?

Data Type

Description

NOTE_ID

NOT NULL

NUMBER

System-generated identifier

VERSION

NOT NULL

NUMBER

System-generated version for the entity. This column must not be updated manually

NOTE_TEXT

NULLABLE

CLOB

Defines text of the note that was set.

NOTE_TYPE

NOT NULL

VARCHAR2(30)

Note type: html, pdf, txt

OWNER_ID

NULLABLE

NUMBER

User who owns this note

CREATED_BY

NOT NULL

NUMBER

User who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

IDX

NULLABLE

NUMBER

Reserved for internal use. Index of the note.

NOTE_HTML NULLABLE CLOB Stores the HTML code of notes when rich text notes are enabled. The non-HTML content is always stored in NOTE (CLOB) column, even when rich text notes are enabled.

Back to top

Indexes

Index Name

Index Type

Sequence

Column Name

ITG_NOTES_N1

NONUNIQUE

1

OWNER_ID

SYS_C005201540

UNIQUE

1

NOTE_ID

Sequences

Sequence Name

Sequence Type

ITG_NOTES_S

NOTE_ID