Public.ifservices (table)

wikibot

Table

public.ifservices

Columns

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

Primary Key	Columns
ifservices_pkey	id

Indexes

Index	Type	Columns
ifservices_nodeid_idx		nodeid
ifservices_nodeid_ipaddr_status		nodeid, ipaddr, status
ifservices_nodeid_ipaddr_svc_unique	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

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

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