Public.datalinkinterface (table)

From dbscript Online Help
Jump to: navigation, search

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