Difference between revisions of "Public.iprouteinterface (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.iprouteinterface |- |} {| border="1" cellpadding="5" cellspacing="0" ...)
 
Line 20: Line 20:
 
|-
 
|-
 
| nodeid
 
| nodeid
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
Line 27: Line 27:
 
|-
 
|-
 
| routedest
 
| routedest
|  
+
| varchar(16)
 
| not null
 
| not null
 
|  
 
|  
Line 34: Line 34:
 
|-
 
|-
 
| routemask
 
| routemask
|  
+
| varchar(16)
 
| not null
 
| not null
 
|  
 
|  
Line 41: Line 41:
 
|-
 
|-
 
| routenexthop
 
| routenexthop
|  
+
| varchar(16)
 
| not null
 
| not null
 
|  
 
|  
Line 48: Line 48:
 
|-
 
|-
 
| routeifindex
 
| routeifindex
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
Line 55: Line 55:
 
|-
 
|-
 
| routemetric1
 
| routemetric1
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
Line 62: Line 62:
 
|-
 
|-
 
| routemetric2
 
| routemetric2
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
Line 69: Line 69:
 
|-
 
|-
 
| routemetric3
 
| routemetric3
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
Line 76: Line 76:
 
|-
 
|-
 
| routemetric4
 
| routemetric4
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
Line 83: Line 83:
 
|-
 
|-
 
| routemetric5
 
| routemetric5
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
Line 90: Line 90:
 
|-
 
|-
 
| routetype
 
| routetype
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
Line 97: Line 97:
 
|-
 
|-
 
| routeproto
 
| routeproto
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
Line 104: Line 104:
 
|-
 
|-
 
| status
 
| status
|  
+
| char(1)
 
| not null
 
| not null
 
|  
 
|  
Line 111: Line 111:
 
|-
 
|-
 
| lastpolltime
 
| lastpolltime
|  
+
| timestamp without time zone
 
| not null
 
| not null
 
|  
 
|  

Revision as of 14:43, 7 August 2009

wikibot

Table public.iprouteinterface


Column Data Type Nullable Default PK Index
nodeid integer not null pk_iprouteinterface iprouteinterface_node_ifdex_idxiprouteinterface_nodeid_idx
routedest varchar(16) not null pk_iprouteinterface
routemask varchar(16) not null
routenexthop varchar(16) not null iprouteinterface_rnh_idx
routeifindex integer not null iprouteinterface_node_ifdex_idx
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


Relation Column Referenced Column
public.node nodeid nodeid