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 Descriptions:

NameTypeDescription
SUBKEYS_IDINTEGER NOT NULLThe internally generated unique ID.
TABLENAMECHAR (10) NOT NULLThe table into which the next key value is inserted.
COLUMNNAMECHAR (18) NOT NULLThe column into which the next key value is inserted.
COUNTERBIGINT NOT NULLThe next starting key value to be fetched by the server from the database.
PREFETCHSIZEBIGINT DEFAULT 20The size of the block of keys fetched by the server.
LOWERBOUNDBIGINT DEFAULT 0The lower bound of the range of key values available for this table.
UPPERBOUNDBIGINT DEFAULT 2147483648The upper bound of the range of valid key values for this table.
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
<SYSTEM-GENERATED>SUBKEYS_IDPrimary Key
I0000241TABLENAMEUnique Index