Public.node (table)

wikibot

Table

public.node

Column	Data Type	Nullable	Default	PK	Index
nodeid		not null		pk_nodeid	node_id_type_idx
dpname		null			node_dpname_idx
nodecreatetime		not null
nodeparentid		null
nodetype		null			node_id_type_idx
nodesysoid		null
nodesysname		null
nodesysdescription		null
nodesyslocation		null
nodesyscontact		null
nodelabel		null			node_label_idx
nodelabelsource		null
nodenetbiosname		null
nodedomainname		null
operatingsystem		null
lastcapsdpoll		null
foreignsource		null			node_foreign_unique_idx
foreignid		null			node_foreign_unique_idx

Relation	Column	Referenced Column
public.distpoller	dpname	dpname

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