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.stpinterface_(table)
Print
RSS
Modified: 2011/08/27 10:41 by
wikibot
-
Uncategorized
(10)
»
public.setipinterfacekeysoninsert_(trigger function)
»
PM.TEXTDOCS_NESTEDTAB_(table)
»
public.stpinterface_(table)
[X]
»
OE.ORDER_ITEMS_(table)
»
public.assets_(table)
»
dbo.OrderNumber_(type)
»
public.qrtz_job_listeners_(table)
»
Purchasing_(schema)
»
OE.PRODUCT_PRICES_(view)
»
SH.DR$SUP_TEXT_IDX$K_(table)
»
public.setipinterfacekeysoninsert_(trigger function)
»
PM.TEXTDOCS_NESTEDTAB_(table)
»
public.stpinterface_(table)
Table
public.stpinterface
Edit
Columns
Column
Data Type
Nullable
Default
Description
nodeid
integer
not null
bridgeport
integer
not null
ifindex
integer
not null
stpportstate
integer
null
stpportpathcost
integer
null
stpportdesignatedroot
varchar(16)
null
stpportdesignatedcost
integer
null
stpportdesignatedbridge
varchar(16)
null
stpportdesignatedport
varchar(4)
null
status
char(1)
not null
lastpolltime
timestamp without time zone
not null
stpvlan
integer
not null
Edit
Primary Key
Primary Key
Columns
pk_stpinterface
nodeid, bridgeport, stpvlan
Edit
Indexes
Index
Type
Columns
stpinterface_node_idx
nodeid
stpinterface_node_ifindex_idx
nodeid, ifindex
stpinterface_stpdesbridge_idx
stpportdesignatedbridge
stpinterface_stpvlan_idx
stpvlan
Edit
Foreign Keys
Relation
Column
Referenced Column
public.node
nodeid
nodeid
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.