Welcome Guest, you are in: • Login

devio dbscript ScrewTurn Wiki

Navigation¶

Main Page

Create Account

Search the wiki
»

PoweredBy

Discuss (0) View Page Code History

public ipinterface (table)

Print

RSS

Modified on 2011/08/27 11:44 by wikibot Categorized as Uncategorized

» 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

Detail Tables ¶

Detail Table	Column	Referencing Column
public.ifservices	id	ipinterfaceid

Triggers ¶

Trigger	Type	Function
setsnmpinterfacekeysoninserttrigger	STATEMENT AFTER	setsnmpinterfacekeysoninsert
setsnmpinterfacekeysonupdatetrigger	STATEMENT AFTER	setsnmpinterfacekeysonupdate

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