Public.stpnode (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table public.stpnode

Columns[edit]

Column Data Type Nullable Default Description
nodeid integer not null
basebridgeaddress varchar(12) not null
basenumports integer null
basetype integer null
stpprotocolspecification integer null
stppriority integer null
stpdesignatedroot varchar(16) null
stprootcost integer null
stprootport integer null
status char(1) not null
lastpolltime timestamp without time zone not null
basevlan integer not null
basevlanname varchar(32) null

Primary Key[edit]

Primary Key Columns
pk_stpnode nodeid, basevlan

Indexes[edit]

Index Type Columns
stpnode_basebridgeaddress_idx basebridgeaddress
stpnode_nodeid_idx nodeid
stpnode_stpdesignatedroot_idx stpdesignatedroot

Foreign Keys[edit]

Relation Column Referenced Column
public.node nodeid nodeid