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

Docs/DB schema/4.0/users

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
userid NONE NOT NULL id acknowledges.userid C
alerts.userid C
auditlog.userid C
dashboard.userid
dashboard_user.userid C
event_recovery.userid
media.userid C
opmessage_usr.userid
problem.userid
profiles.userid C
screen_user.userid C
screens.userid
sessions.userid C
slideshow_user.userid C
slideshows.userid
sysmap_user.userid C
sysmaps.userid
users_groups.userid C
alias EMPTY NOT NULL varchar(100)
name EMPTY NOT NULL varchar(100)
surname EMPTY NOT NULL varchar(100)
passwd EMPTY NOT NULL varchar(32)
url EMPTY NOT NULL varchar(255)
autologin 0 NOT NULL integer
autologout 15m NOT NULL varchar(32)
lang en_GB NOT NULL varchar(5)
refresh 30s NOT NULL varchar(32)
type 1 NOT NULL integer
theme default NOT NULL varchar(128)
attempt_failed 0 NOT NULL integer
attempt_ip EMPTY NOT NULL varchar(39)
attempt_clock 0 NOT NULL integer
rows_per_page 50 NOT NULL integer

Indexes

Name UNIQ Columns
PRIMARY KEY YES userid
users_1 YES alias