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

From dbscript Online Help
Jump to: navigation, search
Line 5: Line 5:
 
| '''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 19:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
 
 
 
 
|-
 
|-
Line 23: Line 26:
 
| not null
 
| not null
 
|  
 
|  
−
| pk_alarmid
+
|  
−
| alarm_reduction2_idx
 
 
|-
 
|-
 
| eventuei
 
| eventuei
Line 31: Line 33:
 
|  
 
|  
 
|  
 
|  
−
| alarm_reduction2_idxalarm_uei_idx
 
 
|-
 
|-
 
| dpname
 
| dpname
Line 38: Line 39:
 
|  
 
|  
 
|  
 
|  
−
| alarm_reduction2_idx
 
 
|-
 
|-
 
| nodeid
 
| nodeid
Line 45: Line 45:
 
|  
 
|  
 
|  
 
|  
−
| alarm_nodeid_idxalarm_reduction2_idx
 
 
|-
 
|-
 
| ipaddr
 
| ipaddr
 
| varchar(16)
 
| varchar(16)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 59: Line 57:
 
|  
 
|  
 
|  
 
|  
−
| alarm_reduction2_idx
 
 
|-
 
|-
 
| reductionkey
 
| reductionkey
Line 66: Line 63:
 
|  
 
|  
 
|  
 
|  
−
| alarm_reductionkey_idxalarm_reduction2_idx
 
 
|-
 
|-
 
| alarmtype
 
| alarmtype
 
| integer
 
| integer
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 78: Line 73:
 
| integer
 
| integer
 
| not null
 
| not null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 85: Line 79:
 
| integer
 
| integer
 
| not null
 
| not null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 94: Line 87:
 
|  
 
|  
 
|  
 
|  
−
| alarm_eventid_idx
 
 
|-
 
|-
 
| firsteventtime
 
| firsteventtime
 
| timestamp with time zone
 
| timestamp with time zone
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 106: Line 97:
 
| timestamp with time zone
 
| timestamp with time zone
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 113: Line 103:
 
| timestamp with time zone
 
| timestamp with time zone
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 120: Line 109:
 
| timestamp with time zone
 
| timestamp with time zone
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 127: Line 115:
 
| varchar(4000)
 
| varchar(4000)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 134: Line 121:
 
| varchar(256)
 
| varchar(256)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 141: Line 127:
 
| varchar(1024)
 
| varchar(1024)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 148: Line 133:
 
| varchar(128)
 
| varchar(128)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 155: Line 139:
 
| integer
 
| integer
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 162: Line 145:
 
| varchar(64)
 
| varchar(64)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 169: Line 151:
 
| timestamp with time zone
 
| timestamp with time zone
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 176: Line 157:
 
| varchar(256)
 
| varchar(256)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 183: Line 163:
 
| timestamp with time zone
 
| timestamp with time zone
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 190: Line 169:
 
| varchar(256)
 
| varchar(256)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 197: Line 175:
 
| timestamp with time zone
 
| timestamp with time zone
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 204: Line 181:
 
| varchar(256)
 
| varchar(256)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 211: Line 187:
 
| varchar(512)
 
| varchar(512)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 218: Line 193:
 
| varchar(512)
 
| varchar(512)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 227: Line 201:
 
|  
 
|  
 
|  
 
|  
−
| alarm_app_dn
 
 
|-
 
|-
 
| ossprimarykey
 
| ossprimarykey
Line 234: Line 207:
 
|  
 
|  
 
|  
 
|  
−
| alarm_oss_primary_key
 
 
|-
 
|-
 
| x733alarmtype
 
| x733alarmtype
 
| varchar(31)
 
| varchar(31)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 247: Line 218:
 
| not null
 
| not null
 
| 0
 
| 0
−
|
 
 
|  
 
|  
 
|-
 
|-
Line 253: Line 223:
 
| varchar(31)
 
| varchar(31)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 262: Line 231:
 
|  
 
|  
 
|  
 
|  
−
| alarm_clearkey_idx
 
 
|}
 
|}
  
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|-
 +
| pk_alarmid
 +
| alarmid
 +
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|-
 +
| alarm_reductionkey_idx
 +
| Unique
 +
| reductionkey
 +
|-
 +
| 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_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 279: Line 297:
 
|}
 
|}
  
−
 
+
=== 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"

Revision as of 09:31, 11 February 2010

wikibot

Table public.alarms
Description alaaaaaaarm


Columns

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 0
qosalarmstate varchar(31) null
clearkey varchar(256) null

Primary Key

Primary Key Columns
pk_alarmid alarmid

Indexes

Index Type Columns
alarm_reductionkey_idx Unique reductionkey
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_uei_idx eventuei

Foreign Keys

Relation Column Referenced Column
public.events lasteventid eventid

Detail Tables

Detail Table Column Referencing Column
public.alarm_attributes alarmid alarmid
Retrieved from "http://dbshelp.devio.at/index.php?title=Public.alarms_(table)&oldid=2335"