Public.events (table)

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