From dbscript Online Help
wikibot
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
|
