Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

Tablepublic.ipinterface

Columns

ColumnData TypeNullableDefaultDescription
idintegernot null  
nodeidintegernot null  
ipaddrvarchar(16)not null  
ifindexintegernull  
iphostnamevarchar(256)null  
ismanagedchar(1)null  
ipstatusintegernull  
iplastcapsdpolltimestamp with time zonenull  
issnmpprimarychar(1)null  
snmpinterfaceidintegernull  

Primary Key

Primary KeyColumns
ipinterface_pkeyid

Indexes

IndexTypeColumns
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

RelationColumnReferenced Column
public.nodenodeidnodeid
public.snmpinterfacesnmpinterfaceidid

Detail Tables

Detail TableColumnReferencing Column
public.ifservicesidipinterfaceid

Triggers

TriggerTypeFunction
setsnmpinterfacekeysoninserttriggerSTATEMENT AFTERsetsnmpinterfacekeysoninsert
setsnmpinterfacekeysonupdatetriggerSTATEMENT AFTERsetsnmpinterfacekeysonupdate

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