CSO_CONTENT_METRICS_QUEUE

This table stores transient details of how many times a content has been viewed on the client application. The rows in this table will be deleted after the view count is merged in to CONTENTMETRICS table for each content/tag combo.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_CONTENT_METRICS_QUEUE_PK	RECORD_ID

Columns

Name	Datatype	Length	Not-null	Comments
RECORD_ID	VARCHAR2	32	Yes	This is the primary key of the table.
DATE_ADDED	TIMESTAMP		Yes	This is the date that the record was added to the repository.
DATE_MODIFIED	TIMESTAMP		Yes	This is the date that the record was modified.
CONTENT_ID	VARCHAR2	32	Yes	This is the Reference to content table record.
IS_DEFAULT	CHAR	1	Yes	Flag indicating if this is the default metric for the content record.
LAST_ACCESSED	TIMESTAMP		Yes	The last datetime when the content was accessed. Note that this may be earlier than the value in ContentMetrics.
TYPE_ID	VARCHAR2	32		This is the GUID pointing to the Tag table indicating whether the metric is the default one or a custom metric
COUNT	NUMBER		Yes	The (incremental) number of times the content record was accessed.
OPTIMISTIC_FAILURE_COUNT	NUMBER			The count of optimistic locking failures faced when merging this record into CONTENTMETRICs.
OTHER_FAILURE_COUNT	NUMBER			The count of other failures faced when merging this record into CONTENTMETRICs.

Indexes

Index	Uniqueness	Columns
CSO_CONTENT_METRICS_QUEUE_U1	Unique	RECORD_ID
CSO_CONTENT_METRICS_QUEUE_N1	Non Unique	DATE_ADDED
CSO_CONTENT_METRICS_QUEUE_N2	Non Unique	DATE_MODIFIED
CSO_CONTENT_METRICS_QUEUE_N3	Non Unique	CONTENT_ID