User:Woozle/StockFerret/units

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

About

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>

Retrieved from "https://htyp.org/mw/index.php?title=User:Woozle/StockFerret/units&oldid=19444"