Public.ifservices (table)

wikibot

Table

public.ifservices

Column	Data Type	Nullable	Default	PK	Index
id		not null	nextval('opennmsnxtid'::regclass)	ifservices_pkey
nodeid		not null			ifservices_nodeid_ipaddr_svc_uniqueifservices_nodeid_ipaddr_statusifservices_nodeid_statusifservices_nodeid_idxifservices_nodeid_serviceid_idx
ipaddr		not null			ifservices_nodeid_ipaddr_svc_uniqueifservices_nodeid_ipaddr_status
ifindex		null
serviceid		not null			ifservices_nodeid_ipaddr_svc_uniqueifservices_serviceid_idxifservices_nodeid_serviceid_idx
lastgood		null
lastfail		null
qualifier		null
status		null			ifservices_nodeid_ipaddr_statusifservices_nodeid_status
source		null
notify		null
ipinterfaceid		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