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

From dbscript Online Help
Jump to: navigation, search
Line 9: Line 9:
  
  
 +
=== 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 16:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
 
 
 
 
|-
 
|-
Line 23: Line 23:
 
| not null
 
| not null
 
|  
 
|  
−
| pk_eventid
 
 
|  
 
|  
 
|-
 
|-
Line 31: Line 30:
 
|  
 
|  
 
|  
 
|  
−
| events_uei_idx
 
 
|-
 
|-
 
| nodeid
 
| nodeid
Line 38: Line 36:
 
|  
 
|  
 
|  
 
|  
−
| events_nodeid_idxevents_nodeid_display_ackuser
 
 
|-
 
|-
 
| eventtime
 
| eventtime
Line 45: Line 42:
 
|  
 
|  
 
|  
 
|  
−
| events_time_idx
 
 
|-
 
|-
 
| eventhost
 
| eventhost
 
| varchar(256)
 
| varchar(256)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 57: Line 52:
 
| varchar(128)
 
| varchar(128)
 
| not null
 
| not null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 66: Line 60:
 
|  
 
|  
 
|  
 
|  
−
| events_ipaddr_idx
 
 
|-
 
|-
 
| eventdpname
 
| eventdpname
 
| varchar(12)
 
| varchar(12)
 
| not null
 
| not null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 78: Line 70:
 
| varchar(256)
 
| varchar(256)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 87: Line 78:
 
|  
 
|  
 
|  
 
|  
−
| events_serviceid_idx
 
 
|-
 
|-
 
| eventsnmp
 
| eventsnmp
 
| varchar(256)
 
| varchar(256)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 99: Line 88:
 
| text
 
| text
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 106: Line 94:
 
| timestamp with time zone
 
| timestamp with time zone
 
| not null
 
| not null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 113: Line 100:
 
| varchar(4000)
 
| varchar(4000)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 120: Line 106:
 
| varchar(32)
 
| varchar(32)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 127: Line 112:
 
| varchar(256)
 
| varchar(256)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 136: Line 120:
 
|  
 
|  
 
|  
 
|  
−
| events_severity_idx
 
 
|-
 
|-
 
| eventpathoutage
 
| eventpathoutage
 
| varchar(1024)
 
| varchar(1024)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 148: Line 130:
 
| varchar(1024)
 
| varchar(1024)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 155: Line 136:
 
| integer
 
| integer
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 162: Line 142:
 
| varchar(1024)
 
| varchar(1024)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 169: Line 148:
 
| varchar(256)
 
| varchar(256)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 176: Line 154:
 
| varchar(256)
 
| varchar(256)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 183: Line 160:
 
| varchar(64)
 
| varchar(64)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 190: Line 166:
 
| varchar(128)
 
| varchar(128)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 197: Line 172:
 
| varchar(128)
 
| varchar(128)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 204: Line 178:
 
| integer
 
| integer
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 211: Line 184:
 
| varchar(256)
 
| varchar(256)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 218: Line 190:
 
| varchar(64)
 
| varchar(64)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 227: Line 198:
 
|  
 
|  
 
|  
 
|  
−
| events_log_idx
 
 
|-
 
|-
 
| eventdisplay
 
| eventdisplay
Line 234: Line 204:
 
|  
 
|  
 
|  
 
|  
−
| events_nodeid_display_ackuserevents_display_idx
 
 
|-
 
|-
 
| eventackuser
 
| eventackuser
Line 241: Line 210:
 
|  
 
|  
 
|  
 
|  
−
| events_nodeid_display_ackuserevents_ackuser_idx
 
 
|-
 
|-
 
| eventacktime
 
| eventacktime
Line 248: Line 216:
 
|  
 
|  
 
|  
 
|  
−
| events_acktime_idx
 
 
|-
 
|-
 
| alarmid
 
| alarmid
Line 255: Line 222:
 
|  
 
|  
 
|  
 
|  
−
| events_alarmid_idx
 
 
|}
 
|}
  
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|-
 +
| pk_eventid
 +
| eventid
 +
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|-
 +
| events_time_idx
 +
|
 +
| eventtime
 +
|-
 +
| events_uei_idx
 +
|
 +
| eventuei
 +
|-
 +
| events_serviceid_idx
 +
|
 +
| serviceid
 +
|-
 +
| events_nodeid_idx
 +
|
 +
| nodeid
 +
|-
 +
| events_nodeid_display_ackuser
 +
|
 +
| nodeid, eventdisplay, eventackuser
 +
|-
 +
| events_log_idx
 +
|
 +
| eventlog
 +
|-
 +
| events_ipaddr_idx
 +
|
 +
| ipaddr
 +
|-
 +
| events_display_idx
 +
|
 +
| eventdisplay
 +
|-
 +
| events_alarmid_idx
 +
|
 +
| alarmid
 +
|-
 +
| events_ackuser_idx
 +
|
 +
| eventackuser
 +
|-
 +
| events_acktime_idx
 +
|
 +
| eventacktime
 +
|-
 +
| events_severity_idx
 +
|
 +
| eventseverity
 +
|}
  
 +
=== 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"

Revision as of 08:31, 11 February 2010

wikibot

Table public.events


Columns

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

Primary Key Columns
pk_eventid eventid

Indexes

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

Detail Tables

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=2349"