Public.atinterface (table)

From dbscript Online Help

Contents 1 wikibot 1.1 Columns 1.2 Primary Key 1.3 Indexes 1.4 Foreign Keys

wikibot

Table

public.atinterface

Columns

Column	Data Type	Nullable	Default	Description
id	integer	not null	nextval('opennmsnxtid'::regclass)
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_nodeid_idx		nodeid
atinterface_atphysaddr_idx		atphysaddr
atinterface_node_ipaddr_idx		nodeid, ipaddr

Foreign Keys

Relation	Column	Referenced Column
public.node	nodeid	nodeid