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

From dbscript Online Help
Jump to: navigation, search
 
(4 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.outages
 
| public.outages
−
|-
 
 
|}
 
|}
  
−
 
+
=== 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 14:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| outageid
 
| outageid
 
| integer
 
| integer
 
| not null
 
| not null
 
|  
 
|  
−
| pk_outageid
 
 
|  
 
|  
−
|-
+
|- valign="top"
 
| svclosteventid
 
| svclosteventid
 
| integer
 
| integer
Line 31: Line 28:
 
|  
 
|  
 
|  
 
|  
−
| outages_svclostid_idx
+
|- valign="top"
−
|-
 
 
| svcregainedeventid
 
| svcregainedeventid
 
| integer
 
| integer
Line 38: Line 34:
 
|  
 
|  
 
|  
 
|  
−
| outages_svcregainedid_idx
+
|- valign="top"
−
|-
 
 
| nodeid
 
| nodeid
 
| integer
 
| integer
Line 45: Line 40:
 
|  
 
|  
 
|  
 
|  
−
| outages_nodeid_ipaddr_svc_idxoutages_nodeid_idx
+
|- valign="top"
−
|-
 
 
| ipaddr
 
| ipaddr
 
| varchar(16)
 
| varchar(16)
Line 52: Line 46:
 
|  
 
|  
 
|  
 
|  
−
| outages_nodeid_ipaddr_svc_idxoutages_ipaddr_idx
+
|- valign="top"
−
|-
 
 
| serviceid
 
| serviceid
 
| integer
 
| integer
Line 59: Line 52:
 
|  
 
|  
 
|  
 
|  
−
| outages_serviceid_idxoutages_nodeid_ipaddr_svc_idx
+
|- valign="top"
−
|-
 
 
| iflostservice
 
| iflostservice
 
| timestamp with time zone
 
| timestamp with time zone
Line 66: Line 58:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| ifregainedservice
 
| ifregainedservice
 
| timestamp with time zone
 
| timestamp with time zone
Line 73: Line 64:
 
|  
 
|  
 
|  
 
|  
−
| outages_regainedservice_idx
+
|- valign="top"
−
|-
 
 
| suppresstime
 
| suppresstime
 
| timestamp with time zone
 
| timestamp with time zone
Line 80: Line 70:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| suppressedby
 
| suppressedby
 
| varchar(256)
 
| varchar(256)
Line 87: Line 76:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| ifserviceid
 
| ifserviceid
 
| integer
 
| integer
Line 94: Line 82:
 
|  
 
|  
 
|  
 
|  
−
| outages_ifservivceid_idx
 
 
|}
 
|}
  
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| pk_outageid
 +
| outageid
 +
|}
 +
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
  
 +
|- valign="top"
 +
| outages_ifservivceid_idx
 +
|
 +
| ifserviceid
 +
|- valign="top"
 +
| outages_ipaddr_idx
 +
|
 +
| ipaddr
 +
|- valign="top"
 +
| outages_nodeid_idx
 +
|
 +
| nodeid
 +
|- valign="top"
 +
| outages_nodeid_ipaddr_svc_idx
 +
|
 +
| nodeid, ipaddr, serviceid
 +
|- valign="top"
 +
| outages_regainedservice_idx
 +
|
 +
| ifregainedservice
 +
|- valign="top"
 +
| outages_serviceid_idx
 +
|
 +
| serviceid
 +
|- valign="top"
 +
| outages_svclostid_idx
 +
|
 +
| svclosteventid
 +
|- valign="top"
 +
| outages_svcregainedid_idx
 +
|
 +
| svcregainedeventid
 +
|}
  
 +
=== 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 104: Line 141:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
−
+
 
−
|-
+
|- valign="top"
 
| [[public.events_(table)|public.events]]
 
| [[public.events_(table)|public.events]]
 
| svclosteventid
 
| svclosteventid
 
| eventid
 
| eventid
−
|-
+
|- valign="top"
 
| [[public.events_(table)|public.events]]
 
| [[public.events_(table)|public.events]]
 
| svcregainedeventid
 
| svcregainedeventid
 
| eventid
 
| eventid
−
|-
+
|- valign="top"
 
| [[public.node_(table)|public.node]]
 
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.service_(table)|public.service]]
 
| [[public.service_(table)|public.service]]
 
| serviceid
 
| serviceid
 
| serviceid
 
| serviceid
−
|-
+
|- valign="top"
 
| [[public.ifservices_(table)|public.ifservices]]
 
| [[public.ifservices_(table)|public.ifservices]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.ifservices_(table)|public.ifservices]]
 
| [[public.ifservices_(table)|public.ifservices]]
 
| ifserviceid
 
| ifserviceid
Line 131: Line 168:
 
|}
 
|}
  
−
 
+
=== Triggers ===
 
{| 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"
−
| '''Triggers
+
| '''Trigger
 
| '''Type
 
| '''Type
 
| '''Function
 
| '''Function
−
+
 
−
|-
+
|- valign="top"
 
| setifservicekeysoninserttrigger
 
| setifservicekeysoninserttrigger
−
| ROWBEFORE INSERT
+
| STATEMENT AFTER
 
| setifservicekeysoninsert
 
| setifservicekeysoninsert
−
|-
+
|- valign="top"
 
| setifservicekeysonupdatetrigger
 
| setifservicekeysonupdatetrigger
−
| ROWBEFORE UPDATE
+
| STATEMENT AFTER
 
| setifservicekeysonupdate
 
| setifservicekeysonupdate
 
|}
 
|}

Latest revision as of 11:19, 27 August 2011

wikibot[edit]

Table public.outages

Columns[edit]

Column Data Type Nullable Default Description
outageid integer not null
svclosteventid integer null
svcregainedeventid integer null
nodeid integer not null
ipaddr varchar(16) not null
serviceid integer not null
iflostservice timestamp with time zone not null
ifregainedservice timestamp with time zone null
suppresstime timestamp with time zone null
suppressedby varchar(256) null
ifserviceid integer not null

Primary Key[edit]

Primary Key Columns
pk_outageid outageid

Indexes[edit]

Index Type Columns
outages_ifservivceid_idx ifserviceid
outages_ipaddr_idx ipaddr
outages_nodeid_idx nodeid
outages_nodeid_ipaddr_svc_idx nodeid, ipaddr, serviceid
outages_regainedservice_idx ifregainedservice
outages_serviceid_idx serviceid
outages_svclostid_idx svclosteventid
outages_svcregainedid_idx svcregainedeventid

Foreign Keys[edit]

Relation Column Referenced Column
public.events svclosteventid eventid
public.events svcregainedeventid eventid
public.node nodeid nodeid
public.service serviceid serviceid
public.ifservices nodeid nodeid
public.ifservices ifserviceid id

Triggers[edit]

Trigger Type Function
setifservicekeysoninserttrigger STATEMENT AFTER setifservicekeysoninsert
setifservicekeysonupdatetrigger STATEMENT AFTER setifservicekeysonupdate
Retrieved from "http://dbshelp.devio.at/index.php?title=Public.outages_(table)&oldid=3006"