Public.stpinterface (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table public.stpinterface

Columns[edit]

Column Data Type Nullable Default Description
nodeid integer not null
bridgeport integer not null
ifindex integer not null
stpportstate integer null
stpportpathcost integer null
stpportdesignatedroot varchar(16) null
stpportdesignatedcost integer null
stpportdesignatedbridge varchar(16) null
stpportdesignatedport varchar(4) null
status char(1) not null
lastpolltime timestamp without time zone not null
stpvlan integer not null

Primary Key[edit]

Primary Key Columns
pk_stpinterface nodeid, bridgeport, stpvlan

Indexes[edit]

Index Type Columns
stpinterface_node_idx nodeid
stpinterface_node_ifindex_idx nodeid, ifindex
stpinterface_stpdesbridge_idx stpportdesignatedbridge
stpinterface_stpvlan_idx stpvlan

Foreign Keys[edit]

Relation Column Referenced Column
public.node nodeid nodeid