Difference between revisions of "Public.alarms (table)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.alarms |- |} {| border="1" cellpadding="5" cellspacing="0" style="bor...) |
(No difference)
|
Revision as of 15:13, 7 August 2009
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 |