WebSphere Commerce database table: KEYS

This table defines the range of key values for all tables that require a unique key.

Column Descriptions
Column Name Column Type Description
KEYS_ID INTEGER NOT NULL The internally generated unique ID.
TABLENAME VARCHAR(18) NOT NULL The table into which the next key value is inserted.
COLUMNNAME VARCHAR(18) NOT NULL The column into which the next key value is inserted.
COUNTER BIGINT NOT NULL The next starting key value to be fetched by the server from the database.
PREFETCHSIZE BIGINT DEFAULT 20 The size of the block of keys prefetched by the server.
LOWERBOUND BIGINT DEFAULT 0 The lower bound of the range of key values available for this table.
UPPERBOUND BIGINT DEFAULT 2147483648 The upper bound of the range of valid key values for this table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000144 TABLENAME Unique Index
SQL060903235210230 KEYS_ID Primary Key