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.snmpinterface_(table)
Print
RSS
Modified: 2010/02/11 08:00 by
wikibot
-
Uncategorized
»
public.snmpinterface_(table)
[X]
»
public.snmpinterface_(table)
Table
public.snmpinterface
Edit
Columns
Column
Data Type
Nullable
Default
Description
id
integer
not null
nextval('opennmsnxtid'::regclass)
nodeid
integer
not null
ipaddr
varchar(16)
not null
snmpipadentnetmask
varchar(16)
null
snmpphysaddr
char(12)
null
snmpifindex
integer
not null
snmpifdescr
varchar(256)
null
snmpiftype
integer
null
snmpifname
varchar(96)
null
snmpifspeed
bigint
null
snmpifadminstatus
integer
null
snmpifoperstatus
integer
null
snmpifalias
varchar(256)
null
Edit
Primary Key
Primary Key
Columns
snmpinterface_pkey
id
Edit
Indexes
Index
Type
Columns
snmpinterface_nodeid_ifindex_unique_idx
Unique
nodeid, snmpifindex
snmpinterface_ipaddr_idx
ipaddr
snmpinterface_nodeid_idx
nodeid
Edit
Foreign Keys
Relation
Column
Referenced Column
public.node
nodeid
nodeid
Edit
Detail Tables
Detail Table
Column
Referencing Column
public.ipinterface
id
snmpinterfaceid
Edit
Dependencies
Reference Type
Object Type
Referencing Object
Select
Trigger Function
public.setsnmpinterfacekeysoninsert
Select
Trigger Function
public.setsnmpinterfacekeysonupdate
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.