sys.objects
| name | type | references | description |
|---|---|---|---|
| "id" | INTEGER | The internal object identifier. Primary key of this table is the combination of "id" and "nr". | |
| "name" | VARCHAR | The SQL name. | |
| "nr" | INTEGER | Position within the object list. |
sys.keys
| name | type | references | description |
|---|---|---|---|
| "id" | INTEGER | sys.objects.id | The unique internal key identifier. |
| "table_id" | INTEGER | sys.tables.id | The corresponding table identifier. |
| "type" | INTEGER | sys.key_types.key_type_id | Key type id: 0=Primary Key, 1=Unique Key, 2=Foreign Key, see table sys.key_types. |
| "name" | VARCHAR | The SQL name given to the key. | |
| "rkey" | INTEGER | sys.keys.id when rkey > 0 | Related key designator. -1 if not applicable. |
| "action" | INTEGER | FKey on UPDATE/DELETE rule action type: 0=NO ACTION, 1=CASCADE, 2=RESTRICT, 3=SET NULL, 4=SET DEFAULT. -1 if not applicable. |
sys.key_types
| name | type | references | description |
|---|---|---|---|
| "key_type_id" | SMALLINT | The unique internal identifier of a key type. | |
| "key_type_name" | VARCHAR | A description of the key type. |
sys.idxs
| name | type | references | description |
|---|---|---|---|
| "id" | INTEGER | sys.objects.id | The unique internal index identifier. |
| "table_id" | INTEGER | sys.tables.id | The corresponding table identifier. |
| "type" | INTEGER | sys.index_types.index_type_id | The corresponding index type identifier, see table sys.index_types. |
| "name" | VARCHAR | The SQL name. |
sys.idx_types
| name | type | references | description |
|---|---|---|---|
| "index_type_id" | SMALLINT | The unique internal identifier of an index type. | |
| "index_type_name" | VARCHAR | A description of the index type. |
sys.sequences
| name | type | references | description |
|---|---|---|---|
| "id" | INTEGER | The unique internal sequence identifier. | |
| "schema_id" | INTEGER | sys.schemas.id | The corresponding schema identifier. |
| "name" | VARCHAR | The SQL name. | |
| "start" | BIGINT | The start value of the sequence. | |
| "minvalue" | BIGINT | The minimal value of the sequence. | |
| "maxvalue" | BIGINT | The maximal value of the sequence. | |
| "increment" | BIGINT | The sequence increment value. | |
| "cacheinc" | BIGINT | The increment to ease transaction management. | |
| "cycle" | BOOLEAN | The repeat the sequence upon hitting its bounds. |