METRICSUM

This table holds the summary count of resource metrics.

Column Descriptions:

Name	Type	Description
KEY	BIGINT NOT NULL	The unique key with which the metric summary count is associated.
METRIC_ID	SMALLINT NOT NULL	The unique identifier of the resource metric.
STOREENT_ID	INTEGER NOT NULL	The unique identifier of the store in which the justification can be applied.
COUNT	INTEGER NOT NULL	The summary count of the metric.
TIMECREATED	TIMESTAMP NOT NULL	Creation date and time.
LASTUPDATED	TIMESTAMP NOT NULL	Last updated date and time.
OPTCOUNTER	SMALLINT	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
P_METRICSUM	KEY + METRIC_ID	Primary Key

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_METRICSUM_METRIC_ID	METRIC_ID	METRIC	METRIC_ID	Cascade
F_METRICSUM_STOREENT_ID	STOREENT_ID	STOREENT	STOREENT_ID	Cascade