From dbscript Online Help
wikibot
| 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
|