Public.datalinkinterface (table)

From dbscript Online Help

Contents 1 wikibot 1.1 Columns 1.2 Primary Key 1.3 Indexes 1.4 Foreign Keys

wikibot

Table

public.datalinkinterface

Columns

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

Primary Key	Columns
pk_datalinkinterface	nodeid, ifindex

Indexes

Index	Type	Columns
dlint_nodeparent_idx		nodeparentid
dlint_node_idx		nodeid
dlint_nodeparent_paifindex_idx		nodeparentid, parentifindex

Foreign Keys

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