Editing Public.alarms (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.alarms | | public.alarms | ||
− | |- | + | |- |
− | |||
− | |||
|} | |} | ||
− | + | ||
{| 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 17: | Line 15: | ||
| '''Nullable | | '''Nullable | ||
| '''Default | | '''Default | ||
− | | ''' | + | | '''PK |
− | + | | '''Index | |
− | |- | + | |
+ | |- | ||
| alarmid | | alarmid | ||
− | | | + | | |
| not null | | not null | ||
| | | | ||
+ | | pk_alarmid | ||
+ | | alarm_reduction2_idx | ||
+ | |- | ||
+ | | eventuei | ||
| | | | ||
− | |||
− | |||
− | |||
| not null | | not null | ||
| | | | ||
| | | | ||
− | |- | + | | alarm_reduction2_idxalarm_uei_idx |
+ | |- | ||
| dpname | | dpname | ||
− | | | + | | |
| not null | | not null | ||
| | | | ||
| | | | ||
− | |- | + | | alarm_reduction2_idx |
+ | |- | ||
| nodeid | | nodeid | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | alarm_nodeid_idxalarm_reduction2_idx |
+ | |- | ||
| ipaddr | | ipaddr | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| serviceid | | serviceid | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | alarm_reduction2_idx |
+ | |- | ||
| reductionkey | | reductionkey | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | alarm_reductionkey_idxalarm_reduction2_idx |
+ | |- | ||
| alarmtype | | alarmtype | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| counter | | counter | ||
− | | | + | | |
| not null | | not null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| severity | | severity | ||
− | | | + | | |
| not null | | not null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| lasteventid | | lasteventid | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | alarm_eventid_idx |
+ | |- | ||
| firsteventtime | | firsteventtime | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| lasteventtime | | lasteventtime | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| firstautomationtime | | firstautomationtime | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| lastautomationtime | | lastautomationtime | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| description | | description | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| logmsg | | logmsg | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| operinstruct | | operinstruct | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| tticketid | | tticketid | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| tticketstate | | tticketstate | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| mouseovertext | | mouseovertext | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| suppresseduntil | | suppresseduntil | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| suppresseduser | | suppresseduser | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| suppressedtime | | suppressedtime | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| alarmackuser | | alarmackuser | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| alarmacktime | | alarmacktime | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| clearuei | | clearuei | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| managedobjectinstance | | managedobjectinstance | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| managedobjecttype | | managedobjecttype | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| applicationdn | | applicationdn | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | alarm_app_dn |
+ | |- | ||
| ossprimarykey | | ossprimarykey | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | alarm_oss_primary_key |
+ | |- | ||
| x733alarmtype | | x733alarmtype | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| x733probablecause | | x733probablecause | ||
− | | | + | | |
| not null | | not null | ||
+ | | 0 | ||
| | | | ||
| | | | ||
− | |- | + | |- |
| qosalarmstate | | qosalarmstate | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| clearkey | | clearkey | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
+ | | alarm_clearkey_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 288: | Line 272: | ||
| '''Column | | '''Column | ||
| '''Referenced Column | | '''Referenced Column | ||
− | + | ||
− | |- | + | |- |
| [[public.events_(table)|public.events]] | | [[public.events_(table)|public.events]] | ||
| lasteventid | | lasteventid | ||
Line 295: | Line 279: | ||
|} | |} | ||
− | + | ||
{| 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 301: | Line 285: | ||
| '''Column | | '''Column | ||
| '''Referencing Column | | '''Referencing Column | ||
− | + | ||
− | |- | + | |- |
| [[public.alarm_attributes_(table)|public.alarm_attributes]] | | [[public.alarm_attributes_(table)|public.alarm_attributes]] | ||
| alarmid | | alarmid | ||
| alarmid | | alarmid | ||
|} | |} |