ScrewTurn Wiki

Tablepublic.atinterface

Edit

Columns

ColumnData TypeNullableDefaultDescription
idintegernot null  
nodeidintegernot null  
ipaddrvarchar(16)not null  
atphysaddrvarchar(12)not null  
statuschar(1)not null  
sourcenodeidintegernot null  
ifindexintegernot null  
lastpolltimetimestamp without time zonenot null  

Edit

Primary Key

Primary KeyColumns
pk_atinterfacenodeid, ipaddr, atphysaddr

Edit

Indexes

IndexTypeColumns
atinterface_atphysaddr_idx atphysaddr
atinterface_node_ipaddr_idx nodeid, ipaddr
atinterface_nodeid_idx nodeid

Edit

Foreign Keys

RelationColumnReferenced Column
public.nodenodeidnodeid

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