public atinterface (table)

wikibot

Tablepublic.atinterface

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  

Primary Key

Primary KeyColumns
pk_atinterfacenodeid, ipaddr, atphysaddr

Indexes

IndexTypeColumns
atinterface_atphysaddr_idx atphysaddr
atinterface_node_ipaddr_idx nodeid, ipaddr
atinterface_nodeid_idx nodeid

Foreign Keys

RelationColumnReferenced Column
public.nodenodeidnodeid