Public.ifservices (table)

wikibot

Table

public.ifservices

Column	Data Type	Nullable	Default	PK	Index
id	integer	not null	nextval('opennmsnxtid'::regclass)	ifservices_pkey
nodeid	integer	not null			ifservices_nodeid_ipaddr_svc_uniqueifservices_nodeid_ipaddr_statusifservices_nodeid_statusifservices_nodeid_idxifservices_nodeid_serviceid_idx
ipaddr	varchar(16)	not null			ifservices_nodeid_ipaddr_svc_uniqueifservices_nodeid_ipaddr_status
ifindex	integer	null
serviceid	integer	not null			ifservices_nodeid_ipaddr_svc_uniqueifservices_serviceid_idxifservices_nodeid_serviceid_idx
lastgood	timestamp with time zone	null
lastfail	timestamp with time zone	null
qualifier	char(16)	null
status	char(1)	null			ifservices_nodeid_ipaddr_statusifservices_nodeid_status
source	char(1)	null
notify	char(1)	null
ipinterfaceid	integer	not null			ifservicves_ipinterfaceid_idx

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

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	Type	Function
setipinterfacekeysoninserttrigger	ROWBEFORE INSERT	setipinterfacekeysoninsert
setipinterfacekeysonupdatetrigger	ROWBEFORE UPDATE	setipinterfacekeysonupdate