Name 

Type 

Description 

table_id 

BIGINT 

Table this index belongs to. References systables (id) 

id 

INTEGER 

Unique id per-table 

name 

VARCHAR 

Constraint name 

keys 

VARCHAR 

Physical column ids (not column positions) of the columns in this index. Seperated by and ending with the '|' ("vertical bar" or "pipe") character, eg. "0|1|3|" 

ref_table_id 

BIGINT 

Id of the table if this index is a foreign key, or -1 if none. May reference systables (id) 

ref_id 

SMALLINT 

Id of the foreign index, or -1 if none. May reference sysindexes (id) 

on_update 

SMALLINT 

The ON UPDATE action of a foreign key. 0: NOACTION (default); 1: CASCADE 

on_delete 

SMALLINT 

The ON DELETE action of a foreign key. 0: NOACTION (default); 1: CASCADE 

unique 

SMALLINT 

The UNIQUE option. 1: index is UNIQUE, 0: index is not UNIQUE 

height 

INTEGER 

Height of the b+tree 

dpages 

INTEGER 

Number of data leaf pages of the b+tree