public inventory (table)

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