Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: SUBKEYS
This table is used by the IdResolver to resolve the primary identifiers of the database tables. If a new table is added to the schema, and if the primary identifier has to be resolved, an entry for that table has to be made in the SUBKEYS table. It is used in the same way as the KEYS table is used.
Column Name Column Type Description SUBKEYS_ID INTEGER NOT NULL The internally generated unique ID. TABLENAME CHAR(10) NOT NULL The table into which the next key value is inserted. COLUMNNAME CHAR(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 I0000241 TABLENAME Unique Index SQL100520030435940 SUBKEYS_ID Primary Key
Related reference
_vcc_freeselect_bottom_