## The HINVENTORY table is used to store information about the physical # inventory of a machine. (Hard Drive size and type, network card etc..)## _rowid       Is a positive integer, unique within this table that is#              used to identify a specific row in the table.# created      Timestamp of when this entry was created.# modified     Timestamp of when this entry was last modified.# item         The _rowid of the item from the hitems table of this item.#              This is where the description, vendor, model # comes from#              This will allow reporting on the # of a given item in use. # host         The _rowid of the host that this item belongs to.# serial       The serial # of this item.# installed    The date this was installed.# removed      The date this item was removed. (NULL == Still installed.)#create TABLE hinventory (   _rowid      int not null,   created     char(20),   modified    char(20),   item        int,   host        int,   serial      char(40),   installed   char(20),   removed     char(20),   primary key (_rowid),   foreign key (item) references hitems,   foreign key (host) references host);