Database Table: KEYS

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000144 TABLENAME Unique Index
SQL030416034951620 KEYS_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable