Public.alarms (table) - Revision history

Bot at 09:24, 27 August 2011

2011-08-27T09:24:31Z

Bot at 09:19, 27 August 2011

2011-08-27T09:19:07Z

Bot at 09:08, 27 August 2011

2011-08-27T09:08:58Z

Bot at 22:38, 24 June 2010

2010-06-24T22:38:21Z

Show changes

Bot at 07:31, 11 February 2010

2010-02-11T07:31:12Z

Show changes

Bot at 13:42, 7 August 2009

2009-08-07T13:42:41Z

Show changes

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.alarms |- |} {| border="1" cellpadding="5" cellspacing="0" style="bor...

2009-08-07T13:13:48Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.alarms |- |} {| border="1" cellpadding="5" cellspacing="0" style="bor...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| public.alarms
|-
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''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
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation
| '''Column
| '''Referenced Column

|-
| [[public.events_(table)|public.events]]
| lasteventid
| eventid
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table
| '''Column
| '''Referencing Column

|-
| [[public.alarm_attributes_(table)|public.alarm_attributes]]
| alarmid
| alarmid
|}

@@ Line 274: / Line 274: @@
 |- valign="top"
 | alarm_reductionkey_idx
-| Unique
 | reductionkey
 |- valign="top"

@@ Line 215: / Line 215: @@
 | integer
 | not null
-| 0
+|
 |- valign="top"
@@ Line 248: / Line 248: @@
 | '''Columns
 |- valign="top"
 | alarm_app_dn
@@ Line 276: / Line 272: @@
+|
 | alarmid, eventuei, dpname, nodeid, serviceid, reductionkey
 |- valign="top"
 | alarm_uei_idx
@@ Line 293: / Line 293: @@
 | lasteventid
 | eventid
 |- valign="top"
-| [[public.alarm_attributes_(table)|public.alarm_attributes]]
+| [[public.alarms_(table)|public.alarms]]
 | alarmid
 | alarmid
 |}