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.stpnode_(table)
Print
RSS
Modified: 2011/08/27 10:41 by
wikibot
-
Uncategorized
»
public.stpnode_(table)
[X]
»
public.stpnode_(table)
Table
public.stpnode
Edit
Columns
Column
Data Type
Nullable
Default
Description
nodeid
integer
not null
basebridgeaddress
varchar(12)
not null
basenumports
integer
null
basetype
integer
null
stpprotocolspecification
integer
null
stppriority
integer
null
stpdesignatedroot
varchar(16)
null
stprootcost
integer
null
stprootport
integer
null
status
char(1)
not null
lastpolltime
timestamp without time zone
not null
basevlan
integer
not null
basevlanname
varchar(32)
null
Edit
Primary Key
Primary Key
Columns
pk_stpnode
nodeid, basevlan
Edit
Indexes
Index
Type
Columns
stpnode_basebridgeaddress_idx
basebridgeaddress
stpnode_nodeid_idx
nodeid
stpnode_stpdesignatedroot_idx
stpdesignatedroot
Edit
Foreign Keys
Relation
Column
Referenced Column
public.node
nodeid
nodeid
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.