Public.atinterface (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table public.atinterface

Columns[edit]

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[edit]

Primary Key Columns
pk_atinterface nodeid, ipaddr, atphysaddr

Indexes[edit]

Index Type Columns
atinterface_atphysaddr_idx atphysaddr
atinterface_node_ipaddr_idx nodeid, ipaddr
atinterface_nodeid_idx nodeid

Foreign Keys[edit]

Relation Column Referenced Column
public.node nodeid nodeid