Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: public inventory (table)

Compare Page Revisions



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


Page Revision: 2010/02/11 09:23


wikibot

Tablepublic.inventory

Columns

ColumnData TypeNullableDefaultDescription
nodeidintegernot null  
namevarchar(30)not null  
createtimetimestamp without time zonenot null  
lastpolltimetimestamp without time zonenot null  
pathtofilevarchar(256)not null  
statuschar(1)not null  

Indexes

IndexTypeColumns
inventory_lastpolltime_idx lastpolltime
inventory_nodeid_idx nodeid
inventory_nodeid_name_idx nodeid, name
inventory_status_idx status

Foreign Keys

RelationColumnReferenced Column
public.nodenodeidnodeid

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.