public stpinterface (table)
wikibot
¶
Table
public.stpinterface
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
Primary Key
¶
Primary Key
Columns
pk_stpinterface
nodeid, bridgeport, stpvlan
Indexes
¶
Index
Type
Columns
stpinterface_node_idx
nodeid
stpinterface_node_ifindex_idx
nodeid, ifindex
stpinterface_stpdesbridge_idx
stpportdesignatedbridge
stpinterface_stpvlan_idx
stpvlan
Foreign Keys
¶
Relation
Column
Referenced Column
public.node
nodeid
nodeid