Public.ipinterface (table)

wikibot

Table

public.ipinterface

Column	Data Type	Nullable	Default	PK	Index
id		not null	nextval('opennmsnxtid'::regclass)	ipinterface_pkey
nodeid		not null			ipinterface_nodeid_ipaddr_notzero_idxipinterface_nodeid_idxipinterface_nodeid_ipaddr_ismanaged_idx
ipaddr		not null			ipinterface_nodeid_ipaddr_notzero_idxipinterface_nodeid_ismanaged_idxipinterface_ipaddr_idxipinterface_ipaddr_ismanaged_idxipinterface_nodeid_ipaddr_ismanaged_idx
ifindex		null
iphostname		null
ismanaged		null			ipinterface_ipaddr_ismanaged_idxipinterface_nodeid_ipaddr_ismanaged_idx
ipstatus		null
iplastcapsdpoll		null
issnmpprimary		null
snmpinterfaceid		null			ipinterface_snmpinterfaceid_idx

Relation	Column	Referenced Column
public.node	nodeid	nodeid
public.snmpinterface	snmpinterfaceid	id

Detail Table	Column	Referencing Column
public.ifservices	id	ipinterfaceid

Triggers	Type	Function
setsnmpinterfacekeysoninserttrigger	ROWBEFORE INSERT	setsnmpinterfacekeysoninsert
setsnmpinterfacekeysonupdatetrigger	ROWBEFORE UPDATE	setsnmpinterfacekeysonupdate