public stpnode (table)

wikibot ¶

Table

public.stpnode

Columns ¶

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 ¶

Primary Key	Columns
pk_stpnode	nodeid, basevlan

Indexes ¶

Index	Type	Columns
stpnode_basebridgeaddress_idx		basebridgeaddress
stpnode_nodeid_idx		nodeid
stpnode_stpdesignatedroot_idx		stpdesignatedroot

Foreign Keys ¶

Relation	Column	Referenced Column
public.node	nodeid	nodeid