Difference between revisions of "Public.events (table)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.events |- |} {| border="1" cellpadding="5" cellspacing="0" style="bor...) |
|||
| Line 20: | Line 20: | ||
|- | |- | ||
| eventid | | eventid | ||
| − | | | + | | integer |
| not null | | not null | ||
| | | | ||
| Line 27: | Line 27: | ||
|- | |- | ||
| eventuei | | eventuei | ||
| − | | | + | | varchar(256) |
| not null | | not null | ||
| | | | ||
| Line 34: | Line 34: | ||
|- | |- | ||
| nodeid | | nodeid | ||
| − | | | + | | integer |
| null | | null | ||
| | | | ||
| Line 41: | Line 41: | ||
|- | |- | ||
| eventtime | | eventtime | ||
| − | | | + | | timestamp with time zone |
| not null | | not null | ||
| | | | ||
| Line 48: | Line 48: | ||
|- | |- | ||
| eventhost | | eventhost | ||
| − | | | + | | varchar(256) |
| null | | null | ||
| | | | ||
| Line 55: | Line 55: | ||
|- | |- | ||
| eventsource | | eventsource | ||
| − | | | + | | varchar(128) |
| not null | | not null | ||
| | | | ||
| Line 62: | Line 62: | ||
|- | |- | ||
| ipaddr | | ipaddr | ||
| − | | | + | | varchar(16) |
| null | | null | ||
| | | | ||
| Line 69: | Line 69: | ||
|- | |- | ||
| eventdpname | | eventdpname | ||
| − | | | + | | varchar(12) |
| not null | | not null | ||
| | | | ||
| Line 76: | Line 76: | ||
|- | |- | ||
| eventsnmphost | | eventsnmphost | ||
| − | | | + | | varchar(256) |
| null | | null | ||
| | | | ||
| Line 83: | Line 83: | ||
|- | |- | ||
| serviceid | | serviceid | ||
| − | | | + | | integer |
| null | | null | ||
| | | | ||
| Line 90: | Line 90: | ||
|- | |- | ||
| eventsnmp | | eventsnmp | ||
| − | | | + | | varchar(256) |
| null | | null | ||
| | | | ||
| Line 97: | Line 97: | ||
|- | |- | ||
| eventparms | | eventparms | ||
| − | | | + | | text |
| null | | null | ||
| | | | ||
| Line 104: | Line 104: | ||
|- | |- | ||
| eventcreatetime | | eventcreatetime | ||
| − | | | + | | timestamp with time zone |
| not null | | not null | ||
| | | | ||
| Line 111: | Line 111: | ||
|- | |- | ||
| eventdescr | | eventdescr | ||
| − | | | + | | varchar(4000) |
| null | | null | ||
| | | | ||
| Line 118: | Line 118: | ||
|- | |- | ||
| eventloggroup | | eventloggroup | ||
| − | | | + | | varchar(32) |
| null | | null | ||
| | | | ||
| Line 125: | Line 125: | ||
|- | |- | ||
| eventlogmsg | | eventlogmsg | ||
| − | | | + | | varchar(256) |
| null | | null | ||
| | | | ||
| Line 132: | Line 132: | ||
|- | |- | ||
| eventseverity | | eventseverity | ||
| − | | | + | | integer |
| not null | | not null | ||
| | | | ||
| Line 139: | Line 139: | ||
|- | |- | ||
| eventpathoutage | | eventpathoutage | ||
| − | | | + | | varchar(1024) |
| null | | null | ||
| | | | ||
| Line 146: | Line 146: | ||
|- | |- | ||
| eventcorrelation | | eventcorrelation | ||
| − | | | + | | varchar(1024) |
| null | | null | ||
| | | | ||
| Line 153: | Line 153: | ||
|- | |- | ||
| eventsuppressedcount | | eventsuppressedcount | ||
| − | | | + | | integer |
| null | | null | ||
| | | | ||
| Line 160: | Line 160: | ||
|- | |- | ||
| eventoperinstruct | | eventoperinstruct | ||
| − | | | + | | varchar(1024) |
| null | | null | ||
| | | | ||
| Line 167: | Line 167: | ||
|- | |- | ||
| eventautoaction | | eventautoaction | ||
| − | | | + | | varchar(256) |
| null | | null | ||
| | | | ||
| Line 174: | Line 174: | ||
|- | |- | ||
| eventoperaction | | eventoperaction | ||
| − | | | + | | varchar(256) |
| null | | null | ||
| | | | ||
| Line 181: | Line 181: | ||
|- | |- | ||
| eventoperactionmenutext | | eventoperactionmenutext | ||
| − | | | + | | varchar(64) |
| null | | null | ||
| | | | ||
| Line 188: | Line 188: | ||
|- | |- | ||
| eventnotification | | eventnotification | ||
| − | | | + | | varchar(128) |
| null | | null | ||
| | | | ||
| Line 195: | Line 195: | ||
|- | |- | ||
| eventtticket | | eventtticket | ||
| − | | | + | | varchar(128) |
| null | | null | ||
| | | | ||
| Line 202: | Line 202: | ||
|- | |- | ||
| eventtticketstate | | eventtticketstate | ||
| − | | | + | | integer |
| null | | null | ||
| | | | ||
| Line 209: | Line 209: | ||
|- | |- | ||
| eventforward | | eventforward | ||
| − | | | + | | varchar(256) |
| null | | null | ||
| | | | ||
| Line 216: | Line 216: | ||
|- | |- | ||
| eventmouseovertext | | eventmouseovertext | ||
| − | | | + | | varchar(64) |
| null | | null | ||
| | | | ||
| Line 223: | Line 223: | ||
|- | |- | ||
| eventlog | | eventlog | ||
| − | | | + | | char(1) |
| not null | | not null | ||
| | | | ||
| Line 230: | Line 230: | ||
|- | |- | ||
| eventdisplay | | eventdisplay | ||
| − | | | + | | char(1) |
| not null | | not null | ||
| | | | ||
| Line 237: | Line 237: | ||
|- | |- | ||
| eventackuser | | eventackuser | ||
| − | | | + | | varchar(256) |
| null | | null | ||
| | | | ||
| Line 244: | Line 244: | ||
|- | |- | ||
| eventacktime | | eventacktime | ||
| − | | | + | | timestamp with time zone |
| null | | null | ||
| | | | ||
| Line 251: | Line 251: | ||
|- | |- | ||
| alarmid | | alarmid | ||
| − | | | + | | integer |
| null | | null | ||
| | | | ||
Revision as of 15:43, 7 August 2009
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 |
