Difference between revisions of "Public.alarms (table)"
| (4 intermediate revisions by the same user not shown) | |||
| 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 | ||
| − | |- | + | |- valign="top" |
| + | | '''Description | ||
| + | | alaaaaaaarm | ||
|} | |} | ||
| − | + | === Columns === | |
{| 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 15: | Line 17: | ||
| '''Nullable | | '''Nullable | ||
| '''Default | | '''Default | ||
| − | | ''' | + | | '''Description |
| − | + | ||
| − | + | |- valign="top" | |
| − | |- | ||
| alarmid | | alarmid | ||
| integer | | integer | ||
| not null | | not null | ||
| | | | ||
| − | | | + | | |
| − | + | |- valign="top" | |
| − | |- | ||
| eventuei | | eventuei | ||
| varchar(256) | | varchar(256) | ||
| Line 31: | Line 31: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| dpname | | dpname | ||
| varchar(12) | | varchar(12) | ||
| Line 38: | Line 37: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| nodeid | | nodeid | ||
| integer | | integer | ||
| Line 45: | Line 43: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| ipaddr | | ipaddr | ||
| varchar(16) | | varchar(16) | ||
| Line 52: | Line 49: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| serviceid | | serviceid | ||
| integer | | integer | ||
| Line 59: | Line 55: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| reductionkey | | reductionkey | ||
| varchar(256) | | varchar(256) | ||
| Line 66: | Line 61: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| alarmtype | | alarmtype | ||
| integer | | integer | ||
| Line 73: | Line 67: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| counter | | counter | ||
| integer | | integer | ||
| Line 80: | Line 73: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| severity | | severity | ||
| integer | | integer | ||
| Line 87: | Line 79: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| lasteventid | | lasteventid | ||
| integer | | integer | ||
| Line 94: | Line 85: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| firsteventtime | | firsteventtime | ||
| timestamp with time zone | | timestamp with time zone | ||
| Line 101: | Line 91: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| lasteventtime | | lasteventtime | ||
| timestamp with time zone | | timestamp with time zone | ||
| Line 108: | Line 97: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| firstautomationtime | | firstautomationtime | ||
| timestamp with time zone | | timestamp with time zone | ||
| Line 115: | Line 103: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| lastautomationtime | | lastautomationtime | ||
| timestamp with time zone | | timestamp with time zone | ||
| Line 122: | Line 109: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| description | | description | ||
| varchar(4000) | | varchar(4000) | ||
| Line 129: | Line 115: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| logmsg | | logmsg | ||
| varchar(256) | | varchar(256) | ||
| Line 136: | Line 121: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| operinstruct | | operinstruct | ||
| varchar(1024) | | varchar(1024) | ||
| Line 143: | Line 127: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| tticketid | | tticketid | ||
| varchar(128) | | varchar(128) | ||
| Line 150: | Line 133: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| tticketstate | | tticketstate | ||
| integer | | integer | ||
| Line 157: | Line 139: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| mouseovertext | | mouseovertext | ||
| varchar(64) | | varchar(64) | ||
| Line 164: | Line 145: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| suppresseduntil | | suppresseduntil | ||
| timestamp with time zone | | timestamp with time zone | ||
| Line 171: | Line 151: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| suppresseduser | | suppresseduser | ||
| varchar(256) | | varchar(256) | ||
| Line 178: | Line 157: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| suppressedtime | | suppressedtime | ||
| timestamp with time zone | | timestamp with time zone | ||
| Line 185: | Line 163: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| alarmackuser | | alarmackuser | ||
| varchar(256) | | varchar(256) | ||
| Line 192: | Line 169: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| alarmacktime | | alarmacktime | ||
| timestamp with time zone | | timestamp with time zone | ||
| Line 199: | Line 175: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| clearuei | | clearuei | ||
| varchar(256) | | varchar(256) | ||
| Line 206: | Line 181: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| managedobjectinstance | | managedobjectinstance | ||
| varchar(512) | | varchar(512) | ||
| Line 213: | Line 187: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| managedobjecttype | | managedobjecttype | ||
| varchar(512) | | varchar(512) | ||
| Line 220: | Line 193: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| applicationdn | | applicationdn | ||
| varchar(512) | | varchar(512) | ||
| Line 227: | Line 199: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| ossprimarykey | | ossprimarykey | ||
| varchar(512) | | varchar(512) | ||
| Line 234: | Line 205: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| x733alarmtype | | x733alarmtype | ||
| varchar(31) | | varchar(31) | ||
| Line 241: | Line 211: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| x733probablecause | | x733probablecause | ||
| integer | | integer | ||
| not null | | not null | ||
| − | |||
| | | | ||
| | | | ||
| − | |- | + | |- valign="top" |
| qosalarmstate | | qosalarmstate | ||
| varchar(31) | | varchar(31) | ||
| Line 255: | Line 223: | ||
| | | | ||
| | | | ||
| − | + | |- valign="top" | |
| − | |- | ||
| clearkey | | clearkey | ||
| varchar(256) | | varchar(256) | ||
| Line 262: | Line 229: | ||
| | | | ||
| | | | ||
| − | |||
|} | |} | ||
| + | === Primary Key === | ||
| + | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| + | |- style="background:silver" | ||
| + | | '''Primary Key | ||
| + | | '''Columns | ||
| + | |- valign="top" | ||
| + | | pk_alarmid | ||
| + | | alarmid | ||
| + | |} | ||
| + | === Indexes === | ||
| + | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| + | |- style="background:silver" | ||
| + | | '''Index | ||
| + | | '''Type | ||
| + | | '''Columns | ||
| + | |||
| + | |- valign="top" | ||
| + | | alarm_app_dn | ||
| + | | | ||
| + | | applicationdn | ||
| + | |- valign="top" | ||
| + | | alarm_clearkey_idx | ||
| + | | | ||
| + | | clearkey | ||
| + | |- valign="top" | ||
| + | | alarm_eventid_idx | ||
| + | | | ||
| + | | lasteventid | ||
| + | |- valign="top" | ||
| + | | alarm_nodeid_idx | ||
| + | | | ||
| + | | nodeid | ||
| + | |- valign="top" | ||
| + | | alarm_oss_primary_key | ||
| + | | | ||
| + | | ossprimarykey | ||
| + | |- valign="top" | ||
| + | | alarm_reduction2_idx | ||
| + | | | ||
| + | | alarmid, eventuei, dpname, nodeid, serviceid, reductionkey | ||
| + | |- valign="top" | ||
| + | | alarm_reductionkey_idx | ||
| + | | | ||
| + | | reductionkey | ||
| + | |- valign="top" | ||
| + | | alarm_uei_idx | ||
| + | | | ||
| + | | eventuei | ||
| + | |} | ||
| + | === Foreign Keys === | ||
{| 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 272: | Line 288: | ||
| '''Column | | '''Column | ||
| '''Referenced Column | | '''Referenced Column | ||
| − | + | ||
| − | |- | + | |- valign="top" |
| [[public.events_(table)|public.events]] | | [[public.events_(table)|public.events]] | ||
| lasteventid | | lasteventid | ||
| Line 279: | Line 295: | ||
|} | |} | ||
| − | + | === Detail Tables === | |
{| 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 285: | 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 | ||
|} | |} | ||
Latest revision as of 10:24, 27 August 2011
wikibot[edit]
| Table | public.alarms |
| Description | alaaaaaaarm |
Columns[edit]
| 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 | ||
| qosalarmstate | varchar(31) | null | ||
| clearkey | varchar(256) | null |
Primary Key[edit]
| Primary Key | Columns |
| pk_alarmid | alarmid |
Indexes[edit]
| Index | Type | Columns |
| 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_reductionkey_idx | reductionkey | |
| alarm_uei_idx | eventuei |
Foreign Keys[edit]
| Relation | Column | Referenced Column |
| public.events | lasteventid | eventid |
Detail Tables[edit]
| Detail Table | Column | Referencing Column |
| public.alarm_attributes | alarmid | alarmid |
