From dbscript Online Help
wikibot
| Table
|
public.stpinterface
|
| Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
| nodeid
|
integer
|
not null
|
|
pk_stpinterface
|
stpinterface_node_idxstpinterface_node_ifindex_idx
|
| bridgeport
|
integer
|
not null
|
|
pk_stpinterface
|
|
| ifindex
|
integer
|
not null
|
|
|
stpinterface_node_ifindex_idx
|
| stpportstate
|
integer
|
null
|
|
|
|
| stpportpathcost
|
integer
|
null
|
|
|
|
| stpportdesignatedroot
|
varchar(16)
|
null
|
|
|
|
| stpportdesignatedcost
|
integer
|
null
|
|
|
|
| stpportdesignatedbridge
|
varchar(16)
|
null
|
|
|
stpinterface_stpdesbridge_idx
|
| stpportdesignatedport
|
varchar(4)
|
null
|
|
|
|
| status
|
char(1)
|
not null
|
|
|
|
| lastpolltime
|
timestamp without time zone
|
not null
|
|
|
|
| stpvlan
|
integer
|
not null
|
|
pk_stpinterface
|
stpinterface_stpvlan_idx
|
| Relation
|
Column
|
Referenced Column
|
| public.node
|
nodeid
|
nodeid
|
