Public.alarms (table)

wikibot

Table	public.alarms
Description	alaaaaaaarm

Columns

Column	Data Type	Nullable	Default	Description
alarmid	integer	not null
eventuei	varchar(256)	not null
dpname	varchar(12)	not null
nodeid	integer	null
ipaddr	varchar(16)	null
serviceid	integer	null
reductionkey	varchar(256)	null
alarmtype	integer	null
counter	integer	not null
severity	integer	not null
lasteventid	integer	null
firsteventtime	timestamp with time zone	null
lasteventtime	timestamp with time zone	null
firstautomationtime	timestamp with time zone	null
lastautomationtime	timestamp with time zone	null
description	varchar(4000)	null
logmsg	varchar(256)	null
operinstruct	varchar(1024)	null
tticketid	varchar(128)	null
tticketstate	integer	null
mouseovertext	varchar(64)	null
suppresseduntil	timestamp with time zone	null
suppresseduser	varchar(256)	null
suppressedtime	timestamp with time zone	null
alarmackuser	varchar(256)	null
alarmacktime	timestamp with time zone	null
clearuei	varchar(256)	null
managedobjectinstance	varchar(512)	null
managedobjecttype	varchar(512)	null
applicationdn	varchar(512)	null
ossprimarykey	varchar(512)	null
x733alarmtype	varchar(31)	null
x733probablecause	integer	not null
qosalarmstate	varchar(31)	null
clearkey	varchar(256)	null

Primary Key

Primary Key	Columns
pk_alarmid	alarmid

Indexes

Index	Type	Columns
alarm_app_dn		applicationdn
alarm_clearkey_idx		clearkey
alarm_eventid_idx		lasteventid
alarm_nodeid_idx		nodeid
alarm_oss_primary_key		ossprimarykey
alarm_reduction2_idx		alarmid, eventuei, dpname, nodeid, serviceid, reductionkey
alarm_reductionkey_idx	Unique	reductionkey
alarm_uei_idx		eventuei

Foreign Keys

Relation	Column	Referenced Column
public.events	lasteventid	eventid
public.alarms	alarmid	alarmid