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

From dbscript Online Help
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| public.datalinkinterface
 
| public.datalinkinterface
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 17: Line 15:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| nodeid
 
| nodeid
 
| integer
 
| integer
Line 24: Line 22:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| ifindex
 
| ifindex
 
| integer
 
| integer
Line 30: Line 28:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| nodeparentid
 
| nodeparentid
 
| integer
 
| integer
Line 36: Line 34:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| parentifindex
 
| parentifindex
 
| integer
 
| integer
Line 42: Line 40:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| status
 
| status
 
| char(1)
 
| char(1)
Line 48: Line 46:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| lastpolltime
 
| lastpolltime
 
| timestamp without time zone
 
| timestamp without time zone
Line 61: Line 59:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| pk_datalinkinterface
 
| pk_datalinkinterface
 
| nodeid, ifindex
 
| nodeid, ifindex
Line 72: Line 70:
 
| '''Type
 
| '''Type
 
| '''Columns
 
| '''Columns
+
 
|-
+
|- valign="top"
 +
| dlint_node_idx
 +
|
 +
| nodeid
 +
|- valign="top"
 
| dlint_nodeparent_idx
 
| dlint_nodeparent_idx
 
|  
 
|  
 
| nodeparentid
 
| nodeparentid
|-
+
|- valign="top"
| dlint_node_idx
 
|
 
| nodeid
 
|-
 
 
| dlint_nodeparent_paifindex_idx
 
| dlint_nodeparent_paifindex_idx
 
|  
 
|  
Line 93: Line 91:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
+
 
|-
+
|- valign="top"
 
| [[public.node_(table)|public.node]]
 
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
|-
+
|- valign="top"
 
| [[public.node_(table)|public.node]]
 
| [[public.node_(table)|public.node]]
 
| nodeparentid
 
| nodeparentid
 
| nodeid
 
| nodeid
 
|}
 
|}

Latest revision as of 11:09, 27 August 2011

wikibot[edit]

Table public.datalinkinterface

Columns[edit]

Column Data Type Nullable Default Description
nodeid integer not null
ifindex integer not null
nodeparentid integer not null
parentifindex integer not null
status char(1) not null
lastpolltime timestamp without time zone not null

Primary Key[edit]

Primary Key Columns
pk_datalinkinterface nodeid, ifindex

Indexes[edit]

Index Type Columns
dlint_node_idx nodeid
dlint_nodeparent_idx nodeparentid
dlint_nodeparent_paifindex_idx nodeparentid, parentifindex

Foreign Keys[edit]

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