Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

Tablepublic.stpinterface

Columns

ColumnData TypeNullableDefaultDescription
nodeidintegernot null  
bridgeportintegernot null  
ifindexintegernot null  
stpportstateintegernull  
stpportpathcostintegernull  
stpportdesignatedrootvarchar(16)null  
stpportdesignatedcostintegernull  
stpportdesignatedbridgevarchar(16)null  
stpportdesignatedportvarchar(4)null  
statuschar(1)not null  
lastpolltimetimestamp without time zonenot null  
stpvlanintegernot null  

Primary Key

Primary KeyColumns
pk_stpinterfacenodeid, bridgeport, stpvlan

Indexes

IndexTypeColumns
stpinterface_node_idx nodeid
stpinterface_node_ifindex_idx nodeid, ifindex
stpinterface_stpdesbridge_idx stpportdesignatedbridge
stpinterface_stpvlan_idx stpvlan

Foreign Keys

RelationColumnReferenced Column
public.nodenodeidnodeid

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.