Public.node (table)

wikibot

Table

public.node

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

Primary Key

Primary Key	Columns
pk_nodeid	nodeid

Indexes

Index	Type	Columns
node_foreign_unique_idx	Unique	foreignsource, foreignid
node_dpname_idx		dpname
node_id_type_idx		nodeid, nodetype
node_label_idx		nodelabel

Foreign Keys

Relation	Column	Referenced Column
public.distpoller	dpname	dpname

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

Dependencies

Reference Type	Object Type	Referencing Object
Select	Function	public.getmanagedoutagefornodeinwindow