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 »
Back
History
public.node_(table)
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | public.node |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | nodeid | integer | not null | | |- valign="top" | dpname | varchar(12) | null | | |- valign="top" | nodecreatetime | timestamp with time zone | not null | | |- valign="top" | nodeparentid | integer | null | | |- valign="top" | nodetype | char(1) | null | | |- valign="top" | nodesysoid | varchar(256) | null | | |- valign="top" | nodesysname | varchar(256) | null | | |- valign="top" | nodesysdescription | varchar(256) | null | | |- valign="top" | nodesyslocation | varchar(256) | null | | |- valign="top" | nodesyscontact | varchar(256) | null | | |- valign="top" | nodelabel | varchar(256) | null | | |- valign="top" | nodelabelsource | char(1) | null | | |- valign="top" | nodenetbiosname | varchar(16) | null | | |- valign="top" | nodedomainname | varchar(16) | null | | |- valign="top" | operatingsystem | varchar(64) | null | | |- valign="top" | lastcapsdpoll | timestamp with time zone | null | | |- valign="top" | foreignsource | varchar(64) | null | | |- valign="top" | foreignid | varchar(64) | null | | |} === Primary Key === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Primary Key''' | '''Columns''' |- valign="top" | pk_nodeid | nodeid |} === Indexes === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Index''' | '''Type''' | '''Columns''' |- valign="top" | node_dpname_idx | | dpname |- valign="top" | node_foreign_unique_idx | | foreignsource, foreignid |- valign="top" | node_id_type_idx | | nodeid, nodetype |- valign="top" | node_label_idx | | nodelabel |} === Foreign Keys === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Relation''' | '''Column''' | '''Referenced Column''' |- valign="top" | [[public.distpoller_(table)|public.distpoller]] | dpname | dpname |} === Detail Tables === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Detail Table''' | '''Column''' | '''Referencing Column''' |- valign="top" | [[public.atinterface_(table)|public.atinterface]] | nodeid | nodeid |- valign="top" | [[public.stpnode_(table)|public.stpnode]] | nodeid | nodeid |- valign="top" | [[public.stpinterface_(table)|public.stpinterface]] | nodeid | nodeid |- valign="top" | [[public.iprouteinterface_(table)|public.iprouteinterface]] | nodeid | nodeid |- valign="top" | [[public.datalinkinterface_(table)|public.datalinkinterface]] | nodeid | nodeid |- valign="top" | [[public.datalinkinterface_(table)|public.datalinkinterface]] | nodeid | nodeparentid |- valign="top" | [[public.inventory_(table)|public.inventory]] | nodeid | nodeid |- valign="top" | [[public.vlan_(table)|public.vlan]] | nodeid | nodeid |- valign="top" | [[public.ipinterface_(table)|public.ipinterface]] | nodeid | nodeid |- valign="top" | [[public.snmpinterface_(table)|public.snmpinterface]] | nodeid | nodeid |- valign="top" | [[public.ifservices_(table)|public.ifservices]] | nodeid | nodeid |- valign="top" | [[public.outages_(table)|public.outages]] | nodeid | nodeid |- valign="top" | [[public.assets_(table)|public.assets]] | nodeid | nodeid |- valign="top" | [[public.notifications_(table)|public.notifications]] | nodeid | nodeid |- valign="top" | [[public.pathoutage_(table)|public.pathoutage]] | nodeid | nodeid |- valign="top" | [[public.category_node_(table)|public.category_node]] | nodeid | nodeid |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.