ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
public.inventory_(table)
Print
RSS
Modified: 2011/08/27 10:41 by
wikibot
-
Uncategorized
»
public.inventory_(table)
[X]
»
public.inventory_(table)
Table
public.inventory
Edit
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
Edit
Indexes
Index
Type
Columns
inventory_lastpolltime_idx
lastpolltime
inventory_nodeid_idx
nodeid
inventory_nodeid_name_idx
nodeid, name
inventory_status_idx
status
Edit
Foreign Keys
Relation
Column
Referenced Column
public.node
nodeid
nodeid
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.