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

Docs/DB schema/3.4/profiles

From Zabbix.org
Jump to: navigation, search

This table contains user profile settings - one per record. Profile settings can be anything, like the sort order on a certain page, filter settings or dashboard favourites.

Columns

Column Detail Default NULL? Type Ref from Ref to
profileid Profile entry ID. Managed by Zabbix via the ids table. NONE NOT NULL id
userid The ID of the user which owns this profile entry. NONE NOT NULL id users.userid C
idx Profile identifier (an arbitrary value). EMPTY NOT NULL varchar(96)
idx2 The ID of the target entity unless the value_* fields are used. 0 NOT NULL id
value_id The ID of the target entity when type = PROFILE_TYPE_ID. 0 NOT NULL id
value_int The value of the target entity when type = PROFILE_TYPE_INT. 0 NOT NULL integer
value_str The value of the target entity when type = PROFILE_TYPE_STR. EMPTY NOT NULL varchar(255)
source Name of the column from which the entity ID comes from. EMPTY NOT NULL varchar(96)
type Datatype of the stored setting (i. e. which column holds the value)
  • 1 - PROFILE_TYPE_ID
  • 2 - PROFILE_TYPE_INT
  • 3 - PROFILE_TYPE_STR
0 NOT NULL integer

Indexes

Name UNIQ Columns
PRIMARY KEY YES profileid
profiles_1 No userid, idx, idx2
profiles_2 No userid, profileid