SRCH_KEYS

Reserved for HCL internal use. Primary key generation store

Column Descriptions:

NameTypeDescription
SRCH_KEYS_IDBIGINT NOT NULLPrimary key
SEQ_NAMEVARCHAR (256) NOT NULLThe name of the primary key sequence used by a JPA entity
SEQ_COUNTINTEGERThe next available value for the Key
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
P_0050SRCH_KEYS_IDPrimary Key
I0001544SEQ_NAMEUnique Index