See www.zabbix.com for the official Zabbix site.

Docs/DB schema/3.4/media

From Zabbix.org
Jump to: navigation, search

This table contains [please add a brief table description].

Columns

Column Detail Default NULL? Type Ref from Ref to
mediaid NONE NOT NULL id
userid NONE NOT NULL id users.userid C
mediatypeid NONE NOT NULL id media_type.mediatypeid C
sendto EMPTY NOT NULL varchar(100)
active
  • 0 - MEDIA_TYPE_STATUS_ACTIVE
  • 1 - MEDIA_TYPE_STATUS_DISABLED
0 NOT NULL integer
severity Decimal value of a severity bitmask

The lowest severity is the least significant bit. The default of 63 translates to "enabled for all severities".

63 NOT NULL integer
period String representation of the activity period 1-7,00:00-24:00 NOT NULL varchar(1024)

Indexes

Name UNIQ Columns
PRIMARY KEY YES mediaid
media_1 No userid
media_2 No mediatypeid