ScrewTurn Wiki

Tablepublic.inventory

Edit

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  

Edit

Indexes

IndexTypeColumns
inventory_lastpolltime_idx lastpolltime
inventory_nodeid_idx nodeid
inventory_nodeid_name_idx nodeid, name
inventory_status_idx status

Edit

Foreign Keys

RelationColumnReferenced Column
public.nodenodeidnodeid

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