Public.node (table)

wikibot

Table

public.node

Column	Data Type	Nullable	Default	PK	Index
nodeid	integer	not null		pk_nodeid	node_id_type_idx
dpname	varchar(12)	null			node_dpname_idx
nodecreatetime	timestamp with time zone	not null
nodeparentid	integer	null
nodetype	char(1)	null			node_id_type_idx
nodesysoid	varchar(256)	null
nodesysname	varchar(256)	null
nodesysdescription	varchar(256)	null
nodesyslocation	varchar(256)	null
nodesyscontact	varchar(256)	null
nodelabel	varchar(256)	null			node_label_idx
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			node_foreign_unique_idx
foreignid	varchar(64)	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