|
dbstruct
Metadata table. Version of the database scheme.
Table fields
Field name
|
Field type
|
Description
|
dbver
|
INTEGER
|
database version
|
dbuuid
|
VARCHAR(36)
|
database UUID
|
Table indexes
Index name
|
Index type
|
Fields
|
dbstruct_pkey
|
table primary key
|
dbver
|
tables_fields
Metadata table. Information on the fields of database tables.
Table fields
Field name
|
Field type
|
Description
|
fieldno
|
INTEGER NOT NULL
|
field number
|
fieldtype
|
INTEGER NOT NULL
|
0—string,
1—number,
2—signed,
4—max length string,
5—CLOB,
6—SERIAL
|
maxval
|
NUMERIC(19) NOT NULL
|
field maximal value (integer) or length
|
tabname
|
VARCHAR(128) NOT NULL
|
table name
|
fieldname
|
VARCHAR(128) NOT NULL
|
field name
|
attributes
|
NUMERIC(19) NOT NULL
|
field attributes as bit flags, see above
|
default_value
|
VARCHAR(256) DEFAULT ''
|
field default value
|
comments
|
VARCHAR(256) DEFAULT ''
|
field comments
|
Table indexes
Index name
|
Index type
|
Fields
|
tables_fields_0001
|
simple table index
|
tabname, fieldname
|
tables_fields_pkey
|
table primary key
|
tabname, fieldno
|
tables_indices
Metadata table. The list of indexes and primary keys in the database tables.
Table fields
Field name
|
Field type
|
Description
|
indexname
|
VARCHAR(128) NOT NULL
|
index name
|
tabname
|
VARCHAR(128) NOT NULL
|
name of an index table
|
fields
|
VARCHAR(256) NOT NULL
|
field names separated by comma
|
attrs
|
INTEGER NOT NULL
|
index type, see comments above
|
Table indexes
Index name
|
Index type
|
Fields
|
tables_indices_pkey
|
table primary key
|
indexname
|
tables_list
Metadata table. The list of all database tables.
Table fields
Field name
|
Field type
|
Description
|
priority
|
INTEGER NOT NULL
|
backup priority
|
subsystem
|
INTEGER NOT NULL
|
table subsystem
|
tabname
|
VARCHAR(128) NOT NULL
|
table name
|
description
|
VARCHAR(256) DEFAULT ''
|
table description
|
Table indexes
Index name
|
Index type
|
Fields
|
tables_list_0001
|
simple table index
|
priority
|
tables_list_pkey
|
table primary key
|
tabname
|
tables_refs
Metadata table. References between table fields.
Table fields
Field name
|
Field type
|
Description
|
ref_tbl
|
VARCHAR(64) NOT NULL
|
reference table name
|
ref_fld
|
VARCHAR(64) NOT NULL
|
reference field name
|
src_tbl
|
VARCHAR(64) NOT NULL
|
source table name
|
src_fld
|
VARCHAR(64) NOT NULL
|
source field name
|
attrs
|
INTEGER NOT NULL
|
reference attribute as a bitmask (1—delete dangling references, 2—delete unused records)
|
def_val
|
VARCHAR(256) DEFAULT ''
|
value for valid undef. reference
|
Table indexes
Index name
|
Index type
|
Fields
|
tables_refs_0001
|
simple table index
|
src_tbl
|
tables_refs_pkey
|
table primary key
|
ref_tbl, ref_fld, src_tbl, src_fld
|
|