public node (table)

Modified on 2011/08/27 11:44 by wikibot Categorized as Uncategorized
== wikibot ==

{| 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
| &nbsp;
| &nbsp;
|- valign="top"
| dpname
| varchar(12)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| nodecreatetime
| timestamp with time zone
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| nodeparentid
| integer
| null
| &nbsp;
| &nbsp;
|- valign="top"
| nodetype
| char(1)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| nodesysoid
| varchar(256)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| nodesysname
| varchar(256)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| nodesysdescription
| varchar(256)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| nodesyslocation
| varchar(256)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| nodesyscontact
| varchar(256)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| nodelabel
| varchar(256)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| nodelabelsource
| char(1)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| nodenetbiosname
| varchar(16)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| nodedomainname
| varchar(16)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| operatingsystem
| varchar(64)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| lastcapsdpoll
| timestamp with time zone
| null
| &nbsp;
| &nbsp;
|- valign="top"
| foreignsource
| varchar(64)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| foreignid
| varchar(64)
| null
| &nbsp;
| &nbsp;
|}

=== 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
| &nbsp;
| dpname
|- valign="top"
| node_foreign_unique_idx
| &nbsp;
| foreignsource, foreignid
|- valign="top"
| node_id_type_idx
| &nbsp;
| nodeid, nodetype
|- valign="top"
| node_label_idx
| &nbsp;
| 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
|}
devio dbscript ScrewTurn Wiki

Navigation¶

public node (table)
