public atinterface (table)

wikibot ¶

Table

public.atinterface

Columns ¶

Column	Data Type	Nullable	Default	Description
id	integer	not null
nodeid	integer	not null
ipaddr	varchar(16)	not null
atphysaddr	varchar(12)	not null
status	char(1)	not null
sourcenodeid	integer	not null
ifindex	integer	not null
lastpolltime	timestamp without time zone	not null

Primary Key ¶

Primary Key	Columns
pk_atinterface	nodeid, ipaddr, atphysaddr

Indexes ¶

Index	Type	Columns
atinterface_atphysaddr_idx		atphysaddr
atinterface_node_ipaddr_idx		nodeid, ipaddr
atinterface_nodeid_idx		nodeid

Foreign Keys ¶

Relation	Column	Referenced Column
public.node	nodeid	nodeid