Woozle: Created page with "==About== * '''Purpose''': units in stock * '''Adapted from''': VbzCart/tables/stk items ==SQL== CREATE TABLE `items` ( `ID` INT NOT NULL AUTO_..."

2013-03-09T16:24:17Z

Created page with "==About== * '''Purpose''': units in stock * '''Adapted from''': VbzCart/tables/stk items ==SQL== <mysql> CREATE TABLE `items` ( `ID` INT NOT NULL AUTO_..."

New page

==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>

User:Woozle/StockFerret/units - Revision history

Woozle: Created page with "==About== * '''Purpose''': units in stock * '''Adapted from''': VbzCart/tables/stk items ==SQL== CREATE TABLE `items` ( `ID` INT NOT NULL AUTO_..."