CSO_DB_TOPIC_METRICS

This table contains the metric information for discussion topics.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_DB_TOPIC_METRICS_PK	RECORD_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
DATE_ADDED	TIMESTAMP			Yes	This is the datetime that the record was added to the repository.
DATE_MODIFIED	TIMESTAMP			Yes	Datetime record was last modified in repository.
TOPIC_ID	VARCHAR2	32		Yes	This is the GUID reference to the discussion topic
LAST_POST_DATE	TIMESTAMP				This column is the last post datetime for this record.
LAST_MODIFIED_DATE	TIMESTAMP				This is the datetime the topic was last edited or replied to that would affect subscription notifications.
LAST_POST_MESSAGE_ID	VARCHAR2	32			This is the GUID reference to the last posted message.
LAST_POST_USER_ID	VARCHAR2	32			This is the obsolete GUID reference to the user who last posted a message.
LAST_POST_USER_NAME	VARCHAR2	100			Full name of the user who last posted a message or topic.
MESSAGE_COUNT	NUMBER				This is the current count of messages associated with this record.
SOLVED_COUNT	NUMBER				This is the Number of solved messages.
HELPFUL_COUNT	NUMBER				This is the Number of helpful messages.
RECORD_ID	VARCHAR2	32		Yes	This is the primary key of the table.
VIEW_COUNT	NUMBER				This is the latest view count for object.
LAST_POST_USER_PARTY_ID	NUMBER		18		This is the ID of the user who last posted a message.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_DB_TOPIC_METRICS	cso_db_topic	TOPIC_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_DB_TOPIC_METRICS_U1	Unique	Default	RECORD_ID
CSO_DB_TOPIC_METRICS_UK1	Unique	Default	TOPIC_ID