|
alert_console
Administrator notifications sent by Web console method.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
message UUID
|
subject
|
INTEGER NOT NULL
|
message subject
|
body
|
INTEGER NOT NULL
|
message body
|
read_until
|
NUMERIC(17) DEFAULT '0'
|
message will be deleted after this time
|
admin
|
VARCHAR(36) NOT NULL
|
admin UUID
|
iread
|
INTEGER NOT NULL
|
read flag (0—unread, 1—read, 2—save)
|
gentime
|
NUMERIC(17) DEFAULT '0'
|
message generation time
|
station
|
VARCHAR(36) DEFAULT ''
|
station ID for an event generated for specific station
|
id_alert
|
INTEGER NOT NULL
|
message type
|
Table indexes
Index name
|
Index type
|
Fields list
|
alert_console_0001
|
simple table index
|
admin, iread, id_alert
|
alert_console_0002
|
simple table index
clustering index
|
read_until
|
alert_console_pkey
|
table primary key
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
admin
|
→
|
admins.id
|
body
|
↔
|
cat_alert_body.id
|
subject
|
↔
|
cat_alert_subj.id
|
alert_group
Accordance between administrator notifications and their types.
Table fields
Field name
|
Field type
|
Description
|
id_group
|
INTEGER NOT NULL
|
group ID
|
id_alert
|
INTEGER NOT NULL
|
notification ID
|
Table indexes
Index name
|
Index type
|
Fields list
|
alert_group_pkey
|
table primary key
clustering index
|
id_group, id_alert
|
Table references
Field name
|
Direction
|
Referenced table field
|
id_group
|
→
|
alert_group_list.id_group
|
alert_group_list
The list of administrator notifications types.
Table fields
Field name
|
Field type
|
Description
|
id_group
|
INTEGER NOT NULL
|
group ID
|
name
|
VARCHAR(4000) DEFAULT ''
|
group name in English
|
Table indexes
Index name
|
Index type
|
Fields list
|
alert_group_list_pkey
|
table primary key
|
id_group
|
alert_list
The list of administrator notifications.
Table fields
Field name
|
Field type
|
Description
|
id_alert
|
INTEGER NOT NULL
|
notification ID
|
name
|
VARCHAR(4000) DEFAULT ''
|
notification name in English
|
severity
|
INTEGER DEFAULT '0'
|
notification severity
|
Table indexes
Index name
|
Index type
|
Fields list
|
alert_list_pkey
|
table primary key
|
id_alert
|
alert_mobile
Administrator notifications sent by push method to Dr.Web Mobile Control Center.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
message UUID
|
subject
|
INTEGER NOT NULL
|
message subject
|
body
|
INTEGER NOT NULL
|
message body
|
read_until
|
NUMERIC(17) DEFAULT '0'
|
message will be deleted after this time
|
admin
|
VARCHAR(36) NOT NULL
|
admin UUID
|
iread
|
INTEGER DEFAULT '0'
|
read flag (0—unread, 1—read, 2—save)
|
gentime
|
NUMERIC(17) DEFAULT '0'
|
message generation time
|
station
|
VARCHAR(36) DEFAULT ''
|
station ID to generate event for specific station
|
id_alert
|
INTEGER DEFAULT '0'
|
message type
|
device
|
INTEGER NOT NULL
|
device ID
|
Table indexes
Index name
|
Index type
|
Fields list
|
alert_mobile_0001
|
simple table index
|
admin, device
|
alert_mobile_0002
|
simple table index
clustering index
|
read_until
|
alert_mobile_pkey
|
table primary key
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
admin
|
→
|
admins.id
|
body
|
↔
|
cat_alert_body.id
|
device
|
↔
|
cat_alert_dev.id
|
subject
|
↔
|
cat_alert_subj.id
|
alert_settings
Sets of administrator notifications settings.
Table fields
Field name
|
Field type
|
Description
|
settings_set
|
VARCHAR(36) NOT NULL
|
settings set
|
name
|
VARCHAR(45) NOT NULL
|
setting name
|
value
|
TEXT DEFAULT ''
|
setting value
|
Table indexes
Index name
|
Index type
|
Fields list
|
alert_settings_pkey
|
table primary key
clustering index
|
settings_set, name
|
Table references
Field name
|
Direction
|
Referenced table field
|
settings_set
|
→
|
alert_settings_sets.settings_set
|
alert_settings_sets
Administrator notifications settings.
Table fields
Field name
|
Field type
|
Description
|
id_alert
|
INTEGER NOT NULL
|
notification ID
|
admin
|
VARCHAR(36) NOT NULL
|
UUID of the administrator to receive the notification
|
method
|
INTEGER NOT NULL
|
send method (0—email, 1—windows message, 2—web console, 3—SNMP protocol , 4—Agent protocol)
|
station_group
|
VARCHAR(36) DEFAULT 'none' NOT NULL
|
station group ID
|
settings_set
|
VARCHAR(36) NOT NULL
|
settings set UUID, see alert_settings.settings_set
|
Table indexes
Index name
|
Index type
|
Fields list
|
alert_settings_sets_pkey
|
table primary key
|
id_alert, admin, method, station_group, settings_set
|
Table references
Field name
|
Direction
|
Referenced table field
|
admin
|
→
|
admins.id
|
id_alert
|
→
|
alert_list.id_alert
|
alert_subscribers
Administrators who are subscribed to notifications about events on station groups, and groups of tracked stations (`none` for all groups).
Table fields
Field name
|
Field type
|
Description
|
id_alert
|
INTEGER NOT NULL
|
notification ID
|
admin
|
VARCHAR(36) NOT NULL
|
UUID of the administrator to receive the notification
|
station_group
|
VARCHAR(36) DEFAULT 'none' NOT NULL
|
station group ID, see station_groups
|
Table indexes
Index name
|
Index type
|
Fields list
|
alert_subscribers_pkey
|
table primary key
clustering index
|
admin, id_alert, station_group
|
Table references
Field name
|
Direction
|
Referenced table field
|
admin
|
→
|
admins.id
|
id_alert
|
→
|
alert_list.id_alert
|
station_group
|
→
|
groups_list.id
|
alert_templates
Templates of administrator notifications.
Table fields
Field name
|
Field type
|
Description
|
id_alert
|
INTEGER NOT NULL
|
notification ID
|
method
|
INTEGER NOT NULL
|
send method (0—email, 1—windows message, 2—web console, 3—SNMP protocol , 4—Agent protocol)
|
admin
|
VARCHAR(36) DEFAULT 'none' NOT NULL
|
UUID of the administrator to receive the notification
|
language
|
VARCHAR(2) NOT NULL
|
template language
|
body
|
CLOB NOT NULL
|
template body
|
Table indexes
Index name
|
Index type
|
Fields list
|
alert_templates_pkey
|
table primary key
|
id_alert, method, admin, language
|
Table references
Field name
|
Direction
|
Referenced table field
|
admin
|
→
|
admins.id
|
alert_unsent
Unsent administrator notifications.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
record UUID (to access unique record)
|
id_alert
|
INTEGER NOT NULL
|
notification ID
|
settings_set
|
VARCHAR(36) DEFAULT ''
|
settings set UUID, see alert_settings.settings_set
|
id_binding
|
VARCHAR(36) DEFAULT ''
|
bound variables set UUID, see alert_unsent_bindings
|
admin
|
VARCHAR(36) DEFAULT ''
|
UUID of the administrator to receive the notification
|
time_to_live
|
INTEGER DEFAULT '10'
|
send downcount
|
next_try
|
NUMERIC(17) NOT NULL
|
next retry time
|
method
|
INTEGER NOT NULL
|
send method (0—email, 1—windows message, 2—web console, 3—SNMP protocol , 4—Agent protocol)
|
address
|
VARCHAR(4000) DEFAULT ''
|
method specific recipient
|
error
|
CLOB DEFAULT ''
|
error due to which the message was not sent
|
sender
|
VARCHAR(36) DEFAULT ''
|
ID of the Server that sent the message
|
Table indexes
Index name
|
Index type
|
Fields list
|
alert_unsent_0001
|
simple table index
|
next_try
|
alert_unsent_0002
|
simple table index
|
id_binding
|
alert_unsent_pkey
|
table primary key
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
admin
|
→
|
admins.id
|
id_alert
|
→
|
alert_list.id_alert
|
id_binding
|
←
|
alert_unsent_bindings.id
|
alert_unsent_bindings
Values of variables in unsent administrator notifications.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
bindings UUID
|
name
|
VARCHAR(45) NOT NULL
|
variable name
|
value
|
CLOB DEFAULT ''
|
variable value
|
Table indexes
Index name
|
Index type
|
Fields list
|
alert_unsent_bindings_pkey
|
table primary key
clustering index
|
id, name
|
alert_variables
The lists of available variables in administrator notifications.
Table fields
Field name
|
Field type
|
Description
|
id_alert
|
INTEGER NOT NULL
|
notification ID
|
var_name
|
VARCHAR(45) NOT NULL
|
variable name
|
Table indexes
Index name
|
Index type
|
Fields list
|
alert_variables_pkey
|
table primary key
clustering index
|
id_alert, var_name
|
|