CSO_CONTENT_METRICS

This table contains one or more counters for each content record that captures the last access timestamp and the total number of accesses to the record. The default metric is always captured. Additional metrics can be configured in the management console, the reference key for the custom metrics is used to separate out the different counts. An example of a custom metric includes things like number of times a document is printed, etc. The custom counters are incremented by adding JSP tags to the pages to increment the counter.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_CONTENT_METRICS_PK	RECORD_ID

Columns

Name	Datatype	Length	Not-null	Comments
CONTENT_ID	VARCHAR2	32	Yes	This is the Reference to content table record.
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.
IS_DEFAULT	CHAR	1		Flag indicating if this is the default metric for the content record.
LAST_ACCESSED	TIMESTAMP		Yes	The last datetime when the content was accessed.
RECORD_ID	VARCHAR2	32	Yes	This is the primary key of the table.
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			The total number of times the record was accessed.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_CONTENT_METRICS	cso_content	CONTENT_ID
CSO_CONTENT_METRICS	cso_tag	TYPE_ID

Indexes

Index	Uniqueness	Columns
CSO_CONTENT_METRICS_U1	Unique	RECORD_ID
CSO_CONTENT_METRICS_N1	Non Unique	CONTENT_ID, COUNT
CSO_CONTENT_METRICS_N2	Non Unique	COUNT, CONTENT_ID, IS_DEFAULT
CSO_CONTENT_METRICS_N3	Non Unique	TYPE_ID
CSO_CONTENT_METRICS_UK1	Unique	CONTENT_ID, TYPE_ID