Difference between revisions of "Public.events (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.events |- |} {| border="1" cellpadding="5" cellspacing="0" style="bor...)
 
 
(4 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| public.events
 
| public.events
−
|-
 
 
|}
 
|}
  
−
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 14:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| eventid
 
| eventid
−
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
−
| pk_eventid
 
 
|  
 
|  
−
|-
+
|- valign="top"
 
| eventuei
 
| eventuei
−
|  
+
| varchar(256)
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
−
| events_uei_idx
+
|- valign="top"
−
|-
 
 
| nodeid
 
| nodeid
−
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
| events_nodeid_idxevents_nodeid_display_ackuser
+
|- valign="top"
−
|-
 
 
| eventtime
 
| eventtime
−
|  
+
| timestamp with time zone
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
−
| events_time_idx
+
|- valign="top"
−
|-
 
 
| eventhost
 
| eventhost
−
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventsource
 
| eventsource
−
|  
+
| varchar(128)
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| ipaddr
 
| ipaddr
−
|  
+
| varchar(16)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
| events_ipaddr_idx
+
|- valign="top"
−
|-
 
 
| eventdpname
 
| eventdpname
−
|  
+
| varchar(12)
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventsnmphost
 
| eventsnmphost
−
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| serviceid
 
| serviceid
−
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
| events_serviceid_idx
+
|- valign="top"
−
|-
 
 
| eventsnmp
 
| eventsnmp
−
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventparms
 
| eventparms
−
|  
+
| text
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventcreatetime
 
| eventcreatetime
−
|  
+
| timestamp with time zone
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventdescr
 
| eventdescr
−
|  
+
| varchar(4000)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventloggroup
 
| eventloggroup
−
|  
+
| varchar(32)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventlogmsg
 
| eventlogmsg
−
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventseverity
 
| eventseverity
−
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
−
| events_severity_idx
+
|- valign="top"
−
|-
 
 
| eventpathoutage
 
| eventpathoutage
−
|  
+
| varchar(1024)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventcorrelation
 
| eventcorrelation
−
|  
+
| varchar(1024)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventsuppressedcount
 
| eventsuppressedcount
−
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventoperinstruct
 
| eventoperinstruct
−
|  
+
| varchar(1024)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventautoaction
 
| eventautoaction
−
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventoperaction
 
| eventoperaction
−
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventoperactionmenutext
 
| eventoperactionmenutext
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventnotification
 
| eventnotification
−
|  
+
| varchar(128)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventtticket
 
| eventtticket
−
|  
+
| varchar(128)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventtticketstate
 
| eventtticketstate
−
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventforward
 
| eventforward
−
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventmouseovertext
 
| eventmouseovertext
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| eventlog
 
| eventlog
−
|  
+
| char(1)
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
−
| events_log_idx
+
|- valign="top"
−
|-
 
 
| eventdisplay
 
| eventdisplay
−
|  
+
| char(1)
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
−
| events_nodeid_display_ackuserevents_display_idx
+
|- valign="top"
−
|-
 
 
| eventackuser
 
| eventackuser
−
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
| events_nodeid_display_ackuserevents_ackuser_idx
+
|- valign="top"
−
|-
 
 
| eventacktime
 
| eventacktime
 +
| timestamp with time zone
 +
| null
 
|  
 
|  
 +
|
 +
|- valign="top"
 +
| alarmid
 +
| integer
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
 +
|}
 +
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| pk_eventid
 +
| eventid
 +
|}
 +
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|- valign="top"
 
| events_acktime_idx
 
| events_acktime_idx
−
|-
+
|
 +
| eventacktime
 +
|- valign="top"
 +
| events_ackuser_idx
 +
|
 +
| eventackuser
 +
|- valign="top"
 +
| events_alarmid_idx
 +
|
 
| alarmid
 
| alarmid
 +
|- valign="top"
 +
| events_display_idx
 +
|
 +
| eventdisplay
 +
|- valign="top"
 +
| events_ipaddr_idx
 +
|
 +
| ipaddr
 +
|- valign="top"
 +
| events_log_idx
 +
|
 +
| eventlog
 +
|- valign="top"
 +
| events_nodeid_display_ackuser
 
|  
 
|  
−
| null
+
| nodeid, eventdisplay, eventackuser
 +
|- valign="top"
 +
| events_nodeid_idx
 +
|
 +
| nodeid
 +
|- valign="top"
 +
| events_serviceid_idx
 +
|
 +
| serviceid
 +
|- valign="top"
 +
| events_severity_idx
 
|  
 
|  
 +
| eventseverity
 +
|- valign="top"
 +
| events_time_idx
 
|  
 
|  
−
| events_alarmid_idx
+
| eventtime
 +
|- valign="top"
 +
| events_uei_idx
 +
|
 +
| eventuei
 
|}
 
|}
  
−
 
+
=== Detail Tables ===
−
 
 
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 265: Line 295:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[public.outages_(table)|public.outages]]
 
| [[public.outages_(table)|public.outages]]
 
| eventid
 
| eventid
 
| svclosteventid
 
| svclosteventid
−
|-
+
|- valign="top"
 
| [[public.outages_(table)|public.outages]]
 
| [[public.outages_(table)|public.outages]]
 
| eventid
 
| eventid
 
| svcregainedeventid
 
| svcregainedeventid
−
|-
+
|- valign="top"
 
| [[public.notifications_(table)|public.notifications]]
 
| [[public.notifications_(table)|public.notifications]]
 
| eventid
 
| eventid
 
| eventid
 
| eventid
−
|-
+
|- valign="top"
 
| [[public.alarms_(table)|public.alarms]]
 
| [[public.alarms_(table)|public.alarms]]
 
| eventid
 
| eventid
 
| lasteventid
 
| lasteventid
 
|}
 
|}

Latest revision as of 10:24, 27 August 2011

wikibot[edit]

Table public.events

Columns[edit]

Column Data Type Nullable Default Description
eventid integer not null
eventuei varchar(256) not null
nodeid integer null
eventtime timestamp with time zone not null
eventhost varchar(256) null
eventsource varchar(128) not null
ipaddr varchar(16) null
eventdpname varchar(12) not null
eventsnmphost varchar(256) null
serviceid integer null
eventsnmp varchar(256) null
eventparms text null
eventcreatetime timestamp with time zone not null
eventdescr varchar(4000) null
eventloggroup varchar(32) null
eventlogmsg varchar(256) null
eventseverity integer not null
eventpathoutage varchar(1024) null
eventcorrelation varchar(1024) null
eventsuppressedcount integer null
eventoperinstruct varchar(1024) null
eventautoaction varchar(256) null
eventoperaction varchar(256) null
eventoperactionmenutext varchar(64) null
eventnotification varchar(128) null
eventtticket varchar(128) null
eventtticketstate integer null
eventforward varchar(256) null
eventmouseovertext varchar(64) null
eventlog char(1) not null
eventdisplay char(1) not null
eventackuser varchar(256) null
eventacktime timestamp with time zone null
alarmid integer null

Primary Key[edit]

Primary Key Columns
pk_eventid eventid

Indexes[edit]

Index Type Columns
events_acktime_idx eventacktime
events_ackuser_idx eventackuser
events_alarmid_idx alarmid
events_display_idx eventdisplay
events_ipaddr_idx ipaddr
events_log_idx eventlog
events_nodeid_display_ackuser nodeid, eventdisplay, eventackuser
events_nodeid_idx nodeid
events_serviceid_idx serviceid
events_severity_idx eventseverity
events_time_idx eventtime
events_uei_idx eventuei

Detail Tables[edit]

Detail Table Column Referencing Column
public.outages eventid svclosteventid
public.outages eventid svcregainedeventid
public.notifications eventid eventid
public.alarms eventid lasteventid
Retrieved from "http://dbshelp.devio.at/index.php?title=Public.events_(table)&oldid=3029"