CSO_DB_FORUM_METRICS

This table contains the metric information for discussion forums.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_DB_FORUM_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.
FORUM_ID	VARCHAR2	32		Yes	This is the GUID reference to the discussion forum
LAST_POST_DATE	TIMESTAMP				This column is the last post datetime for this record.
LAST_POST_MESSAGE_ID	VARCHAR2	32			This is the GUID reference to the last posted message.
LAST_POST_TOPIC_ID	VARCHAR2	32			This is the GUID reference to the last posted topic
LAST_POSTUSER_ID	VARCHAR2	32			This is the obsolete GUID reference to the user who last posted a message or topic
LAST_POST_USER_NAME	VARCHAR2	100			Full name of the user who last posted a message or topic
LOCALE_ID	VARCHAR2	32		Yes	This is the GUID reference to the locale of the topic or message.
MESSAGE_COUNT	NUMBER				This is the current count of messages associated with this record.
RECORD_ID	VARCHAR2	32		Yes	This is the primary key of the table.
TOPIC_COUNT	NUMBER				This is the current count of topics.
VIEW_COUNT	NUMBER				Thi sis 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 or topic

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_DB_FORUM_METRICS	cso_db_forum	FORUM_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_DB_FORUM_METRICS_U1	Unique	Default	RECORD_ID
CSO_DB_FORUM_METRICS_UK1	Unique	Default	FORUM_ID, LOCALE_ID