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:
Name | 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 fetched 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | SUBKEYS_ID | Primary Key |
I0000241 | TABLENAME | Unique Index |