Welcome Guest, you are in: • Login

devio dbscript ScrewTurn Wiki

Navigation¶

Main Page

Create Account

Search the wiki
»

PoweredBy

Discuss (0) View Page Code History

public atinterface (table)

Print

RSS

Modified on 2011/08/27 11:43 by wikibot Categorized as Uncategorized

» 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

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.