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	ROW BEFORE INSERT	setsnmpinterfacekeysoninsert
setsnmpinterfacekeysonupdatetrigger	ROW BEFORE UPDATE	setsnmpinterfacekeysonupdate