VbzCart/tables/stk items

From HTYP, the free directory anyone can edit

Jump to: navigation, search

[edit] About

  • Purpose: listing of what is now and what used to be in stock
  • Refers to: stk_bins, cat_items

[edit] SQL

DROP TABLE IF EXISTS `stk_items`;
CREATE TABLE `stk_items` (
  `ID` INT  NOT NULL AUTO_INCREMENT,
  `ID_Bin` INT DEFAULT NULL COMMENT 'stk_bins.ID: which bin these items are in',
  `ID_Item` INT DEFAULT NULL COMMENT 'cat_items.ID: which exact type of item',
  `Qty` INT DEFAULT NULL,
  `WhenAdded` DATETIME DEFAULT NULL COMMENT 'when stock record was created for this item',
  `WhenChanged` DATETIME DEFAULT NULL COMMENT "when the quantity for this record was last altered (e.g. stock rmvd, or a split)",
  `WhenCounted` DATETIME DEFAULT NULL COMMENT "when this stock record was last verified by hand-count",
  `WhenRemoved` DATETIME DEFAULT NULL COMMENT "if not NULL, item is no longer in stock",
  `Cost` INT DEFAULT NULL COMMENT "what we paid (each) for these particular items in stock",
  `CatNum` VARCHAR(63) DEFAULT NULL COMMENT "catalog number on tag (official cat# can change over time)",
   `Notes` TEXT,
   PRIMARY KEY(`ID`)
 ) ENGINE = MYISAM;
Personal tools