Database Tables

The following is a description of the database tables containing the following parameters:

fields of tables with descriptions;

list of table indexes, if indexes are present;

list of links between tables, if links are present.

Links are rules according to which the Server purges outdated and inconsistent information.

Links are described by the following data:

<current_field>

<link_type>

<link_table>.<link_field>

where:

<current_field>—identifier of the field in the current table;

<link_type>—type of link between fields (see below),

<link_table>—name of the table linked with the current table;

<link_field>—identifier of the field in the <link_table>.

The following link types are possible:

Link type

Link description

For any record in the current field, there is a record in the <link_field> in which the value of the <link_field> is equal to the value of the <current_field> in the current table.

For any record in the <link_table>, there is a record in the current table in which the value of the <link_field> is equal to the value of the <current_field> in the current table.

Both of the previous conditions are true.