ScrewTurn Wiki

Tablepublic.iprouteinterface

Edit

Columns

ColumnData TypeNullableDefaultDescription
nodeidintegernot null  
routedestvarchar(16)not null  
routemaskvarchar(16)not null  
routenexthopvarchar(16)not null  
routeifindexintegernot null  
routemetric1integernull  
routemetric2integernull  
routemetric3integernull  
routemetric4integernull  
routemetric5integernull  
routetypeintegernull  
routeprotointegernull  
statuschar(1)not null  
lastpolltimetimestamp without time zonenot null  

Edit

Primary Key

Primary KeyColumns
pk_iprouteinterfacenodeid, routedest

Edit

Indexes

IndexTypeColumns
iprouteinterface_node_ifdex_idx nodeid, routeifindex
iprouteinterface_nodeid_idx nodeid
iprouteinterface_rnh_idx routenexthop

Edit

Foreign Keys

RelationColumnReferenced Column
public.nodenodeidnodeid

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