Other Tables

cluster_message

Long commands transmitted between nodes of the Servers cluster.

Table fields

Field name

Field type

Description

sid

VARCHAR(36) NOT NULL

destination station ID

mid

NUMERIC(19) NOT NULL

message ID

command

CLOB NOT NULL

message body

Table indexes

Index name

Index type

Fields list

cluster_message_pkey

table primary key

mid

oauth_clients

Credentials of external applications for OAuth authorization.

Table fields

Field name

Field type

Description

id

VARCHAR(255) NOT NULL

identifier

secret

VARCHAR(255) NOT NULL

shared secret

title

VARCHAR(255) NOT NULL

short name

description

TEXT DEFAULT ''

description

icon_url

TEXT DEFAULT ''

icon URL

homepage

TEXT DEFAULT ''

home page (promo page)

created

NUMERIC(17) NOT NULL

creation time

token_ttl

INTEGER DEFAULT '3600' NOT NULL

TTL (sec) for new tokens

code_ttl

INTEGER DEFAULT '600' NOT NULL

TTL (sec) for new authorization codes

user_id

VARCHAR(255) DEFAULT ''

owner identifier, for built-in applications must be empty

client_type

INTEGER DEFAULT '0' NOT NULL

client type: 0 - built-in, 1 - custom

client_status

INTEGER DEFAULT '0' NOT NULL

client current status: 0 - disabled, 1 - enabled

Table indexes

Index name

Index type

Fields list

oauth_clients_0001

unique table index

secret

oauth_clients_pkey

table primary key

id

oauth_codes

Authorization codes of external applications for OAuth authorization.

Table fields

Field name

Field type

Description

client_id

VARCHAR(255) NOT NULL

identifier of an application for which the code is given out

user_id

VARCHAR(255) NOT NULL

identifier of a user who requested a code

code

VARCHAR(40) NOT NULL

authorization code

created

NUMERIC(17) NOT NULL

creation time

expires

NUMERIC(17) NOT NULL

expiration time (oauth_codes.created + oauth_clients.code_ttl)

redirect_uri

TEXT NOT NULL

redirect URI from user request. Used to verify a request when exchanging a code to a token

state

TEXT DEFAULT ''

custom field from user request. Used to verify a request when exchanging a code to a token

Table indexes

Index name

Index type

Fields list

oauth_codes_pkey

table primary key

code

Table references

Field name

Direction

Referenced table field

client_id

oauth_clients.id

oauth_tokens

Access tokens external applications for OAuth authorization.

Table fields

Field name

Field type

Description

token_access

VARCHAR(40) NOT NULL

access token

token_refresh

VARCHAR(40) NOT NULL

refresh token

created

NUMERIC(17) NOT NULL

creation time

expires

NUMERIC(17) NOT NULL

expiration time (oauth_tokens.created + oauth_clients.token_ttl)

user_id

VARCHAR(255) NOT NULL

identifier of a user for which the token is given out

client_id

VARCHAR(255) NOT NULL

identifier of an application for which the code is given out

Table indexes

Index name

Index type

Fields list

oauth_tokens_0001

simple table index

token_refresh

oauth_tokens_pkey

table primary key

token_access

Table references

Field name

Direction

Referenced table field

client_id

oauth_clients.id

report_auto

Financial reports sent automatically by a task from the Server schedule (AV-Desk only).

Table fields

Field name

Field type

Description

period

NUMERIC(6) NOT NULL

year and month (YYYYMM)

xmlvalue

CLOB DEFAULT ''

XML value

gendate

NUMERIC(17) DEFAULT '0'

generation date

sent

NUMERIC(17) DEFAULT '0'

sent date (0 if was not sent)

errmessage

CLOB DEFAULT ''

error message (if was not sent)

gentime

INTEGER DEFAULT '0'

generation time in seconds

Table indexes

Index name

Index type

Fields list

report_auto_pkey

table primary key

period

report_data

Data on financial reports about tariffs usage (AV-Desk only).

Table fields

Field name

Field type

Description

rate

VARCHAR(36) NOT NULL

tariff group ID

id

VARCHAR(36) NOT NULL

ID of a station where the tariff was used

aid

VARCHAR(36) NOT NULL

UUID of an administrator who ordered to create the report

days

INTEGER DEFAULT '0'

number of days when the tariff was used

user_id

VARCHAR(36) DEFAULT ''

ID of a user using this tariff

gid

VARCHAR(36) DEFAULT ''

user group ID

created

NUMERIC(17) DEFAULT '0'

record creation time

report_id

VARCHAR(36) NOT NULL

report UUID

Table indexes

Index name

Index type

Fields list

report_data_pkey

table primary key

clustering index

aid, rate, id, report_id

Table references

Field name

Direction

Referenced table field

aid

admins.id

report_done_ids

Identifiers of sent financial reports (AV-Desk only).

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

ID of a station where the tariff was used

aid

VARCHAR(36) NOT NULL

UUID of an administrator who created the report

report_id

VARCHAR(36) NOT NULL

report UUID

Table indexes

Index name

Index type

Fields list

report_done_ids_pkey

table primary key

clustering index

report_id, aid, id

Table references

Field name

Direction

Referenced table field

aid

admins.id

report_manual

Financial reports sent manually by administrator (AV-Desk only).

Table fields

Field name

Field type

Description

periodbeg

NUMERIC(17) NOT NULL

report start date

periodend

NUMERIC(17) DEFAULT '0'

report end date

id

VARCHAR(36) NOT NULL

UUID of an administrator who created the report

xmlvalue

CLOB DEFAULT ''

XML value

gendate

NUMERIC(17) NOT NULL

generation date

gentime

INTEGER DEFAULT '0'

generation time in seconds

Table indexes

Index name

Index type

Fields list

report_manual_0001

simple table index

clustering index

id, gendate

Table references

Field name

Direction

Referenced table field

id

admins.id

reporting_ids

Identifiers of financial reports about tariffs usage (AV-Desk only).

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

ID of a station where the tariff was used

aid

VARCHAR(36) NOT NULL

UUID of an administrator who created the report

company_id

VARCHAR(36) DEFAULT ''

user company ID

user_id

VARCHAR(36) DEFAULT ''

ID of a user using this tariff

report_id

VARCHAR(36) NOT NULL

report UUID

Table indexes

Index name

Index type

Fields list

reporting_ids_0001

simple table index

clustering index

report_id, aid

reporting_ids_pkey

table primary key

id, aid, report_id

Table references

Field name

Direction

Referenced table field

aid

admins.id

station_hash

Settings hashes of personal installation packages.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

station ID

hash_code

VARCHAR(20) NOT NULL

hash of URL to personal installation package

createtime

NUMERIC(17) DEFAULT '0'

record creation time

Table indexes

Index name

Index type

Fields list

station_hash_0001

simple table index

hash_code

station_hash_pkey

table primary key

clustering index

id, hash_code

Table references

Field name

Direction

Referenced table field

id

stations.id

station_offline_cmd

Saved commands that must be sent to stations after their connection to the Server.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

station ID

rid

VARCHAR(36) NOT NULL

command UUID

cmd

VARCHAR(256)

command

data

CLOB DEFAULT ''

command data

created

NUMERIC(17) NOT NULL

record creation

min_proto

NUMERIC(5) DEFAULT '0'

minimal protocol version, e.g. 0x0301 is 3.1

Table indexes

Index name

Index type

Fields list

station_offline_cmd_0001

simple table index

created

station_offline_cmd_0002

simple table index

clustering index

id

station_offline_cmd_0003

simple table index

rid

Table references

Field name

Direction

Referenced table field

id

stations.id

temporary_tables

The list of temporary tables.

Table fields

Field name

Field type

Description

table_name

VARCHAR(128) NOT NULL

temporary table name

createtime

NUMERIC(17) DEFAULT '0'

creation time

date1

NUMERIC(17) DEFAULT '0'

start date for statistic data in the table

date2

NUMERIC(17) DEFAULT '0'

end date for statistic data in the table

Table indexes

Index name

Index type

Fields list

temporary_tables_pkey

table primary key

table_name

webmin

Internal data of the Web interface of Dr.Web Security Control Center.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

record owner (admin.id)

rkey

VARCHAR(128) NOT NULL

record key

data

CLOB DEFAULT ''

record data

created

NUMERIC(17) DEFAULT '0'

record creation time

seq

INTEGER NOT NULL

record sequence number for big data sets

Table indexes

Index name

Index type

Fields list

webmin_pkey

table primary key

clustering index

id, rkey, seq

Table references

Field name

Direction

Referenced table field

id

admins.id