Welcome Guest, you are in: <root> • Login

Page History: public inventory (table)

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 2010/02/11 09:23

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