ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
public.node_(table)
Print
RSS
Modified: 2011/08/27 10:41 by
wikibot
-
Uncategorized
»
public.node_(table)
[X]
»
public.node_(table)
Table
public.node
Edit
Columns
Column
Data Type
Nullable
Default
Description
nodeid
integer
not null
dpname
varchar(12)
null
nodecreatetime
timestamp with time zone
not null
nodeparentid
integer
null
nodetype
char(1)
null
nodesysoid
varchar(256)
null
nodesysname
varchar(256)
null
nodesysdescription
varchar(256)
null
nodesyslocation
varchar(256)
null
nodesyscontact
varchar(256)
null
nodelabel
varchar(256)
null
nodelabelsource
char(1)
null
nodenetbiosname
varchar(16)
null
nodedomainname
varchar(16)
null
operatingsystem
varchar(64)
null
lastcapsdpoll
timestamp with time zone
null
foreignsource
varchar(64)
null
foreignid
varchar(64)
null
Edit
Primary Key
Primary Key
Columns
pk_nodeid
nodeid
Edit
Indexes
Index
Type
Columns
node_dpname_idx
dpname
node_foreign_unique_idx
foreignsource, foreignid
node_id_type_idx
nodeid, nodetype
node_label_idx
nodelabel
Edit
Foreign Keys
Relation
Column
Referenced Column
public.distpoller
dpname
dpname
Edit
Detail Tables
Detail Table
Column
Referencing Column
public.atinterface
nodeid
nodeid
public.stpnode
nodeid
nodeid
public.stpinterface
nodeid
nodeid
public.iprouteinterface
nodeid
nodeid
public.datalinkinterface
nodeid
nodeid
public.datalinkinterface
nodeid
nodeparentid
public.inventory
nodeid
nodeid
public.vlan
nodeid
nodeid
public.ipinterface
nodeid
nodeid
public.snmpinterface
nodeid
nodeid
public.ifservices
nodeid
nodeid
public.outages
nodeid
nodeid
public.assets
nodeid
nodeid
public.notifications
nodeid
nodeid
public.pathoutage
nodeid
nodeid
public.category_node
nodeid
nodeid
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.