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

From dbscript Online Help
Jump to: navigation, search
 
(3 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.ifservices
 
| public.ifservices
−
|-
 
 
|}
 
|}
−
 
  
 
=== Columns ===
 
=== Columns ===
Line 17: Line 15:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
−
+
 
−
|-
+
|- valign="top"
 
| id
 
| id
 
| integer
 
| integer
 
| not null
 
| not null
−
| nextval('opennmsnxtid'::regclass)
 
 
|  
 
|  
−
|-
+
|
 +
|- valign="top"
 
| nodeid
 
| nodeid
 
| integer
 
| integer
Line 30: Line 28:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| ipaddr
 
| ipaddr
 
| varchar(16)
 
| varchar(16)
Line 36: Line 34:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| ifindex
 
| ifindex
 
| integer
 
| integer
Line 42: Line 40:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| serviceid
 
| serviceid
 
| integer
 
| integer
Line 48: Line 46:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| lastgood
 
| lastgood
 
| timestamp with time zone
 
| timestamp with time zone
Line 54: Line 52:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| lastfail
 
| lastfail
 
| timestamp with time zone
 
| timestamp with time zone
Line 60: Line 58:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| qualifier
 
| qualifier
 
| char(16)
 
| char(16)
Line 66: Line 64:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| status
 
| status
 
| char(1)
 
| char(1)
Line 72: Line 70:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| source
 
| source
 
| char(1)
 
| char(1)
Line 78: Line 76:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| notify
 
| notify
 
| char(1)
 
| char(1)
Line 84: Line 82:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| ipinterfaceid
 
| ipinterfaceid
 
| integer
 
| integer
Line 97: Line 95:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
−
|-
+
|- valign="top"
 
| ifservices_pkey
 
| ifservices_pkey
 
| id
 
| id
Line 108: Line 106:
 
| '''Type
 
| '''Type
 
| '''Columns
 
| '''Columns
−
+
 
−
|-
+
|- valign="top"
−
| ifservices_nodeid_ipaddr_svc_unique
+
| ifservices_nodeid_idx
−
| Unique
 
−
| nodeid, ipaddr, serviceid
 
−
|-
 
−
| ifservices_serviceid_idx
 
 
|  
 
|  
−
| serviceid
+
| nodeid
−
|-
+
|- valign="top"
 
| ifservices_nodeid_ipaddr_status
 
| ifservices_nodeid_ipaddr_status
 
|  
 
|  
 
| nodeid, ipaddr, status
 
| nodeid, ipaddr, status
−
|-
+
|- valign="top"
 +
| ifservices_nodeid_ipaddr_svc_unique
 +
|
 +
| nodeid, ipaddr, serviceid
 +
|- valign="top"
 +
| ifservices_nodeid_serviceid_idx
 +
|
 +
| nodeid, serviceid
 +
|- valign="top"
 
| ifservices_nodeid_status
 
| ifservices_nodeid_status
 
|  
 
|  
 
| nodeid, status
 
| nodeid, status
−
|-
+
|- valign="top"
 +
| ifservices_serviceid_idx
 +
|
 +
| serviceid
 +
|- valign="top"
 
| ifservicves_ipinterfaceid_idx
 
| ifservicves_ipinterfaceid_idx
 
|  
 
|  
 
| ipinterfaceid
 
| ipinterfaceid
−
|-
 
−
| ifservices_nodeid_idx
 
−
|
 
−
| nodeid
 
−
|-
 
−
| ifservices_nodeid_serviceid_idx
 
−
|
 
−
| nodeid, serviceid
 
 
|}
 
|}
  
Line 145: Line 143:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
−
+
 
−
|-
+
|- 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.ipinterface_(table)|public.ipinterface]]
 
| [[public.ipinterface_(table)|public.ipinterface]]
 
| ipinterfaceid
 
| ipinterfaceid
Line 166: Line 164:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[public.outages_(table)|public.outages]]
 
| [[public.outages_(table)|public.outages]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.outages_(table)|public.outages]]
 
| [[public.outages_(table)|public.outages]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.outages_(table)|public.outages]]
 
| [[public.outages_(table)|public.outages]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.outages_(table)|public.outages]]
 
| [[public.outages_(table)|public.outages]]
 
| id
 
| id
 
| ifserviceid
 
| ifserviceid
−
|-
+
|- valign="top"
 
| [[public.application_service_map_(table)|public.application_service_map]]
 
| [[public.application_service_map_(table)|public.application_service_map]]
 
| id
 
| id
 
| ifserviceid
 
| ifserviceid
−
|-
+
|- valign="top"
 
| [[public.location_specific_status_changes_(table)|public.location_specific_status_changes]]
 
| [[public.location_specific_status_changes_(table)|public.location_specific_status_changes]]
 
| id
 
| id
 
| ifserviceid
 
| ifserviceid
 
|}
 
|}
−
 
  
 
=== Triggers ===
 
=== 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"
 
| setipinterfacekeysoninserttrigger
 
| setipinterfacekeysoninserttrigger
−
| ROW BEFORE INSERT
+
| STATEMENT AFTER
 
| setipinterfacekeysoninsert
 
| setipinterfacekeysoninsert
−
|-
+
|- valign="top"
 
| setipinterfacekeysonupdatetrigger
 
| setipinterfacekeysonupdatetrigger
−
| ROW BEFORE UPDATE
+
| STATEMENT AFTER
 
| setipinterfacekeysonupdate
 
| setipinterfacekeysonupdate
−
|}
 
−
 
−
=== Dependencies ===
 
−
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
−
|- style="background:silver"
 
−
| '''Reference Type
 
−
| '''Object Type
 
−
| '''Referencing Object
 
−
 
−
|-
 
−
| Select
 
−
| Function
 
−
| [[public.getmanagedoutageforintfinwindow_(function)|public.getmanagedoutageforintfinwindow]]
 
−
 
−
|-
 
−
| Select
 
−
| Function
 
−
| [[public.getmanagedoutagefornodeinwindow_(function)|public.getmanagedoutagefornodeinwindow]]
 
−
 
−
|-
 
−
| Select
 
−
| Function
 
−
| [[public.getmanagedservicecountforintf_(function)|public.getmanagedservicecountforintf]]
 
−
 
−
|-
 
−
| Select
 
−
| Function
 
−
| [[public.getmanagedservicecountfornode_(function)|public.getmanagedservicecountfornode]]
 
−
 
−
|-
 
−
| Select
 
−
| Trigger Function
 
−
| [[public.setifservicekeysoninsert_(trigger_function)|public.setifservicekeysoninsert]]
 
−
 
−
|-
 
−
| Select
 
−
| Trigger Function
 
−
| [[public.setifservicekeysonupdate_(trigger_function)|public.setifservicekeysonupdate]]
 
−
 
 
|}
 
|}

Latest revision as of 11:25, 27 August 2011

wikibot[edit]

Table public.ifservices

Columns[edit]

Column Data Type Nullable Default Description
id integer not null
nodeid integer not null
ipaddr varchar(16) not null
ifindex integer null
serviceid integer not null
lastgood timestamp with time zone null
lastfail timestamp with time zone null
qualifier char(16) null
status char(1) null
source char(1) null
notify char(1) null
ipinterfaceid integer not null

Primary Key[edit]

Primary Key Columns
ifservices_pkey id

Indexes[edit]

Index Type Columns
ifservices_nodeid_idx nodeid
ifservices_nodeid_ipaddr_status nodeid, ipaddr, status
ifservices_nodeid_ipaddr_svc_unique nodeid, ipaddr, serviceid
ifservices_nodeid_serviceid_idx nodeid, serviceid
ifservices_nodeid_status nodeid, status
ifservices_serviceid_idx serviceid
ifservicves_ipinterfaceid_idx ipinterfaceid

Foreign Keys[edit]

Relation Column Referenced Column
public.node nodeid nodeid
public.service serviceid serviceid
public.ipinterface ipinterfaceid id

Detail Tables[edit]

Detail Table Column Referencing Column
public.outages nodeid nodeid
public.outages nodeid nodeid
public.outages nodeid nodeid
public.outages id ifserviceid
public.application_service_map id ifserviceid
public.location_specific_status_changes id ifserviceid

Triggers[edit]

Trigger Type Function
setipinterfacekeysoninserttrigger STATEMENT AFTER setipinterfacekeysoninsert
setipinterfacekeysonupdatetrigger STATEMENT AFTER setipinterfacekeysonupdate
Retrieved from "http://dbshelp.devio.at/index.php?title=Public.ifservices_(table)&oldid=3030"