CSO_COLLECTION

This table stores metadata for collections for this schema.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_COLLECTION_PK	COLLECTION_ID

Columns

Name	Datatype	Length	Not-null	Comments
AVAILABILITY	NUMBER	38		A flag indicating the availability of a collection as one of the following: -2 (marked for deletion), -1 (disabled), 0 (index), 1 (index for search)
COLLECTION_ID	NUMBER	38	Yes	This is the primary key of the table.
COLLECTION_NAME	VARCHAR2	255	Yes	This is the Collection name for this record.
COLLECTION_TYPE_ID	NUMBER	38	Yes	This is the type of the collection as one of the following: 1 (HTTP physical collection), 3 (virtual collection), 4 (IM physical collection)
CONFIG_XML	CLOB			Collection configuration in XML format.
CRAWL_NUM	NUMBER	38		Used by collection statistics to distinguish between crawls.
DATE_ADDED	TIMESTAMP	11	Yes	This is the datetime when the collection was added.
DATE_MODIFIED	TIMESTAMP	11	Yes	The last datetime when the collection was modified.
INDEX_NUM	NUMBER	38		Used by collection statistics to distinguish between index runs.
PREP_NUM	NUMBER	38		Used by collection statistics to distinguish between pre-processing runs.
STATUS_COMMENT	VARCHAR2	4000		This is the Status comment for this record.
STATUS_ID	NUMBER	38	Yes	A foreign key reference to STATUS_ID in CSO_STATUS_TYPE table.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_COLLECTION	cso_status_type	STATUS_ID
cso_coll_stat_threshold	cso_collection	COLLECTION_ID
cso_crawler_state	cso_collection	COLLECTION_ID
cso_collection_statistics	cso_collection	COLLECTION_ID
cso_doc_meta_info	cso_collection	COLLECTION_ID

Indexes

Index	Uniqueness	Columns
CSO_COLLECTION_U1	Unique	COLLECTION_ID
CSO_COLLECTION_UK1	Unique	COLLECTION_NAME
CSO_COLLECTION_N1	Non Unique	COLLECTION_TYPE_ID
CSO_COLLECTION_N2	Non Unique	AVAILABILITY
CSO_COLLECTION_N3	Non Unique	STATUS_ID