ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
public.alarms_(table)
Print
RSS
Modified: 2011/08/27 10:40 by
wikibot
-
Uncategorized
»
Database Objects OpenNMS
»
public.alarms_(table)
[X]
»
Database Objects OpenNMS
»
public.alarms_(table)
Table
public.alarms
Description
alaaaaaaarm
Edit
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
Edit
Primary Key
Primary Key
Columns
pk_alarmid
alarmid
Edit
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
reductionkey
alarm_uei_idx
eventuei
Edit
Foreign Keys
Relation
Column
Referenced Column
public.events
lasteventid
eventid
Edit
Detail Tables
Detail Table
Column
Referencing Column
public.alarm_attributes
alarmid
alarmid
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.