Difference between revisions of "Public.alarms (table)"
| Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| − | |- | + | |- valign="top" |
| '''Table | | '''Table | ||
| public.alarms | | public.alarms | ||
| Line 8: | Line 8: | ||
| '''Description | | '''Description | ||
| alaaaaaaarm | | alaaaaaaarm | ||
| − | |||
|} | |} | ||
| − | |||
=== Columns === | === Columns === | ||
| Line 20: | Line 18: | ||
| '''Default | | '''Default | ||
| '''Description | | '''Description | ||
| − | + | ||
| − | |- | + | |- valign="top" |
| alarmid | | alarmid | ||
| integer | | integer | ||
| Line 27: | Line 25: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| eventuei | | eventuei | ||
| varchar(256) | | varchar(256) | ||
| Line 33: | Line 31: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| dpname | | dpname | ||
| varchar(12) | | varchar(12) | ||
| Line 39: | Line 37: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| nodeid | | nodeid | ||
| integer | | integer | ||
| Line 45: | Line 43: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| ipaddr | | ipaddr | ||
| varchar(16) | | varchar(16) | ||
| Line 51: | Line 49: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| serviceid | | serviceid | ||
| integer | | integer | ||
| Line 57: | Line 55: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| reductionkey | | reductionkey | ||
| varchar(256) | | varchar(256) | ||
| Line 63: | Line 61: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| alarmtype | | alarmtype | ||
| integer | | integer | ||
| Line 69: | Line 67: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| counter | | counter | ||
| integer | | integer | ||
| Line 75: | Line 73: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| severity | | severity | ||
| integer | | integer | ||
| Line 81: | Line 79: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| lasteventid | | lasteventid | ||
| integer | | integer | ||
| Line 87: | Line 85: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| firsteventtime | | firsteventtime | ||
| timestamp with time zone | | timestamp with time zone | ||
| Line 93: | Line 91: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| lasteventtime | | lasteventtime | ||
| timestamp with time zone | | timestamp with time zone | ||
| Line 99: | Line 97: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| firstautomationtime | | firstautomationtime | ||
| timestamp with time zone | | timestamp with time zone | ||
| Line 105: | Line 103: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| lastautomationtime | | lastautomationtime | ||
| timestamp with time zone | | timestamp with time zone | ||
| Line 111: | Line 109: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| description | | description | ||
| varchar(4000) | | varchar(4000) | ||
| Line 117: | Line 115: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| logmsg | | logmsg | ||
| varchar(256) | | varchar(256) | ||
| Line 123: | Line 121: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| operinstruct | | operinstruct | ||
| varchar(1024) | | varchar(1024) | ||
| Line 129: | Line 127: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| tticketid | | tticketid | ||
| varchar(128) | | varchar(128) | ||
| Line 135: | Line 133: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| tticketstate | | tticketstate | ||
| integer | | integer | ||
| Line 141: | Line 139: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| mouseovertext | | mouseovertext | ||
| varchar(64) | | varchar(64) | ||
| Line 147: | Line 145: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| suppresseduntil | | suppresseduntil | ||
| timestamp with time zone | | timestamp with time zone | ||
| Line 153: | Line 151: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| suppresseduser | | suppresseduser | ||
| varchar(256) | | varchar(256) | ||
| Line 159: | Line 157: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| suppressedtime | | suppressedtime | ||
| timestamp with time zone | | timestamp with time zone | ||
| Line 165: | Line 163: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| alarmackuser | | alarmackuser | ||
| varchar(256) | | varchar(256) | ||
| Line 171: | Line 169: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| alarmacktime | | alarmacktime | ||
| timestamp with time zone | | timestamp with time zone | ||
| Line 177: | Line 175: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| clearuei | | clearuei | ||
| varchar(256) | | varchar(256) | ||
| Line 183: | Line 181: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| managedobjectinstance | | managedobjectinstance | ||
| varchar(512) | | varchar(512) | ||
| Line 189: | Line 187: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| managedobjecttype | | managedobjecttype | ||
| varchar(512) | | varchar(512) | ||
| Line 195: | Line 193: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| applicationdn | | applicationdn | ||
| varchar(512) | | varchar(512) | ||
| Line 201: | Line 199: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| ossprimarykey | | ossprimarykey | ||
| varchar(512) | | varchar(512) | ||
| Line 207: | Line 205: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| x733alarmtype | | x733alarmtype | ||
| varchar(31) | | varchar(31) | ||
| Line 213: | Line 211: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| x733probablecause | | x733probablecause | ||
| integer | | integer | ||
| Line 219: | Line 217: | ||
| 0 | | 0 | ||
| | | | ||
| − | |- | + | |- valign="top" |
| qosalarmstate | | qosalarmstate | ||
| varchar(31) | | varchar(31) | ||
| Line 225: | Line 223: | ||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| clearkey | | clearkey | ||
| varchar(256) | | varchar(256) | ||
| Line 238: | Line 236: | ||
| '''Primary Key | | '''Primary Key | ||
| '''Columns | | '''Columns | ||
| − | |- | + | |- valign="top" |
| pk_alarmid | | pk_alarmid | ||
| alarmid | | alarmid | ||
| Line 249: | Line 247: | ||
| '''Type | | '''Type | ||
| '''Columns | | '''Columns | ||
| − | + | ||
| − | |- | + | |- valign="top" |
| alarm_reductionkey_idx | | alarm_reductionkey_idx | ||
| Unique | | Unique | ||
| reductionkey | | reductionkey | ||
| − | |- | + | |- valign="top" |
| alarm_app_dn | | alarm_app_dn | ||
| | | | ||
| applicationdn | | applicationdn | ||
| − | |- | + | |- valign="top" |
| alarm_clearkey_idx | | alarm_clearkey_idx | ||
| | | | ||
| clearkey | | clearkey | ||
| − | |- | + | |- valign="top" |
| alarm_eventid_idx | | alarm_eventid_idx | ||
| | | | ||
| lasteventid | | lasteventid | ||
| − | |- | + | |- valign="top" |
| alarm_nodeid_idx | | alarm_nodeid_idx | ||
| | | | ||
| nodeid | | nodeid | ||
| − | |- | + | |- valign="top" |
| alarm_oss_primary_key | | alarm_oss_primary_key | ||
| | | | ||
| ossprimarykey | | ossprimarykey | ||
| − | |- | + | |- valign="top" |
| alarm_reduction2_idx | | alarm_reduction2_idx | ||
| | | | ||
| alarmid, eventuei, dpname, nodeid, serviceid, reductionkey | | alarmid, eventuei, dpname, nodeid, serviceid, reductionkey | ||
| − | |- | + | |- valign="top" |
| alarm_uei_idx | | alarm_uei_idx | ||
| | | | ||
| Line 290: | Line 288: | ||
| '''Column | | '''Column | ||
| '''Referenced Column | | '''Referenced Column | ||
| − | + | ||
| − | |- | + | |- valign="top" |
| [[public.events_(table)|public.events]] | | [[public.events_(table)|public.events]] | ||
| lasteventid | | lasteventid | ||
| Line 303: | Line 301: | ||
| '''Column | | '''Column | ||
| '''Referencing Column | | '''Referencing Column | ||
| − | + | ||
| − | |- | + | |- valign="top" |
| [[public.alarm_attributes_(table)|public.alarm_attributes]] | | [[public.alarm_attributes_(table)|public.alarm_attributes]] | ||
| alarmid | | alarmid | ||
| alarmid | | alarmid | ||
|} | |} | ||
Revision as of 00:38, 25 June 2010
wikibot
| Table | public.alarms |
| Description | alaaaaaaarm |
Columns
| Column | Data Type | Nullable | Default | Description |
| alarmid | integer | not null | ||
| eventuei | varchar(256) | not null | ||
| dpname | varchar(12) | not null | ||
| nodeid | integer | null | ||
| ipaddr | varchar(16) | null | ||
| serviceid | integer | null | ||
| reductionkey | varchar(256) | null | ||
| alarmtype | integer | null | ||
| counter | integer | not null | ||
| severity | integer | not null | ||
| lasteventid | integer | null | ||
| firsteventtime | timestamp with time zone | null | ||
| lasteventtime | timestamp with time zone | null | ||
| firstautomationtime | timestamp with time zone | null | ||
| lastautomationtime | timestamp with time zone | null | ||
| description | varchar(4000) | null | ||
| logmsg | varchar(256) | null | ||
| operinstruct | varchar(1024) | null | ||
| tticketid | varchar(128) | null | ||
| tticketstate | integer | null | ||
| mouseovertext | varchar(64) | null | ||
| suppresseduntil | timestamp with time zone | null | ||
| suppresseduser | varchar(256) | null | ||
| suppressedtime | timestamp with time zone | null | ||
| alarmackuser | varchar(256) | null | ||
| alarmacktime | timestamp with time zone | null | ||
| clearuei | varchar(256) | null | ||
| managedobjectinstance | varchar(512) | null | ||
| managedobjecttype | varchar(512) | null | ||
| applicationdn | varchar(512) | null | ||
| ossprimarykey | varchar(512) | null | ||
| x733alarmtype | varchar(31) | null | ||
| x733probablecause | integer | not null | 0 | |
| qosalarmstate | varchar(31) | null | ||
| clearkey | varchar(256) | null |
Primary Key
| Primary Key | Columns |
| pk_alarmid | alarmid |
Indexes
| Index | Type | Columns |
| alarm_reductionkey_idx | Unique | reductionkey |
| alarm_app_dn | applicationdn | |
| alarm_clearkey_idx | clearkey | |
| alarm_eventid_idx | lasteventid | |
| alarm_nodeid_idx | nodeid | |
| alarm_oss_primary_key | ossprimarykey | |
| alarm_reduction2_idx | alarmid, eventuei, dpname, nodeid, serviceid, reductionkey | |
| alarm_uei_idx | eventuei |
Foreign Keys
| Relation | Column | Referenced Column |
| public.events | lasteventid | eventid |
Detail Tables
| Detail Table | Column | Referencing Column |
| public.alarm_attributes | alarmid | alarmid |
