This table is used for capturing search related
statistics at runtime.
Column Descriptions:
| Name | Type | Description |
| SRCHSTAT_ID | BIGINT NOT NULL | Internal generated entry identifier |
| KEYWORD | VARCHAR (254) | Search keyword specified by shopper |
| LANGUAGE_ID | INTEGER NOT NULL | Language used for the session of the shopper |
| STOREENT_ID | INTEGER NOT NULL | The store identifier |
| CATALOG_ID | BIGINT NOT NULL | Catalog used for the search operation |
| KEYWORDCOUNT | BIGINT NOT NULL | The number of search operations for a
keyword |
| SEARCHCOUNT | BIGINT NOT NULL | The average number of search records returned
upon a search operation |
| SUGGESTIONCOUNT | BIGINT | The number of the keyword's first suggestion
result |
| SUGGESTION | VARCHAR (254) | List of keyword suggestions upon a search
miss |
| LOGDETAIL | VARCHAR (2048) | List of synonyms of a search term. |
| LOGDATE | TIMESTAMP NOT NULL | Date and time where this entry is logged |
| OBJECTTYPE | VARCHAR (64) | IBM internal use |
| OBJECT_ID | VARCHAR (64) | IBM internal use |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | SRCHSTAT_ID | Primary Key |
| I0001391 |
KEYWORD+LANGUAGE_ID+STOREENT_ID+KEYWORDCOUNT+LOGDATE+SEARCHCOUNT+SUGGESTION | Non-Unique Index |
| I0001392 | STOREENT_ID+LOGDATE | Non-Unique Index |