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

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.datalinkinterface |- |} {| border="1" cellpadding="5" cellspacing="0"...)
 
Line 20: Line 20:
 
|-
 
|-
 
| nodeid
 
| nodeid
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
Line 27: Line 27:
 
|-
 
|-
 
| ifindex
 
| ifindex
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
Line 34: Line 34:
 
|-
 
|-
 
| nodeparentid
 
| nodeparentid
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
Line 41: Line 41:
 
|-
 
|-
 
| parentifindex
 
| parentifindex
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
Line 48: Line 48:
 
|-
 
|-
 
| status
 
| status
|  
+
| char(1)
 
| not null
 
| not null
 
|  
 
|  
Line 55: Line 55:
 
|-
 
|-
 
| lastpolltime
 
| lastpolltime
|  
+
| timestamp without time zone
 
| not null
 
| not null
 
|  
 
|  

Revision as of 14:42, 7 August 2009

wikibot

Table public.datalinkinterface


Column Data Type Nullable Default PK Index
nodeid integer not null pk_datalinkinterface dlint_node_idx
ifindex integer not null pk_datalinkinterface
nodeparentid integer not null dlint_nodeparent_idxdlint_nodeparent_paifindex_idx
parentifindex integer not null dlint_nodeparent_paifindex_idx
status char(1) not null
lastpolltime timestamp without time zone not null


Relation Column Referenced Column
public.node nodeid nodeid
public.node nodeparentid nodeid