Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

Tablepublic.inventory

Columns

ColumnData TypeNullableDefaultDescription
nodeidintegernot null  
namevarchar(30)not null  
createtimetimestamp without time zonenot null  
lastpolltimetimestamp without time zonenot null  
pathtofilevarchar(256)not null  
statuschar(1)not null  

Indexes

IndexTypeColumns
inventory_lastpolltime_idx lastpolltime
inventory_nodeid_idx nodeid
inventory_nodeid_name_idx nodeid, name
inventory_status_idx status

Foreign Keys

RelationColumnReferenced Column
public.nodenodeidnodeid

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.