From dbscript Online Help
wikibot[edit]
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
|
