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		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

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	STATEMENT AFTER	setipinterfacekeysoninsert
setipinterfacekeysonupdatetrigger	STATEMENT AFTER	setipinterfacekeysonupdate