From dbscript Online Help
wikibot
| Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
| nodeid
|
integer
|
not null
|
|
pk_stpnode
|
stpnode_nodeid_idx
|
| basebridgeaddress
|
varchar(12)
|
not null
|
|
|
stpnode_basebridgeaddress_idx
|
| basenumports
|
integer
|
null
|
|
|
|
| basetype
|
integer
|
null
|
|
|
|
| stpprotocolspecification
|
integer
|
null
|
|
|
|
| stppriority
|
integer
|
null
|
|
|
|
| stpdesignatedroot
|
varchar(16)
|
null
|
|
|
stpnode_stpdesignatedroot_idx
|
| stprootcost
|
integer
|
null
|
|
|
|
| stprootport
|
integer
|
null
|
|
|
|
| status
|
char(1)
|
not null
|
|
|
|
| lastpolltime
|
timestamp without time zone
|
not null
|
|
|
|
| basevlan
|
integer
|
not null
|
|
pk_stpnode
|
|
| basevlanname
|
varchar(32)
|
null
|
|
|
|
| Relation
|
Column
|
Referenced Column
|
| public.node
|
nodeid
|
nodeid
|
