CSO_INDEX_QUEUE_ITEM_STAT
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_STAT_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. | |
| INDEX_QUEUE_ITEM_ID | NUMBER | Yes | id of the IndexQueueItem for which this status row is added (by a specific indexer). | |
| INDEXER_NODE_ID | NUMBER | Yes | id of the IndexerNode which added this status row (when it processes the corresponding INDEXQUEUEITEM). | |
| STATUS | NUMBER | Yes | Indexing Status of this Request. | |
| DATE_PROCESSING_STARTED | TIMESTAMP | Timestamp of when the item processing started. | ||
| PROCESSED_COUNT | NUMBER | Number of items processed if this PROCESSED_COUNT. | ||
| TOTAL_COUNT | NUMBER | Number of items processed if this TOTAL_COUNT. | ||
| ERROR_COUNT | NUMBER | This is the number of individual items that failed and reinserted in to the queue when processing a collection. | ||
| CHECKPOINT_ID | VARCHAR2 | 32 | id of the last Entity that is indexed in this collection if this is a collection. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CSO_INDEX_QUEUE_ITEM_STAT | cso_index_queue_item | INDEX_QUEUE_ITEM_ID |
| CSO_INDEX_QUEUE_ITEM_STAT | cso_indexer_node | INDEXER_NODE_ID |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CSO_INDEX_QUEUE_ITEM_STAT_U1 | Unique | RECORD_ID |
| CSO_INDEX_QUEUE_ITEM_STAT_N1 | Non Unique | INDEX_QUEUE_ITEM_ID |
| CSO_INDEX_QUEUE_ITEM_STAT_N2 | Non Unique | STATUS |
| CSO_INDEX_QUEUE_ITEM_STAT_N3 | Non Unique | INDEXER_NODE_ID |