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 »
Back
History
public.stpinterface_(table)
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | public.stpinterface |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | nodeid | integer | not null | | |- valign="top" | bridgeport | integer | not null | | |- valign="top" | ifindex | integer | not null | | |- valign="top" | stpportstate | integer | null | | |- valign="top" | stpportpathcost | integer | null | | |- valign="top" | stpportdesignatedroot | varchar(16) | null | | |- valign="top" | stpportdesignatedcost | integer | null | | |- valign="top" | stpportdesignatedbridge | varchar(16) | null | | |- valign="top" | stpportdesignatedport | varchar(4) | null | | |- valign="top" | status | char(1) | not null | | |- valign="top" | lastpolltime | timestamp without time zone | not null | | |- valign="top" | stpvlan | integer | not null | | |} === Primary Key === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Primary Key''' | '''Columns''' |- valign="top" | pk_stpinterface | nodeid, bridgeport, stpvlan |} === Indexes === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Index''' | '''Type''' | '''Columns''' |- valign="top" | stpinterface_node_idx | | nodeid |- valign="top" | stpinterface_node_ifindex_idx | | nodeid, ifindex |- valign="top" | stpinterface_stpdesbridge_idx | | stpportdesignatedbridge |- valign="top" | stpinterface_stpvlan_idx | | stpvlan |} === Foreign Keys === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Relation''' | '''Column''' | '''Referenced Column''' |- valign="top" | [[public.node_(table)|public.node]] | nodeid | nodeid |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.