Public.events (table)

From dbscript Online Help
Revision as of 15:43, 7 August 2009 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

Table public.events


Column Data Type Nullable Default PK Index
eventid integer not null pk_eventid
eventuei varchar(256) not null events_uei_idx
nodeid integer null events_nodeid_idxevents_nodeid_display_ackuser
eventtime timestamp with time zone not null events_time_idx
eventhost varchar(256) null
eventsource varchar(128) not null
ipaddr varchar(16) null events_ipaddr_idx
eventdpname varchar(12) not null
eventsnmphost varchar(256) null
serviceid integer null events_serviceid_idx
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 events_severity_idx
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 events_log_idx
eventdisplay char(1) not null events_nodeid_display_ackuserevents_display_idx
eventackuser varchar(256) null events_nodeid_display_ackuserevents_ackuser_idx
eventacktime timestamp with time zone null events_acktime_idx
alarmid integer null events_alarmid_idx


Detail Table Column Referencing Column
public.outages eventid svclosteventid
public.outages eventid svcregainedeventid
public.notifications eventid eventid
public.alarms eventid lasteventid