WebSphere Commerce database table: SRCH

SRCH_KEYS

Reserved for IBM internal use. Primary key generation store

Column Descriptions:

Name Type Description
SRCH_KEYS_ID BIGINT NOT NULL Primary key
SEQ_NAME VARCHAR (256) NOT NULL The name of the primary key sequence used by a JPA entity
SEQ_COUNT INTEGER The next available value for the Key
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
P_0050 SRCH_KEYS_ID Primary Key
I0001544 SEQ_NAME Unique Index

Name	Type	Description
SRCH_KEYS_ID	BIGINT NOT NULL	Primary key
SEQ_NAME	VARCHAR (256) NOT NULL	The name of the primary key sequence used by a JPA entity
SEQ_COUNT	INTEGER	The next available value for the Key
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.