public ipinterface (table)

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