Column name
|
Data type
|
Description
|
---|---|---|
ID
|
INTEGER
|
This column is a foreign key reference to sys_keys.id, so that you can determine which key each keypart is part of.
|
REL_ID
|
INTEGER
|
The relation identifier as in SYS_TABLES.
|
KEYP_NO
|
INTEGER
|
Keypart identifier.
|
ATTR_ID
|
INTEGER
|
Column identifier.
|
ATTR_NO
|
INTEGER
|
The number of the column in the table (in creation order).
|
ATTR_TYPE
|
INTEGER
|
The type of the column.
|
CONST_VALUE
|
VARBINARY
|
Constant value or NULL.
|
ASCENDING
|
CHAR
|
Is the key ascending (Yes) or descending (No).
|