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...)
 
 
(5 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''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 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| alarmid
 
| alarmid
 +
| integer
 +
| not null
 
|  
 
|  
−
| not null
 
 
|  
 
|  
−
| pk_alarmid
+
|- valign="top"
−
| alarm_reduction2_idx
 
−
|-
 
 
| eventuei
 
| eventuei
−
|  
+
| varchar(256)
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
−
| alarm_reduction2_idxalarm_uei_idx
+
|- valign="top"
−
|-
 
 
| dpname
 
| dpname
−
|  
+
| varchar(12)
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
−
| alarm_reduction2_idx
+
|- valign="top"
−
|-
 
 
| nodeid
 
| nodeid
−
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
| alarm_nodeid_idxalarm_reduction2_idx
+
|- valign="top"
−
|-
 
 
| ipaddr
 
| ipaddr
−
|  
+
| varchar(16)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| serviceid
 
| serviceid
−
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
| alarm_reduction2_idx
+
|- valign="top"
−
|-
 
 
| reductionkey
 
| reductionkey
−
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
| alarm_reductionkey_idxalarm_reduction2_idx
+
|- valign="top"
−
|-
 
 
| alarmtype
 
| alarmtype
−
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| counter
 
| counter
−
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| severity
 
| severity
−
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| lasteventid
 
| lasteventid
−
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
| alarm_eventid_idx
+
|- valign="top"
−
|-
 
 
| firsteventtime
 
| firsteventtime
−
|  
+
| timestamp with time zone
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| lasteventtime
 
| lasteventtime
−
|  
+
| timestamp with time zone
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| firstautomationtime
 
| firstautomationtime
−
|  
+
| timestamp with time zone
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| lastautomationtime
 
| lastautomationtime
−
|  
+
| timestamp with time zone
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| description
 
| description
−
|  
+
| varchar(4000)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| logmsg
 
| logmsg
−
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| operinstruct
 
| operinstruct
−
|  
+
| varchar(1024)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| tticketid
 
| tticketid
−
|  
+
| varchar(128)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| tticketstate
 
| tticketstate
−
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| mouseovertext
 
| mouseovertext
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| suppresseduntil
 
| suppresseduntil
−
|  
+
| timestamp with time zone
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| suppresseduser
 
| suppresseduser
−
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| suppressedtime
 
| suppressedtime
−
|  
+
| timestamp with time zone
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| alarmackuser
 
| alarmackuser
−
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| alarmacktime
 
| alarmacktime
−
|  
+
| timestamp with time zone
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| clearuei
 
| clearuei
−
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| managedobjectinstance
 
| managedobjectinstance
−
|  
+
| varchar(512)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| managedobjecttype
 
| managedobjecttype
−
|  
+
| varchar(512)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| applicationdn
 
| applicationdn
−
|  
+
| varchar(512)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
| alarm_app_dn
+
|- valign="top"
−
|-
 
 
| ossprimarykey
 
| ossprimarykey
−
|  
+
| varchar(512)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
| alarm_oss_primary_key
+
|- valign="top"
−
|-
 
 
| x733alarmtype
 
| x733alarmtype
−
|  
+
| varchar(31)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| x733probablecause
 
| x733probablecause
−
|  
+
| integer
 
| not null
 
| not null
−
| 0
 
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| qosalarmstate
 
| qosalarmstate
 +
| varchar(31)
 +
| null
 
|  
 
|  
 +
|
 +
|- valign="top"
 +
| clearkey
 +
| varchar(256)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
 +
|}
 +
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| pk_alarmid
 +
| alarmid
 +
|}
 +
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|- valign="top"
 +
| alarm_app_dn
 +
|
 +
| applicationdn
 +
|- valign="top"
 +
| alarm_clearkey_idx
 
|  
 
|  
−
|-
 
 
| clearkey
 
| clearkey
 +
|- valign="top"
 +
| alarm_eventid_idx
 +
|
 +
| lasteventid
 +
|- valign="top"
 +
| alarm_nodeid_idx
 +
|
 +
| nodeid
 +
|- valign="top"
 +
| alarm_oss_primary_key
 +
|
 +
| ossprimarykey
 +
|- valign="top"
 +
| alarm_reduction2_idx
 
|  
 
|  
−
| null
+
| alarmid, eventuei, dpname, nodeid, serviceid, reductionkey
 +
|- valign="top"
 +
| alarm_reductionkey_idx
 
|  
 
|  
 +
| reductionkey
 +
|- valign="top"
 +
| alarm_uei_idx
 
|  
 
|  
−
| alarm_clearkey_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 272: Line 288:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
−
+
 
−
|-
+
|- valign="top"
 
| [[public.events_(table)|public.events]]
 
| [[public.events_(table)|public.events]]
 
| lasteventid
 
| lasteventid
Line 279: Line 295:
 
|}
 
|}
  
−
 
+
=== 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"
Line 285: Line 301:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[public.alarm_attributes_(table)|public.alarm_attributes]]
 
| [[public.alarm_attributes_(table)|public.alarm_attributes]]
 
| alarmid
 
| alarmid
 
| alarmid
 
| alarmid
 
|}
 
|}

Latest revision as of 10:24, 27 August 2011

wikibot[edit]

Table public.alarms
Description alaaaaaaarm

Columns[edit]

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

Primary Key[edit]

Primary Key Columns
pk_alarmid alarmid

Indexes[edit]

Index Type Columns
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[edit]

Relation Column Referenced Column
public.events lasteventid eventid

Detail Tables[edit]

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