From dbscript Online Help
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
|