Difference between revisions of "Public.alarms (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.alarms |- |} {| border="1" cellpadding="5" cellspacing="0" style="bor...)
 
Line 20: Line 20:
 
|-
 
|-
 
| alarmid
 
| alarmid
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
Line 27: Line 27:
 
|-
 
|-
 
| eventuei
 
| eventuei
|  
+
| varchar(256)
 
| not null
 
| not null
 
|  
 
|  
Line 34: Line 34:
 
|-
 
|-
 
| dpname
 
| dpname
|  
+
| varchar(12)
 
| not null
 
| not null
 
|  
 
|  
Line 41: Line 41:
 
|-
 
|-
 
| nodeid
 
| nodeid
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
Line 48: Line 48:
 
|-
 
|-
 
| ipaddr
 
| ipaddr
|  
+
| varchar(16)
 
| null
 
| null
 
|  
 
|  
Line 55: Line 55:
 
|-
 
|-
 
| serviceid
 
| serviceid
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
Line 62: Line 62:
 
|-
 
|-
 
| reductionkey
 
| reductionkey
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
Line 69: Line 69:
 
|-
 
|-
 
| alarmtype
 
| alarmtype
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
Line 76: Line 76:
 
|-
 
|-
 
| counter
 
| counter
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
Line 83: Line 83:
 
|-
 
|-
 
| severity
 
| severity
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
Line 90: Line 90:
 
|-
 
|-
 
| lasteventid
 
| lasteventid
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
Line 97: Line 97:
 
|-
 
|-
 
| firsteventtime
 
| firsteventtime
|  
+
| timestamp with time zone
 
| null
 
| null
 
|  
 
|  
Line 104: Line 104:
 
|-
 
|-
 
| lasteventtime
 
| lasteventtime
|  
+
| timestamp with time zone
 
| null
 
| null
 
|  
 
|  
Line 111: Line 111:
 
|-
 
|-
 
| firstautomationtime
 
| firstautomationtime
|  
+
| timestamp with time zone
 
| null
 
| null
 
|  
 
|  
Line 118: Line 118:
 
|-
 
|-
 
| lastautomationtime
 
| lastautomationtime
|  
+
| timestamp with time zone
 
| null
 
| null
 
|  
 
|  
Line 125: Line 125:
 
|-
 
|-
 
| description
 
| description
|  
+
| varchar(4000)
 
| null
 
| null
 
|  
 
|  
Line 132: Line 132:
 
|-
 
|-
 
| logmsg
 
| logmsg
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
Line 139: Line 139:
 
|-
 
|-
 
| operinstruct
 
| operinstruct
|  
+
| varchar(1024)
 
| null
 
| null
 
|  
 
|  
Line 146: Line 146:
 
|-
 
|-
 
| tticketid
 
| tticketid
|  
+
| varchar(128)
 
| null
 
| null
 
|  
 
|  
Line 153: Line 153:
 
|-
 
|-
 
| tticketstate
 
| tticketstate
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
Line 160: Line 160:
 
|-
 
|-
 
| mouseovertext
 
| mouseovertext
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 167: Line 167:
 
|-
 
|-
 
| suppresseduntil
 
| suppresseduntil
|  
+
| timestamp with time zone
 
| null
 
| null
 
|  
 
|  
Line 174: Line 174:
 
|-
 
|-
 
| suppresseduser
 
| suppresseduser
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
Line 181: Line 181:
 
|-
 
|-
 
| suppressedtime
 
| suppressedtime
|  
+
| timestamp with time zone
 
| null
 
| null
 
|  
 
|  
Line 188: Line 188:
 
|-
 
|-
 
| alarmackuser
 
| alarmackuser
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
Line 195: Line 195:
 
|-
 
|-
 
| alarmacktime
 
| alarmacktime
|  
+
| timestamp with time zone
 
| null
 
| null
 
|  
 
|  
Line 202: Line 202:
 
|-
 
|-
 
| clearuei
 
| clearuei
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
Line 209: Line 209:
 
|-
 
|-
 
| managedobjectinstance
 
| managedobjectinstance
|  
+
| varchar(512)
 
| null
 
| null
 
|  
 
|  
Line 216: Line 216:
 
|-
 
|-
 
| managedobjecttype
 
| managedobjecttype
|  
+
| varchar(512)
 
| null
 
| null
 
|  
 
|  
Line 223: Line 223:
 
|-
 
|-
 
| applicationdn
 
| applicationdn
|  
+
| varchar(512)
 
| null
 
| null
 
|  
 
|  
Line 230: Line 230:
 
|-
 
|-
 
| ossprimarykey
 
| ossprimarykey
|  
+
| varchar(512)
 
| null
 
| null
 
|  
 
|  
Line 237: Line 237:
 
|-
 
|-
 
| x733alarmtype
 
| x733alarmtype
|  
+
| varchar(31)
 
| null
 
| null
 
|  
 
|  
Line 244: Line 244:
 
|-
 
|-
 
| x733probablecause
 
| x733probablecause
|  
+
| integer
 
| not null
 
| not null
 
| 0
 
| 0
Line 251: Line 251:
 
|-
 
|-
 
| qosalarmstate
 
| qosalarmstate
|  
+
| varchar(31)
 
| null
 
| null
 
|  
 
|  
Line 258: Line 258:
 
|-
 
|-
 
| clearkey
 
| clearkey
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  

Revision as of 14:42, 7 August 2009

wikibot

Table public.alarms


Column Data Type Nullable Default PK Index
alarmid integer not null pk_alarmid alarm_reduction2_idx
eventuei varchar(256) not null alarm_reduction2_idxalarm_uei_idx
dpname varchar(12) not null alarm_reduction2_idx
nodeid integer null alarm_nodeid_idxalarm_reduction2_idx
ipaddr varchar(16) null
serviceid integer null alarm_reduction2_idx
reductionkey varchar(256) null alarm_reductionkey_idxalarm_reduction2_idx
alarmtype integer null
counter integer not null
severity integer not null
lasteventid integer null alarm_eventid_idx
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 alarm_app_dn
ossprimarykey varchar(512) null alarm_oss_primary_key
x733alarmtype varchar(31) null
x733probablecause integer not null 0
qosalarmstate varchar(31) null
clearkey varchar(256) null alarm_clearkey_idx


Relation Column Referenced Column
public.events lasteventid eventid


Detail Table Column Referencing Column
public.alarm_attributes alarmid alarmid