public iprouteinterface (table)

wikibot

Tablepublic.iprouteinterface

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  

Primary Key

Primary KeyColumns
pk_iprouteinterfacenodeid, routedest

Indexes

IndexTypeColumns
iprouteinterface_node_ifdex_idx nodeid, routeifindex
iprouteinterface_nodeid_idx nodeid
iprouteinterface_rnh_idx routenexthop

Foreign Keys

RelationColumnReferenced Column
public.nodenodeidnodeid