Public.iprouteinterface (table)

wikibot

Table

public.iprouteinterface

Columns

Column	Data Type	Nullable	Default	Description
nodeid	integer	not null
routedest	varchar(16)	not null
routemask	varchar(16)	not null
routenexthop	varchar(16)	not null
routeifindex	integer	not null
routemetric1	integer	null
routemetric2	integer	null
routemetric3	integer	null
routemetric4	integer	null
routemetric5	integer	null
routetype	integer	null
routeproto	integer	null
status	char(1)	not null
lastpolltime	timestamp without time zone	not null

Primary Key

Primary Key	Columns
pk_iprouteinterface	nodeid, routedest

Indexes

Index	Type	Columns
iprouteinterface_rnh_idx		routenexthop
iprouteinterface_node_ifdex_idx		nodeid, routeifindex
iprouteinterface_nodeid_idx		nodeid

Foreign Keys

Relation	Column	Referenced Column
public.node	nodeid	nodeid