Welcome Guest, you are in: <root> • Login

Page History: public ipinterface (table)

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 2010/02/11 09:23

wikibot ¶

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