CSO_INDEXER_NODE

This table is used to store info about all the unique indexerNodes in the cluster.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_INDEXER_NODE_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.
NODE_UNIQUE_ID	VARCHAR2	100	Yes	UniqueID to differentiate (batch job type) processes that run on a server without port. Value could be as simple as 'INDEXERBATCHJOB' or a UUID. Combination of UNIQUEID+SERVERNAME+SERVERPORT uniquely identifies an indexer. A webapp with only one indexer per tenant should be able to find itself by querying on servername+serverport, a Java SE job should be able to find itself by querying on uniqueid or uniqueid+servername.
SERVER_NAME	VARCHAR2	100	Yes	Host name of the server in which this indexer is running.
SERVER_PORT	NUMBER		Yes	port of the server in which this indexer is running.
REPOSITORY_ID	VARCHAR2	32	Yes	This is the GUID reference to the repository (SITE) that this IndexQueueItem belongs to (for OKOP Compatibility)

Foreign Keys

Table	Foreign Table	Foreign Key Column
cso_index_queue_item_stat	cso_indexer_node	INDEXER_NODE_ID
cso_indexer_control	cso_indexer_node	INDEXER_NODE_ID

Indexes

Index	Uniqueness	Columns
CSO_INDEXER_NODE_U1	Unique	RECORD_ID
CSO_INDEXER_NODE_UK1	Unique	NODE_UNIQUE_ID, SERVER_NAME, SERVER_PORT