public datalinkinterface (table)

wikibot

Tablepublic.datalinkinterface

Columns

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

Primary Key

Primary KeyColumns
pk_datalinkinterfacenodeid, ifindex

Indexes

IndexTypeColumns
dlint_node_idx nodeid
dlint_nodeparent_idx nodeparentid
dlint_nodeparent_paifindex_idx nodeparentid, parentifindex

Foreign Keys

RelationColumnReferenced Column
public.nodenodeidnodeid
public.nodenodeparentidnodeid