Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

Tablepublic.alarms
Descriptionalaaaaaaarm

Columns

ColumnData TypeNullableDefaultDescription
alarmidintegernot null  
eventueivarchar(256)not null  
dpnamevarchar(12)not null  
nodeidintegernull  
ipaddrvarchar(16)null  
serviceidintegernull  
reductionkeyvarchar(256)null  
alarmtypeintegernull  
counterintegernot null  
severityintegernot null  
lasteventidintegernull  
firsteventtimetimestamp with time zonenull  
lasteventtimetimestamp with time zonenull  
firstautomationtimetimestamp with time zonenull  
lastautomationtimetimestamp with time zonenull  
descriptionvarchar(4000)null  
logmsgvarchar(256)null  
operinstructvarchar(1024)null  
tticketidvarchar(128)null  
tticketstateintegernull  
mouseovertextvarchar(64)null  
suppresseduntiltimestamp with time zonenull  
suppresseduservarchar(256)null  
suppressedtimetimestamp with time zonenull  
alarmackuservarchar(256)null  
alarmacktimetimestamp with time zonenull  
clearueivarchar(256)null  
managedobjectinstancevarchar(512)null  
managedobjecttypevarchar(512)null  
applicationdnvarchar(512)null  
ossprimarykeyvarchar(512)null  
x733alarmtypevarchar(31)null  
x733probablecauseintegernot null  
qosalarmstatevarchar(31)null  
clearkeyvarchar(256)null  

Primary Key

Primary KeyColumns
pk_alarmidalarmid

Indexes

IndexTypeColumns
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

RelationColumnReferenced Column
public.eventslasteventideventid

Detail Tables

Detail TableColumnReferencing Column
public.alarm_attributesalarmidalarmid

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.