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 unsigned INT that can grow up to 18446744073709551615.

sys_tables

sys_dummy

sys_column_sets

sys_columns

sys_column_defs

sys_column_set_columns

sys_constraint_defs

sys_constraints

sys_column_def_constraints

sys_indices

sys_index_columns

sys_users

sys_user_access_keys

sys_databases

sys_user_permissions