Reference > Database > WebSphere Commerce database tables > K
WebSphere Commerce database table: KEYS
This table defines the range of key values for all tables that require a unique key.
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 SQL100520030349710 KEYS_ID Primary Key
Related reference
_vcc_freeselect_bottom_