Public.alarms (table)

wikibot

Table

public.alarms

Column	Data Type	Nullable	Default	PK	Index
alarmid	integer	not null		pk_alarmid	alarm_reduction2_idx
eventuei	varchar(256)	not null			alarm_reduction2_idxalarm_uei_idx
dpname	varchar(12)	not null			alarm_reduction2_idx
nodeid	integer	null			alarm_nodeid_idxalarm_reduction2_idx
ipaddr	varchar(16)	null
serviceid	integer	null			alarm_reduction2_idx
reductionkey	varchar(256)	null			alarm_reductionkey_idxalarm_reduction2_idx
alarmtype	integer	null
counter	integer	not null
severity	integer	not null
lasteventid	integer	null			alarm_eventid_idx
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			alarm_app_dn
ossprimarykey	varchar(512)	null			alarm_oss_primary_key
x733alarmtype	varchar(31)	null
x733probablecause	integer	not null	0
qosalarmstate	varchar(31)	null
clearkey	varchar(256)	null			alarm_clearkey_idx

Relation	Column	Referenced Column
public.events	lasteventid	eventid

Detail Table	Column	Referencing Column
public.alarm_attributes	alarmid	alarmid