Public.inventory (table)

From dbscript Online Help

Contents 1 wikibot 1.1 Columns 1.2 Indexes 1.3 Foreign Keys

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