ScrewTurn Wiki

Navigation

Main Page

Quick Search

Advanced Search »

PoweredBy

Discuss (0)View Page Code History

public.ipinterface_(table)

Modified: 2010/02/11 07:59 by wikibot - Uncategorized

(10) » IX.SYS_IOT_OVER_49922_(table) » public.getmanagepercentavailnodewindow_(function) » public.ipinterface_(table)

Table

public.ipinterface

Columns

Column	Data Type	Nullable	Default	Description
id	integer	not null	nextval('opennmsnxtid'::regclass)
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_nodeid_ipaddr_notzero_idx	Unique	nodeid, ipaddr
ipinterface_snmpinterfaceid_idx		snmpinterfaceid
ipinterface_nodeid_ismanaged_idx		ipaddr
ipinterface_ipaddr_idx		ipaddr
ipinterface_ipaddr_ismanaged_idx		ipaddr, ismanaged
ipinterface_nodeid_idx		nodeid
ipinterface_nodeid_ipaddr_ismanaged_idx		nodeid, ipaddr, ismanaged

Foreign Keys

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

Detail Tables

Detail Table	Column	Referencing Column
public.ifservices	id	ipinterfaceid

Triggers

Triggers	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

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.