ScrewTurn Wiki

Tablepublic.datalinkinterface

Edit

Columns

ColumnData TypeNullableDefaultDescription
nodeidintegernot null  
ifindexintegernot null  
nodeparentidintegernot null  
parentifindexintegernot null  
statuschar(1)not null  
lastpolltimetimestamp without time zonenot null  

Edit

Primary Key

Primary KeyColumns
pk_datalinkinterfacenodeid, ifindex

Edit

Indexes

IndexTypeColumns
dlint_node_idx nodeid
dlint_nodeparent_idx nodeparentid
dlint_nodeparent_paifindex_idx nodeparentid, parentifindex

Edit

Foreign Keys

RelationColumnReferenced Column
public.nodenodeidnodeid
public.nodenodeparentidnodeid

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.