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		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	STATEMENT AFTER	setsnmpinterfacekeysoninsert
setsnmpinterfacekeysonupdatetrigger	STATEMENT AFTER	setsnmpinterfacekeysonupdate