Database Metadata

dbstruct

Metadata table. Version of the database scheme.

Table fields

Field name

Field type

Description

dbver

INTEGER

database version

Table indexes

Index name

Index type

Fields list

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

field type: 0—string, 1—number, 2—signed

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 a 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 list

tables_fields_0001

simple table index

tabname, fieldname

tables_fields_pkey

table primary key

tabname, fieldno

tables_indices

Metadata table. The list on 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

fields names separated by comma

attrs

INTEGER NOT NULL

index type, see comments above

Table indexes

Index name

Index type

Fields list

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 ''

tables description

Table indexes

Index name

Index type

Fields list

tables_list_0001

simple table index

priority

tables_list_pkey

table primary key

tabname

tables_refs

Metadata table. References between tables 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 ''

default value (do not delete unused records)

Table indexes

Index name

Index type

Fields list

tables_refs_0001

simple table index

src_tbl

tables_refs_pkey

table primary key

ref_tbl, ref_fld, src_tbl, src_fld