ARM_COMMENTS

This table stores the relation between the object and the text record that stores the comment.

Details

Object type: TABLE

Primary Key

Name	Columns
ARM_COMMENTS_PK	COMMENT_ID

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
COMMENT_ID	NUMBER		18	0	No	Unique identifier
OBJECT_ID	NUMBER		18	0	Yes	ID of the object the Comment is tied to. Currently restricted to profile instances only.
COMMENT_TEXT	CLOB				Yes	The text of the comment.
CREATOR_ID	VARCHAR2	255			No	The user ID of the person who created this.
USER_CREATION_DATE	DATE				No	Date when this comment was created.
OBJECT_VERSION_NUMBER	NUMBER		18	0	No	Used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LAST_UPDATE_LOGIN	NUMBER				Yes	Who column. Stores the login/session ID of the user who last updated this row.
LAST_UPDATE_DATE	DATE				No	Who column. Stores the date when this row was last updated.
LAST_UPDATED_BY	VARCHAR2	255			No	Who column. Stores the ID of the user who last updated this row.
CREATION_DATE	DATE				No	Who column. Stores the date when this row was created in the database.
CREATED_BY	VARCHAR2	255			No	Who column. Stores the ID of the user who created this row.
CREATOR_ROLE	VARCHAR2	3			Yes	The owner role: P=Preparer, R=Reviewer, C=Commentator, V=Viewer
PRIOR_COMMENT_ID	NUMBER		18	0	Yes	Prior comment ID for copied-forward transactions.

Indexes

Index	Uniqueness	Columns
ARM_COMMENTS_N1	NONUNIQUE	OBJECT_ID
ARM_COMMENTS_PK	UNIQUE	COMMENT_ID