ScrewTurn Wiki

Navigation

Main Page

Quick Search

Advanced Search »

PoweredBy

Discuss (0)View Page Code History

public.ifservices_(table)

Modified: 2010/02/11 07:59 by wikibot - Uncategorized

(10) » public.getmanagepercentavailnodewindow_(function) » public.ipinterface_(table) » public.ifservices_(table)

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

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.