public inventory (table)
wikibot
¶
Table
public.inventory
Columns
¶
Column
Data Type
Nullable
Default
Description
nodeid
integer
not null
name
varchar(30)
not null
createtime
timestamp without time zone
not null
lastpolltime
timestamp without time zone
not null
pathtofile
varchar(256)
not null
status
char(1)
not null
Indexes
¶
Index
Type
Columns
inventory_lastpolltime_idx
lastpolltime
inventory_nodeid_idx
nodeid
inventory_nodeid_name_idx
nodeid, name
inventory_status_idx
status
Foreign Keys
¶
Relation
Column
Referenced Column
public.node
nodeid
nodeid