User:Woozle/StockFerret/units

About

• Purpose: units in stock
• Adapted from: VbzCart/tables/stk items

SQL

<mysql> CREATE TABLE `items` (

 `ID`          INT          NOT NULL AUTO_INCREMENT,
 `ID_Place`    INT      DEFAULT NULL COMMENT 'places.ID: which bin these items are in',
 `ID_Item`     INT      DEFAULT NULL COMMENT '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",
 `CatNum`   VARCHAR(63) DEFAULT NULL COMMENT "catalog number on tag (official cat# can change over time)",
  `Notes`      TEXT,
  PRIMARY KEY(`ID`)
) ENGINE = MYISAM;

</mysql>