Public.events (table)

wikibot

Table

public.events

Column	Data Type	Nullable	Default	PK	Index
eventid		not null		pk_eventid
eventuei		not null			events_uei_idx
nodeid		null			events_nodeid_idxevents_nodeid_display_ackuser
eventtime		not null			events_time_idx
eventhost		null
eventsource		not null
ipaddr		null			events_ipaddr_idx
eventdpname		not null
eventsnmphost		null
serviceid		null			events_serviceid_idx
eventsnmp		null
eventparms		null
eventcreatetime		not null
eventdescr		null
eventloggroup		null
eventlogmsg		null
eventseverity		not null			events_severity_idx
eventpathoutage		null
eventcorrelation		null
eventsuppressedcount		null
eventoperinstruct		null
eventautoaction		null
eventoperaction		null
eventoperactionmenutext		null
eventnotification		null
eventtticket		null
eventtticketstate		null
eventforward		null
eventmouseovertext		null
eventlog		not null			events_log_idx
eventdisplay		not null			events_nodeid_display_ackuserevents_display_idx
eventackuser		null			events_nodeid_display_ackuserevents_ackuser_idx
eventacktime		null			events_acktime_idx
alarmid		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