public node (table)

wikibot

Tablepublic.node

Columns

ColumnData TypeNullableDefaultDescription
nodeidintegernot null  
dpnamevarchar(12)null  
nodecreatetimetimestamp with time zonenot null  
nodeparentidintegernull  
nodetypechar(1)null  
nodesysoidvarchar(256)null  
nodesysnamevarchar(256)null  
nodesysdescriptionvarchar(256)null  
nodesyslocationvarchar(256)null  
nodesyscontactvarchar(256)null  
nodelabelvarchar(256)null  
nodelabelsourcechar(1)null  
nodenetbiosnamevarchar(16)null  
nodedomainnamevarchar(16)null  
operatingsystemvarchar(64)null  
lastcapsdpolltimestamp with time zonenull  
foreignsourcevarchar(64)null  
foreignidvarchar(64)null  

Primary Key

Primary KeyColumns
pk_nodeidnodeid

Indexes

IndexTypeColumns
node_dpname_idx dpname
node_foreign_unique_idx foreignsource, foreignid
node_id_type_idx nodeid, nodetype
node_label_idx nodelabel

Foreign Keys

RelationColumnReferenced Column
public.distpollerdpnamedpname

Detail Tables

Detail TableColumnReferencing Column
public.atinterfacenodeidnodeid
public.stpnodenodeidnodeid
public.stpinterfacenodeidnodeid
public.iprouteinterfacenodeidnodeid
public.datalinkinterfacenodeidnodeid
public.datalinkinterfacenodeidnodeparentid
public.inventorynodeidnodeid
public.vlannodeidnodeid
public.ipinterfacenodeidnodeid
public.snmpinterfacenodeidnodeid
public.ifservicesnodeidnodeid
public.outagesnodeidnodeid
public.assetsnodeidnodeid
public.notificationsnodeidnodeid
public.pathoutagenodeidnodeid
public.category_nodenodeidnodeid