ASA SQL Reference
System Tables
| 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.user_id |
| index_name | CHAR(128) | NOT NULL | Unique index |
| hash_limit | SMALLINT | NOT NULL | |
| index_owner | CHAR(4) | NOT NULL | |
| index_type | CHAR(4) | NOT NULL | |
| 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.
index_name The name of the index. A user ID cannot have two indexes with the same name in tables that it owns.
index_owner The owner. This field is always SA.
index_type The type. This field is always SA.
remarks A comment string.