From dbscript Online Help
wikibot
| Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
| alarmid
|
|
not null
|
|
pk_alarmid
|
alarm_reduction2_idx
|
| eventuei
|
|
not null
|
|
|
alarm_reduction2_idxalarm_uei_idx
|
| dpname
|
|
not null
|
|
|
alarm_reduction2_idx
|
| nodeid
|
|
null
|
|
|
alarm_nodeid_idxalarm_reduction2_idx
|
| ipaddr
|
|
null
|
|
|
|
| serviceid
|
|
null
|
|
|
alarm_reduction2_idx
|
| reductionkey
|
|
null
|
|
|
alarm_reductionkey_idxalarm_reduction2_idx
|
| alarmtype
|
|
null
|
|
|
|
| counter
|
|
not null
|
|
|
|
| severity
|
|
not null
|
|
|
|
| lasteventid
|
|
null
|
|
|
alarm_eventid_idx
|
| firsteventtime
|
|
null
|
|
|
|
| lasteventtime
|
|
null
|
|
|
|
| firstautomationtime
|
|
null
|
|
|
|
| lastautomationtime
|
|
null
|
|
|
|
| description
|
|
null
|
|
|
|
| logmsg
|
|
null
|
|
|
|
| operinstruct
|
|
null
|
|
|
|
| tticketid
|
|
null
|
|
|
|
| tticketstate
|
|
null
|
|
|
|
| mouseovertext
|
|
null
|
|
|
|
| suppresseduntil
|
|
null
|
|
|
|
| suppresseduser
|
|
null
|
|
|
|
| suppressedtime
|
|
null
|
|
|
|
| alarmackuser
|
|
null
|
|
|
|
| alarmacktime
|
|
null
|
|
|
|
| clearuei
|
|
null
|
|
|
|
| managedobjectinstance
|
|
null
|
|
|
|
| managedobjecttype
|
|
null
|
|
|
|
| applicationdn
|
|
null
|
|
|
alarm_app_dn
|
| ossprimarykey
|
|
null
|
|
|
alarm_oss_primary_key
|
| x733alarmtype
|
|
null
|
|
|
|
| x733probablecause
|
|
not null
|
0
|
|
|
| qosalarmstate
|
|
null
|
|
|
|
| clearkey
|
|
null
|
|
|
alarm_clearkey_idx
|
| Relation
|
Column
|
Referenced Column
|
| public.events
|
lasteventid
|
eventid
|
