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_dpname_idx		dpname
node_foreign_unique_idx	Unique	foreignsource, foreignid
node_id_type_idx		nodeid, nodetype
node_label_idx		nodelabel

Foreign Keys

Relation	Column	Referenced Column
public.distpoller	dpname	dpname
public.node	nodeid	nodeid
public.node	nodeid	nodeid
public.node	nodeid	nodeid
public.node	nodeid	nodeid
public.node	nodeid	nodeid
public.node	nodeparentid	nodeid
public.node	nodeid	nodeid
public.node	nodeid	nodeid
public.node	nodeid	nodeid
public.node	nodeid	nodeid
public.node	nodeid	nodeid
public.node	nodeid	nodeid
public.node	nodeid	nodeid
public.node	nodeid	nodeid
public.node	nodeid	nodeid
public.node	nodeid	nodeid

Dependencies

Reference Type	Object Type	Referencing Object
Select	Function	public.getmanagedoutagefornodeinwindow