Public.stpnode (table)
From dbscript Online Help
Contents |
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 |
