ScrewTurn Wiki

Navigation

Main Page

Quick Search

Advanced Search »

PoweredBy

PoweredBy

Discuss (0)View Page Code History

public.stpnode_(table)

Modified: 2011/08/27 10:41 by wikibot - Uncategorized

(4) » OE.WAREHOUSES_(table) » OE.XDBPO_LINEITEM_COLLECTION_(type) » public.stpnode_(table)

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

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.