CSO_COLL_STAT_THRESHOLD

This table stores statistics threshold for collection.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_COLL_STAT_THRESHOLD_PK	STAT_ID, COLLECTION_ID

Columns

Name	Datatype	Length	Not-null	Comments
ABS_THRESHOLD	NUMBER	38		This is the Absolute threshold for this record.
COLLECTION_ID	NUMBER	38	Yes	A foreign key reference to COLLECTION_ID in CSO_COLLECTION table.
REL_THRESHOLD	NUMBER	38		This is the Relative threshold for this record.
STAT_ID	NUMBER	38	Yes	A foreign key reference to STAT_ID in CSO_STAT_TYPE table.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_COLL_STAT_THRESHOLD	cso_stat_type	STAT_ID
CSO_COLL_STAT_THRESHOLD	cso_collection	COLLECTION_ID

Indexes

Index	Uniqueness	Columns
CSO_COLL_STAT_THRESHOLD_U1	Unique	STAT_ID, COLLECTION_ID
CSO_COLL_STAT_THRESHOLD_N1	Non Unique	COLLECTION_ID