CSO_INDEX_QUEUE_ITEM

This table is used to store the Lucene Indexing Requests.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_INDEX_QUEUE_ITEM_PK	RECORD_ID

Columns

Name	Datatype	Length	Not-null	Comments
RECORD_ID	NUMBER		Yes	This is the primary key of the table.
DATE_ADDED	TIMESTAMP		Yes	This is the date that the record was added to the database.
DATE_MODIFIED	TIMESTAMP		Yes	Date record was last modified in database.
REPOSITORY_ID	VARCHAR2	32	Yes	This is the GUID reference to the repository (SITE) that this IndexQueueItem belongs to (for OKOP Compatibility)
ENTITY_NAME	VARCHAR2	50	Yes	This is the Name of the entity to be indexed.
ENTITY_ID	VARCHAR2	32	Yes	The primary key of the entity to be indexed.
INDEX_PRIMARY_KEY	VARCHAR2	4000		(Natural) Primary Key of an item (as defined) in the Index. Useful for SQL free deletions and fast SQLs to load docs for indexing
ENTITY_OPERATION	NUMBER			The Operation that was done on the entity which caused this row to be inserted. (For micro optimization purposes on indexing side).
ACTION	NUMBER		Yes	Action=Index or Delete from Index.
INDEX_GROUP	NUMBER		Yes	Grouping indexes in various ways e.g.: (Live/Staging)
INDEX_OPERATION	NUMBER			IndexOperation to be used when a specific type operation is needed. When not specified, default Operation will be deducted based on Entity Name and Index Action and Group.
PARENT_ID	NUMBER			id of the Parent IndexQueueItem that created this (e.g.: IndexRepository=root, IndexAllChannelsInLive=parent, IndexOneChannelInLive=item).
ROOT_ID	NUMBER			id of the Root IndexQueueItem that triggered this.
CAUSE_ITEM_ID	NUMBER			id of the IndexQueueItem that is the cause for this IndexQueueItem to be inserted. Foreign Key constraints cannot be applied to this column because the Cause Item would have been deleted.
OWNER_INDEXER_NODE_ID	NUMBER			id of the IndexerNode if it should be the only node which should process this item (e.g.: when errored small items are split by group because of errors).
LEADER_FOLLOWER_ACTION	NUMBER			If Item has to be handled specifically only by Leader or Follower or some thing similar.
DOCS_COUNTIN_INDEX	NUMBER			Number of Lucene Documents in the Index - only applicable to Collection Items, Backup Items specific to an Index.
ZIP_PARTS_COUNT	NUMBER			Number of parts the zip file is split in to before it would be uploaded to FMS.
ZIP_CHECKSUM	VARCHAR2	100		Checksum of the zip file (of the index directory) before it would be split in to multiple files and uploaded to FMS.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_INDEX_QUEUE_ITEM	cso_site	REPOSITORY_ID
CSO_INDEX_QUEUE_ITEM	cso_index_queue_item	ROOT_ID
CSO_INDEX_QUEUE_ITEM	cso_index_queue_item	PARENT_ID
cso_index_queue_item_stat	cso_index_queue_item	INDEX_QUEUE_ITEM_ID
cso_index_queue_item	cso_index_queue_item	ROOT_ID
cso_index_queue_item	cso_index_queue_item	PARENT_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_INDEX_QUEUE_ITEM_N1	Non Unique	Default	DATE_ADDED
CSO_INDEX_QUEUE_ITEM_N2	Non Unique	Default	DATE_MODIFIED
CSO_INDEX_QUEUE_ITEM_N3	Non Unique	Default	REPOSITORY_ID
CSO_INDEX_QUEUE_ITEM_N4	Non Unique	Default	ROOT_ID
CSO_INDEX_QUEUE_ITEM_N5	Non Unique	Default	CAUSE_ITEM_ID
CSO_INDEX_QUEUE_ITEM_N6	Non Unique	Default	PARENT_ID
CSO_INDEX_QUEUE_ITEM_U1	Unique	Default	RECORD_ID