SYSINDEX system table
1014
SYSINDEX system table
Column name Column type
Column
constraint
Table constraints
table_id UNSIGNED
INT
NOT NULL Primary key, Unique
index. Foreign key
references
SYSTABLE.
index_id UNSIGNED
INT
NOT NULL Primary key
root INTEGER NOT NULL
file_id SMALLINT NOT NULL
"unique" CHAR(1) NOT NULL
creator UNSIGNED
INT
NOT NULL Foreign key
references
SYSUSERPERM.use
r_id
index_name CHAR(128) NOT NULL Unique index
remarks LONG,
VARCHAR
Each index in the database is described by one row in SYSINDEX. Each
column in the index is described by one row in SYSIXCOL.
table_id Uniquely identifies the table to which this index applies.
index_id Each index for one particular table is assigned a unique index
number.
root Indexes are stored in the database as B-trees. The root identifies the
location of the root of the B-tree in the database file.
file_id The index is completely contained in the file with this file_id (see
SYSFILE).
unique Indicate whether the index is a unique index ("Y"), a non-unique
index ("N"), or a unique constraint ("U"). A unique index prevents two rows
in the indexed table from having the same values in the index columns.
creator The user number of the creator of the index. This user is always
the same as the creator of the table identified by table_id.
To Next Page
Loading...