Public.events (table) - Revision history

Bot at 09:24, 27 August 2011

2011-08-27T09:24:49Z

Bot at 09:09, 27 August 2011

2011-08-27T09:09:16Z

Bot at 22:38, 24 June 2010

2010-06-24T22:38:42Z

Show changes

Bot at 07:31, 11 February 2010

2010-02-11T07:31:35Z

Show changes

Bot at 13:43, 7 August 2009

2009-08-07T13:43:03Z

Show changes

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

2009-08-07T13:14:05Z

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

New page

== wikibot ==

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

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''PK
| '''Index

|-
| eventid
|
| not null
|
| pk_eventid
|
|-
| eventuei
|
| not null
|
|
| events_uei_idx
|-
| nodeid
|
| null
|
|
| events_nodeid_idxevents_nodeid_display_ackuser
|-
| eventtime
|
| not null
|
|
| events_time_idx
|-
| eventhost
|
| null
|
|
|
|-
| eventsource
|
| not null
|
|
|
|-
| ipaddr
|
| null
|
|
| events_ipaddr_idx
|-
| eventdpname
|
| not null
|
|
|
|-
| eventsnmphost
|
| null
|
|
|
|-
| serviceid
|
| null
|
|
| events_serviceid_idx
|-
| eventsnmp
|
| null
|
|
|
|-
| eventparms
|
| null
|
|
|
|-
| eventcreatetime
|
| not null
|
|
|
|-
| eventdescr
|
| null
|
|
|
|-
| eventloggroup
|
| null
|
|
|
|-
| eventlogmsg
|
| null
|
|
|
|-
| eventseverity
|
| not null
|
|
| events_severity_idx
|-
| eventpathoutage
|
| null
|
|
|
|-
| eventcorrelation
|
| null
|
|
|
|-
| eventsuppressedcount
|
| null
|
|
|
|-
| eventoperinstruct
|
| null
|
|
|
|-
| eventautoaction
|
| null
|
|
|
|-
| eventoperaction
|
| null
|
|
|
|-
| eventoperactionmenutext
|
| null
|
|
|
|-
| eventnotification
|
| null
|
|
|
|-
| eventtticket
|
| null
|
|
|
|-
| eventtticketstate
|
| null
|
|
|
|-
| eventforward
|
| null
|
|
|
|-
| eventmouseovertext
|
| null
|
|
|
|-
| eventlog
|
| not null
|
|
| events_log_idx
|-
| eventdisplay
|
| not null
|
|
| events_nodeid_display_ackuserevents_display_idx
|-
| eventackuser
|
| null
|
|
| events_nodeid_display_ackuserevents_ackuser_idx
|-
| eventacktime
|
| null
|
|
| events_acktime_idx
|-
| alarmid
|
| null
|
|
| events_alarmid_idx
|}

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

|-
| [[public.outages_(table)|public.outages]]
| eventid
| svclosteventid
|-
| [[public.outages_(table)|public.outages]]
| eventid
| svcregainedeventid
|-
| [[public.notifications_(table)|public.notifications]]
| eventid
| eventid
|-
| [[public.alarms_(table)|public.alarms]]
| eventid
| lasteventid
|}

@@ Line 289: / Line 289: @@
 |}
-=== Foreign Keys ===
+=== Detail Tables ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
-| '''Relation
+| '''Detail Table
 | '''Column
-| '''Referenced Column
+| '''Referencing Column
 |- valign="top"
-| [[public.events_(table)|public.events]]
+| [[public.outages_(table)|public.outages]]
 | svclosteventid
 | eventid
 | svcregainedeventid
 |- valign="top"
-| [[public.events_(table)|public.events]]
+| [[public.notifications_(table)|public.notifications]]
 | eventid
 | eventid
 |- valign="top"
-| [[public.events_(table)|public.events]]
+| [[public.alarms_(table)|public.alarms]]
 | lasteventid
 |}

@@ Line 240: / Line 240: @@
 |- valign="top"
-| events_time_idx
+| events_acktime_idx
+|
-| eventtime
+| eventacktime
 |- valign="top"
-| events_uei_idx
+| events_ackuser_idx
+|
-| eventuei
+| eventackuser
 |- valign="top"
-| events_serviceid_idx
+| events_alarmid_idx
+|
-| serviceid
+| alarmid
 |- valign="top"
-| events_nodeid_idx
+| events_display_idx
+|
-| nodeid
+| eventdisplay
 |- valign="top"
-| events_nodeid_display_ackuser
+| events_ipaddr_idx
+|
-| nodeid, eventdisplay, eventackuser
+| ipaddr
 |- valign="top"
 | events_log_idx
@@ Line 264: / Line 264: @@
 | eventlog
 |- valign="top"
-| events_ipaddr_idx
+| events_nodeid_display_ackuser
+|
-| ipaddr
+| nodeid, eventdisplay, eventackuser
 |- valign="top"
-| events_display_idx
+| events_nodeid_idx
+|
-| eventdisplay
+| nodeid
 |- valign="top"
-| events_alarmid_idx
+| events_serviceid_idx
+|
-| alarmid
+| serviceid
 |- valign="top"
-| events_ackuser_idx
+| events_severity_idx
+|
-| eventackuser
+| eventseverity
 |- valign="top"
-| events_acktime_idx
+| events_time_idx
+|
-| eventacktime
+| eventtime
 |- valign="top"
-| events_severity_idx
+| events_uei_idx
+|
-| eventseverity
+| eventuei
 |}
-=== Detail Tables ===
+=== Foreign Keys ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
-| '''Detail Table
+| '''Relation
 | '''Column
-| '''Referencing Column
+| '''Referenced Column
 |- valign="top"
-| [[public.outages_(table)|public.outages]]
+| [[public.events_(table)|public.events]]
 | eventid
 |- valign="top"
-| [[public.outages_(table)|public.outages]]
+| [[public.events_(table)|public.events]]
 | eventid
 |- valign="top"
-| [[public.notifications_(table)|public.notifications]]
+| [[public.events_(table)|public.events]]
 | eventid
 | eventid
 |- valign="top"
-| [[public.alarms_(table)|public.alarms]]
+| [[public.events_(table)|public.events]]
 | eventid
 |}