System Tables⚓︎

This page reference the tables that Siodb manages to function. Siodb adds an internal column TRID. Siodb uses that column as a primary key for all rows in a table. Siodb increment the TRID at each INSERT operation. The number is 64-bit unsigned integer that can grow up to 18446744073709551615.

SYS_TABLES⚓︎

Stores information about known tables.

SYS_DUMMY⚓︎

Helper table for computing constant expressions.

SYS_COLUMN_SETS⚓︎

Stores information about column sets.

SYS_COLUMNS⚓︎

Stores information about table columns.

SYS_COLUMN_DEFS⚓︎

Stores information about column definitions.

SYS_COLUMN_SET_COLUMNS⚓︎

Stores information about inclusion of column definitions into column sets.

SYS_CONSTRAINT_DEFS⚓︎

Stores information about unique constraint definitions.

SYS_CONSTRAINTS⚓︎

Stores information about constraints.

SYS_COLUMN_DEF_CONSTRAINTS⚓︎

Stores information about constraints associated with column definitions.

SYS_INDICES⚓︎

Stores information about indices.

SYS_INDEX_COLUMNS⚓︎

Stores information about indexed columns.

SYS_USERS⚓︎

Stores information about users.

SYS_USER_ACCESS_KEYS⚓︎

Stores information about user's access keys.

SYS_DATABASES⚓︎

Stores information about known databases.

SYS_USER_PERMISSIONS⚓︎

Stores information about user permissions.

SYS_USER_TOKENS⚓︎

Stores authentication tokens.