Welcome Guest, you are in: <root> • Login

Page History: public ifservices (table)

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: 2010/06/25 22:48

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 ¶

Trigger	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