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

From dbscript Online Help
Jump to: navigation, search
 
(2 intermediate revisions by the same user not shown)
Line 20: Line 20:
 
| integer
 
| integer
 
| not null
 
| not null
−
| nextval('opennmsnxtid'::regclass)
+
|  
 
|  
 
|  
 
|- valign="top"
 
|- valign="top"
Line 108: Line 108:
  
 
|- valign="top"
 
|- valign="top"
−
| ifservices_nodeid_ipaddr_svc_unique
+
| ifservices_nodeid_idx
−
| Unique
 
−
| nodeid, ipaddr, serviceid
 
−
|- valign="top"
 
−
| ifservices_serviceid_idx
 
 
|  
 
|  
−
| serviceid
+
| nodeid
 
|- valign="top"
 
|- 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"
 
|- valign="top"
 
| ifservices_nodeid_status
 
| ifservices_nodeid_status
 
|  
 
|  
 
| nodeid, status
 
| nodeid, status
 +
|- valign="top"
 +
| ifservices_serviceid_idx
 +
|
 +
| serviceid
 
|- valign="top"
 
|- valign="top"
 
| ifservicves_ipinterfaceid_idx
 
| ifservicves_ipinterfaceid_idx
 
|  
 
|  
 
| ipinterfaceid
 
| ipinterfaceid
−
|- valign="top"
 
−
| ifservices_nodeid_idx
 
−
|
 
−
| nodeid
 
−
|- valign="top"
 
−
| ifservices_nodeid_serviceid_idx
 
−
|
 
−
| nodeid, serviceid
 
 
|}
 
|}
  
Line 200: Line 200:
 
|- valign="top"
 
|- valign="top"
 
| setipinterfacekeysoninserttrigger
 
| setipinterfacekeysoninserttrigger
−
| ROW BEFORE INSERT
+
| STATEMENT AFTER
 
| setipinterfacekeysoninsert
 
| setipinterfacekeysoninsert
 
|- valign="top"
 
|- 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
 
−
 
−
|- valign="top"
 
−
| Select
 
−
| Function
 
−
| [[public.getmanagedoutageforintfinwindow_(function)|public.getmanagedoutageforintfinwindow]]
 
−
 
−
|- valign="top"
 
−
| Select
 
−
| Function
 
−
| [[public.getmanagedoutagefornodeinwindow_(function)|public.getmanagedoutagefornodeinwindow]]
 
−
 
−
|- valign="top"
 
−
| Select
 
−
| Function
 
−
| [[public.getmanagedservicecountforintf_(function)|public.getmanagedservicecountforintf]]
 
−
 
−
|- valign="top"
 
−
| Select
 
−
| Function
 
−
| [[public.getmanagedservicecountfornode_(function)|public.getmanagedservicecountfornode]]
 
−
 
−
|- valign="top"
 
−
| Select
 
−
| Trigger Function
 
−
| [[public.setifservicekeysoninsert_(trigger function)|public.setifservicekeysoninsert]]
 
−
 
−
|- valign="top"
 
−
| Select
 
−
| Trigger Function
 
−
| [[public.setifservicekeysonupdate_(trigger function)|public.setifservicekeysonupdate]]
 
−
 
 
|}
 
|}

Latest revision as of 10: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"