This table defines the range of key values for all tables that require a unique key.
Column Name | Column Type | Column Description |
---|---|---|
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. |
KEYS_ID | INTEGER NOT NULL |
The internally generated unique ID. |
LOWERBOUND | BIGINT NULL, DEFAULT 0 |
The lower bound of the range of key values available for this table. |
PREFETCHSIZE | BIGINT NULL, DEFAULT 20 |
The size of the block of keys prefetched by the server. |
TABLENAME | VARCHAR (18) NOT NULL |
The table into which the next key value is inserted. |
UPPERBOUND | BIGINT NULL, DEFAULT 2147483648 |
The upper bound of the range of valid key values for this table. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000144 | TABLENAME | Unique Index |
SQL030416034951620 | KEYS_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|