Public.alarms (table)

wikibot

Table

public.alarms

Column	Data Type	Nullable	Default	PK	Index
alarmid		not null		pk_alarmid	alarm_reduction2_idx
eventuei		not null			alarm_reduction2_idxalarm_uei_idx
dpname		not null			alarm_reduction2_idx
nodeid		null			alarm_nodeid_idxalarm_reduction2_idx
ipaddr		null
serviceid		null			alarm_reduction2_idx
reductionkey		null			alarm_reductionkey_idxalarm_reduction2_idx
alarmtype		null
counter		not null
severity		not null
lasteventid		null			alarm_eventid_idx
firsteventtime		null
lasteventtime		null
firstautomationtime		null
lastautomationtime		null
description		null
logmsg		null
operinstruct		null
tticketid		null
tticketstate		null
mouseovertext		null
suppresseduntil		null
suppresseduser		null
suppressedtime		null
alarmackuser		null
alarmacktime		null
clearuei		null
managedobjectinstance		null
managedobjecttype		null
applicationdn		null			alarm_app_dn
ossprimarykey		null			alarm_oss_primary_key
x733alarmtype		null
x733probablecause		not null	0
qosalarmstate		null
clearkey		null			alarm_clearkey_idx

Relation	Column	Referenced Column
public.events	lasteventid	eventid

Detail Table	Column	Referencing Column
public.alarm_attributes	alarmid	alarmid