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

From dbscript Online Help
Jump to: navigation, search
 
(2 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 ===
 
=== Columns ===
Line 17: Line 15:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
−
+
 
−
|-
+
|- valign="top"
 
| outageid
 
| outageid
 
| integer
 
| integer
Line 24: Line 22:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| svclosteventid
 
| svclosteventid
 
| integer
 
| integer
Line 30: Line 28:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| svcregainedeventid
 
| svcregainedeventid
 
| integer
 
| integer
Line 36: Line 34:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| nodeid
 
| nodeid
 
| integer
 
| integer
Line 42: Line 40:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| ipaddr
 
| ipaddr
 
| varchar(16)
 
| varchar(16)
Line 48: Line 46:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| serviceid
 
| serviceid
 
| integer
 
| integer
Line 54: Line 52:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| iflostservice
 
| iflostservice
 
| timestamp with time zone
 
| timestamp with time zone
Line 60: Line 58:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| ifregainedservice
 
| ifregainedservice
 
| timestamp with time zone
 
| timestamp with time zone
Line 66: Line 64:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| suppresstime
 
| suppresstime
 
| timestamp with time zone
 
| timestamp with time zone
Line 72: Line 70:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| suppressedby
 
| suppressedby
 
| varchar(256)
 
| varchar(256)
Line 78: Line 76:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| ifserviceid
 
| ifserviceid
 
| integer
 
| integer
Line 91: Line 89:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
−
|-
+
|- valign="top"
 
| pk_outageid
 
| pk_outageid
 
| outageid
 
| outageid
Line 102: Line 100:
 
| '''Type
 
| '''Type
 
| '''Columns
 
| '''Columns
−
+
 
−
|-
+
|- valign="top"
 
| outages_ifservivceid_idx
 
| outages_ifservivceid_idx
 
|  
 
|  
 
| ifserviceid
 
| ifserviceid
−
|-
+
|- valign="top"
−
| outages_svcregainedid_idx
+
| outages_ipaddr_idx
 
|  
 
|  
−
| svcregainedeventid
+
| ipaddr
−
|-
+
|- valign="top"
−
| outages_svclostid_idx
+
| outages_nodeid_idx
 
|  
 
|  
−
| svclosteventid
+
| nodeid
−
|-
+
|- valign="top"
−
| outages_serviceid_idx
+
| outages_nodeid_ipaddr_svc_idx
 
|  
 
|  
−
| serviceid
+
| nodeid, ipaddr, serviceid
−
|-
+
|- valign="top"
 
| outages_regainedservice_idx
 
| outages_regainedservice_idx
 
|  
 
|  
 
| ifregainedservice
 
| ifregainedservice
−
|-
+
|- valign="top"
−
| outages_nodeid_ipaddr_svc_idx
+
| outages_serviceid_idx
 
|  
 
|  
−
| nodeid, ipaddr, serviceid
+
| serviceid
−
|-
+
|- valign="top"
−
| outages_nodeid_idx
+
| outages_svclostid_idx
 
|  
 
|  
−
| nodeid
+
| svclosteventid
−
|-
+
|- valign="top"
−
| outages_ipaddr_idx
+
| outages_svcregainedid_idx
 
|  
 
|  
−
| ipaddr
+
| svcregainedeventid
 
|}
 
|}
  
Line 143: 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 173: Line 171:
 
{| 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
−
| ROW BEFORE INSERT
+
| STATEMENT AFTER
 
| setifservicekeysoninsert
 
| setifservicekeysoninsert
−
|-
+
|- valign="top"
 
| setifservicekeysonupdatetrigger
 
| setifservicekeysonupdatetrigger
−
| ROW BEFORE UPDATE
+
| STATEMENT AFTER
 
| setifservicekeysonupdate
 
| setifservicekeysonupdate
−
|}
 
−
 
−
=== Dependencies ===
 
−
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
−
|- style="background:silver"
 
−
| '''Reference Type
 
−
| '''Object Type
 
−
| '''Referencing Object
 
−
 
−
|-
 
−
| Select
 
−
| Function
 
−
| [[public.getoutagetimeinwindow_(function)|public.getoutagetimeinwindow]]
 
−
 
 
|}
 
|}

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"