public stpnode (table)

wikibot

Tablepublic.stpnode

Columns

ColumnData TypeNullableDefaultDescription
nodeidintegernot null  
basebridgeaddressvarchar(12)not null  
basenumportsintegernull  
basetypeintegernull  
stpprotocolspecificationintegernull  
stppriorityintegernull  
stpdesignatedrootvarchar(16)null  
stprootcostintegernull  
stprootportintegernull  
statuschar(1)not null  
lastpolltimetimestamp without time zonenot null  
basevlanintegernot null  
basevlannamevarchar(32)null  

Primary Key

Primary KeyColumns
pk_stpnodenodeid, basevlan

Indexes

IndexTypeColumns
stpnode_basebridgeaddress_idx basebridgeaddress
stpnode_nodeid_idx nodeid
stpnode_stpdesignatedroot_idx stpdesignatedroot

Foreign Keys

RelationColumnReferenced Column
public.nodenodeidnodeid