Public.ipinterface (table)

wikibot

Table

public.ipinterface

Column	Data Type	Nullable	Default	PK	Index
id	integer	not null	nextval('opennmsnxtid'::regclass)	ipinterface_pkey
nodeid	integer	not null			ipinterface_nodeid_ipaddr_notzero_idxipinterface_nodeid_idxipinterface_nodeid_ipaddr_ismanaged_idx
ipaddr	varchar(16)	not null			ipinterface_nodeid_ipaddr_notzero_idxipinterface_nodeid_ismanaged_idxipinterface_ipaddr_idxipinterface_ipaddr_ismanaged_idxipinterface_nodeid_ipaddr_ismanaged_idx
ifindex	integer	null
iphostname	varchar(256)	null
ismanaged	char(1)	null			ipinterface_ipaddr_ismanaged_idxipinterface_nodeid_ipaddr_ismanaged_idx
ipstatus	integer	null
iplastcapsdpoll	timestamp with time zone	null
issnmpprimary	char(1)	null
snmpinterfaceid	integer	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