User:Woozle/StockFerret/bins

About

• Purpose: containers where stock items may be kept directly (without being surrounded by any additional levels of container)
• Adapted from: VbzCart/tables/stk bins

SQL

<mysql> CREATE TABLE `bins` (

 `ID`           INT(11)     NOT NULL auto_increment,
 `ID_Place`     INT(11)     NOT NULL COMMENT "places.ID",
 `Code`     VARCHAR(15)     NOT NULL COMMENT "code name meaningful to user -- can be barcode or just something written on the box",
 `Descr`    VARCHAR(63) DEFAULT NULL COMMENT 'brief summary of contents or container',
 `WhenCreated` DATETIME DEFAULT NULL COMMENT 'date when container was added to the database',
 `WhenVoided`  DATETIME DEFAULT NULL COMMENT 'date when container was destroyed or removed from usage',
 `WhenTainted` DATETIME DEFAULT NULL COMMENT "if NOT NULL, this bin needs re-inventorying",
 `WhenCounted` DATETIME DEFAULT NULL COMMENT "timestamp of when bin's contents were last inventoried",
 `Notes`           TEXT,
 PRIMARY KEY (`ID`)

) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1; </mysql>