Editing Public.events (table)
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
− | |- | + | |- |
| '''Table | | '''Table | ||
| public.events | | public.events | ||
+ | |- | ||
|} | |} | ||
− | + | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- style="background:silver" | |- style="background:silver" | ||
Line 14: | Line 15: | ||
| '''Nullable | | '''Nullable | ||
| '''Default | | '''Default | ||
− | | ''' | + | | '''PK |
− | + | | '''Index | |
− | |- | + | |
+ | |- | ||
| eventid | | eventid | ||
− | | | + | | |
| not null | | not null | ||
| | | | ||
+ | | pk_eventid | ||
| | | | ||
− | |- | + | |- |
| eventuei | | eventuei | ||
− | | | + | | |
| not null | | not null | ||
| | | | ||
| | | | ||
− | |- | + | | events_uei_idx |
+ | |- | ||
| nodeid | | nodeid | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | events_nodeid_idxevents_nodeid_display_ackuser |
+ | |- | ||
| eventtime | | eventtime | ||
− | | | + | | |
| not null | | not null | ||
| | | | ||
| | | | ||
− | |- | + | | events_time_idx |
+ | |- | ||
| eventhost | | eventhost | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventsource | | eventsource | ||
− | | | + | | |
| not null | | not null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| ipaddr | | ipaddr | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | events_ipaddr_idx |
+ | |- | ||
| eventdpname | | eventdpname | ||
− | | | + | | |
| not null | | not null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventsnmphost | | eventsnmphost | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| serviceid | | serviceid | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | events_serviceid_idx |
+ | |- | ||
| eventsnmp | | eventsnmp | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventparms | | eventparms | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventcreatetime | | eventcreatetime | ||
− | | | + | | |
| not null | | not null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventdescr | | eventdescr | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventloggroup | | eventloggroup | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventlogmsg | | eventlogmsg | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventseverity | | eventseverity | ||
− | | | + | | |
| not null | | not null | ||
| | | | ||
| | | | ||
− | |- | + | | events_severity_idx |
+ | |- | ||
| eventpathoutage | | eventpathoutage | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventcorrelation | | eventcorrelation | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventsuppressedcount | | eventsuppressedcount | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventoperinstruct | | eventoperinstruct | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventautoaction | | eventautoaction | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventoperaction | | eventoperaction | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventoperactionmenutext | | eventoperactionmenutext | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventnotification | | eventnotification | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventtticket | | eventtticket | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventtticketstate | | eventtticketstate | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventforward | | eventforward | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventmouseovertext | | eventmouseovertext | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| eventlog | | eventlog | ||
− | | | + | | |
| not null | | not null | ||
| | | | ||
| | | | ||
− | |- | + | | events_log_idx |
+ | |- | ||
| eventdisplay | | eventdisplay | ||
− | | | + | | |
| not null | | not null | ||
| | | | ||
| | | | ||
− | |- | + | | events_nodeid_display_ackuserevents_display_idx |
+ | |- | ||
| eventackuser | | eventackuser | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | events_nodeid_display_ackuserevents_ackuser_idx |
+ | |- | ||
| eventacktime | | eventacktime | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | events_acktime_idx |
+ | |- | ||
| alarmid | | alarmid | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
+ | | events_alarmid_idx | ||
|} | |} | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- style="background:silver" | |- style="background:silver" | ||
Line 295: | Line 265: | ||
| '''Column | | '''Column | ||
| '''Referencing Column | | '''Referencing Column | ||
− | + | ||
− | |- | + | |- |
| [[public.outages_(table)|public.outages]] | | [[public.outages_(table)|public.outages]] | ||
| eventid | | eventid | ||
| svclosteventid | | svclosteventid | ||
− | |- | + | |- |
| [[public.outages_(table)|public.outages]] | | [[public.outages_(table)|public.outages]] | ||
| eventid | | eventid | ||
| svcregainedeventid | | svcregainedeventid | ||
− | |- | + | |- |
| [[public.notifications_(table)|public.notifications]] | | [[public.notifications_(table)|public.notifications]] | ||
| eventid | | eventid | ||
| eventid | | eventid | ||
− | |- | + | |- |
| [[public.alarms_(table)|public.alarms]] | | [[public.alarms_(table)|public.alarms]] | ||
| eventid | | eventid | ||
| lasteventid | | lasteventid | ||
|} | |} |