Public.stpinterface (table)
From dbscript Online Help
Contents |
wikibot
| Table | public.stpinterface |
Columns
| 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
| Primary Key | Columns |
| pk_stpinterface | nodeid, bridgeport, stpvlan |
Indexes
| Index | Type | Columns |
| stpinterface_node_idx | nodeid | |
| stpinterface_node_ifindex_idx | nodeid, ifindex | |
| stpinterface_stpdesbridge_idx | stpportdesignatedbridge | |
| stpinterface_stpvlan_idx | stpvlan |
Foreign Keys
| Relation | Column | Referenced Column |
| public.node | nodeid | nodeid |
