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

From dbscript Online Help
Jump to: navigation, search
Line 9: Line 9:
  
  
 +
=== 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 16:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
 
 
 
 
|-
 
|-
Line 23: Line 23:
 
| not null
 
| not null
 
| nextval('opennmsnxtid'::regclass)
 
| nextval('opennmsnxtid'::regclass)
−
| ifservices_pkey
 
 
|  
 
|  
 
|-
 
|-
Line 31: Line 30:
 
|  
 
|  
 
|  
 
|  
−
| ifservices_nodeid_ipaddr_svc_uniqueifservices_nodeid_ipaddr_statusifservices_nodeid_statusifservices_nodeid_idxifservices_nodeid_serviceid_idx
 
 
|-
 
|-
 
| ipaddr
 
| ipaddr
Line 38: Line 36:
 
|  
 
|  
 
|  
 
|  
−
| ifservices_nodeid_ipaddr_svc_uniqueifservices_nodeid_ipaddr_status
 
 
|-
 
|-
 
| ifindex
 
| ifindex
 
| integer
 
| integer
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 52: Line 48:
 
|  
 
|  
 
|  
 
|  
−
| ifservices_nodeid_ipaddr_svc_uniqueifservices_serviceid_idxifservices_nodeid_serviceid_idx
 
 
|-
 
|-
 
| lastgood
 
| lastgood
 
| timestamp with time zone
 
| timestamp with time zone
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 64: Line 58:
 
| timestamp with time zone
 
| timestamp with time zone
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 71: Line 64:
 
| char(16)
 
| char(16)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 80: Line 72:
 
|  
 
|  
 
|  
 
|  
−
| ifservices_nodeid_ipaddr_statusifservices_nodeid_status
 
 
|-
 
|-
 
| source
 
| source
 
| char(1)
 
| char(1)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 92: Line 82:
 
| char(1)
 
| char(1)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 101: Line 90:
 
|  
 
|  
 
|  
 
|  
−
| ifservicves_ipinterfaceid_idx
 
 
|}
 
|}
  
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|-
 +
| ifservices_pkey
 +
| id
 +
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|-
 +
| ifservices_nodeid_ipaddr_svc_unique
 +
| Unique
 +
| nodeid, ipaddr, serviceid
 +
|-
 +
| ifservices_serviceid_idx
 +
|
 +
| serviceid
 +
|-
 +
| ifservices_nodeid_ipaddr_status
 +
|
 +
| nodeid, ipaddr, status
 +
|-
 +
| ifservices_nodeid_status
 +
|
 +
| nodeid, status
 +
|-
 +
| ifservicves_ipinterfaceid_idx
 +
|
 +
| ipinterfaceid
 +
|-
 +
| ifservices_nodeid_idx
 +
|
 +
| nodeid
 +
|-
 +
| ifservices_nodeid_serviceid_idx
 +
|
 +
| nodeid, serviceid
 +
|}
  
 +
=== 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 126: Line 160:
 
|}
 
|}
  
−
 
+
=== 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 160: Line 194:
  
  
 +
=== 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"
Line 174: Line 209:
 
| ROW BEFORE UPDATE
 
| ROW BEFORE UPDATE
 
| 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]]
 +
 
|}
 
|}

Revision as of 09:31, 11 February 2010

wikibot

Table public.ifservices


Columns

Column Data Type Nullable Default Description
id integer not null nextval('opennmsnxtid'::regclass)
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

Primary Key Columns
ifservices_pkey id

Indexes

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

Foreign Keys

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

Detail Tables

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

Triggers Type Function
setipinterfacekeysoninserttrigger ROW BEFORE INSERT setipinterfacekeysoninsert
setipinterfacekeysonupdatetrigger ROW BEFORE UPDATE setipinterfacekeysonupdate

Dependencies

Reference Type Object Type Referencing Object
Select Function public.getmanagedoutageforintfinwindow
Select Function public.getmanagedoutagefornodeinwindow
Select Function public.getmanagedservicecountforintf
Select Function public.getmanagedservicecountfornode
Select Trigger Function public.setifservicekeysoninsert
Select Trigger Function public.setifservicekeysonupdate
Retrieved from "http://dbshelp.devio.at/index.php?title=Public.ifservices_(table)&oldid=2360"