Public.ipinterface (table)

wikibot

Table

public.ipinterface

Columns

Column	Data Type	Nullable	Default	Description
id	integer	not null
nodeid	integer	not null
ipaddr	varchar(16)	not null
ifindex	integer	null
iphostname	varchar(256)	null
ismanaged	char(1)	null
ipstatus	integer	null
iplastcapsdpoll	timestamp with time zone	null
issnmpprimary	char(1)	null
snmpinterfaceid	integer	null

Primary Key

Primary Key	Columns
ipinterface_pkey	id

Indexes

Index	Type	Columns
ipinterface_ipaddr_idx		ipaddr
ipinterface_ipaddr_ismanaged_idx		ipaddr, ismanaged
ipinterface_nodeid_idx		nodeid
ipinterface_nodeid_ipaddr_ismanaged_idx		nodeid, ipaddr, ismanaged
ipinterface_nodeid_ipaddr_notzero_idx	Unique	nodeid, ipaddr
ipinterface_nodeid_ismanaged_idx		ipaddr
ipinterface_snmpinterfaceid_idx		snmpinterfaceid

Foreign Keys

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

Triggers

Trigger	Type	Function
setsnmpinterfacekeysoninserttrigger	ROW BEFORE INSERT	setsnmpinterfacekeysoninsert
setsnmpinterfacekeysonupdatetrigger	ROW BEFORE UPDATE	setsnmpinterfacekeysonupdate

Dependencies

Reference Type	Object Type	Referencing Object
Select	Function	public.getmanagedoutageforintfinwindow
Select	Function	public.getmanagedoutagefornodeinwindow
Select	Function	public.getmanagedservicecountforintf
Select	Function	public.getmanagedservicecountfornode
Select	Trigger Function	public.setipinterfacekeysoninsert
Select	Trigger Function	public.setipinterfacekeysonupdate