ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
public.atinterface_(table)
Print
RSS
Modified: 2010/02/11 07:59 by
wikibot
-
Uncategorized
(10)
»
Person.Address_(table)
»
OE.OC_CUSTOMERS_(view)
»
public.atinterface_(table)
[X]
»
OE.PRODUCT_DESCRIPTIONS_(table)
»
public.category_node_(table)
»
public.qrtz_calendars_(table)
»
Person.AddressType_(table)
»
SH.SALES_TRANSACTIONS_EXT_(table)
»
SH.SUPPLEMENTARY_DEMOGRAPHICS_(table)
»
public.assets_(table)
»
Person.Address_(table)
»
OE.OC_CUSTOMERS_(view)
»
public.atinterface_(table)
Table
public.atinterface
Edit
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
Edit
Primary Key
Primary Key
Columns
pk_atinterface
nodeid, ipaddr, atphysaddr
Edit
Indexes
Index
Type
Columns
atinterface_nodeid_idx
nodeid
atinterface_atphysaddr_idx
atphysaddr
atinterface_node_ipaddr_idx
nodeid, ipaddr
Edit
Foreign Keys
Relation
Column
Referenced Column
public.node
nodeid
nodeid
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.