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

From dbscript Online Help
Jump to: navigation, search
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_svcregainedid_idx
 
|  
 
|  
 
| svcregainedeventid
 
| svcregainedeventid
|-
+
|- valign="top"
 
| outages_svclostid_idx
 
| outages_svclostid_idx
 
|  
 
|  
 
| svclosteventid
 
| svclosteventid
|-
+
|- valign="top"
 
| outages_serviceid_idx
 
| outages_serviceid_idx
 
|  
 
|  
 
| serviceid
 
| serviceid
|-
+
|- valign="top"
 
| outages_regainedservice_idx
 
| outages_regainedservice_idx
 
|  
 
|  
 
| ifregainedservice
 
| ifregainedservice
|-
+
|- valign="top"
 
| outages_nodeid_ipaddr_svc_idx
 
| outages_nodeid_ipaddr_svc_idx
 
|  
 
|  
 
| nodeid, ipaddr, serviceid
 
| nodeid, ipaddr, serviceid
|-
+
|- valign="top"
 
| outages_nodeid_idx
 
| outages_nodeid_idx
 
|  
 
|  
 
| nodeid
 
| nodeid
|-
+
|- valign="top"
 
| outages_ipaddr_idx
 
| outages_ipaddr_idx
 
|  
 
|  
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
 
| ROW BEFORE INSERT
 
| setifservicekeysoninsert
 
| setifservicekeysoninsert
|-
+
|- valign="top"
 
| setifservicekeysonupdatetrigger
 
| setifservicekeysonupdatetrigger
 
| ROW BEFORE UPDATE
 
| ROW BEFORE UPDATE
Line 194: Line 192:
 
| '''Referencing Object
 
| '''Referencing Object
  
|-
+
|- valign="top"
 
| Select
 
| Select
 
| Function
 
| Function

Revision as of 23:39, 24 June 2010

wikibot

Table public.outages

Columns

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

Primary Key Columns
pk_outageid outageid

Indexes

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

Foreign Keys

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

Trigger Type Function
setifservicekeysoninserttrigger ROW BEFORE INSERT setifservicekeysoninsert
setifservicekeysonupdatetrigger ROW BEFORE UPDATE setifservicekeysonupdate

Dependencies

Reference Type Object Type Referencing Object
Select Function public.getoutagetimeinwindow