SQL Guide : Database system tables and system views : System tables : SYS_KEYPARTS
  
SYS_KEYPARTS
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).
See also
System tables