Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

Tablepublic.events

Columns

ColumnData TypeNullableDefaultDescription
eventidintegernot null  
eventueivarchar(256)not null  
nodeidintegernull  
eventtimetimestamp with time zonenot null  
eventhostvarchar(256)null  
eventsourcevarchar(128)not null  
ipaddrvarchar(16)null  
eventdpnamevarchar(12)not null  
eventsnmphostvarchar(256)null  
serviceidintegernull  
eventsnmpvarchar(256)null  
eventparmstextnull  
eventcreatetimetimestamp with time zonenot null  
eventdescrvarchar(4000)null  
eventloggroupvarchar(32)null  
eventlogmsgvarchar(256)null  
eventseverityintegernot null  
eventpathoutagevarchar(1024)null  
eventcorrelationvarchar(1024)null  
eventsuppressedcountintegernull  
eventoperinstructvarchar(1024)null  
eventautoactionvarchar(256)null  
eventoperactionvarchar(256)null  
eventoperactionmenutextvarchar(64)null  
eventnotificationvarchar(128)null  
eventtticketvarchar(128)null  
eventtticketstateintegernull  
eventforwardvarchar(256)null  
eventmouseovertextvarchar(64)null  
eventlogchar(1)not null  
eventdisplaychar(1)not null  
eventackuservarchar(256)null  
eventacktimetimestamp with time zonenull  
alarmidintegernull  

Primary Key

Primary KeyColumns
pk_eventideventid

Indexes

IndexTypeColumns
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

Detail TableColumnReferencing Column
public.outageseventidsvclosteventid
public.outageseventidsvcregainedeventid
public.notificationseventideventid
public.alarmseventidlasteventid

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.