User:Woozle/StockFerret/bins: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Created page with "==About== * '''Purpose''': containers where stock items may be kept directly (without being surrounded by any additional levels of container) * '''Adapted from''': [[VbzCart/t..." |
CREATE TABLE name correction |
||
| Line 4: | Line 4: | ||
==SQL== | ==SQL== | ||
<mysql> | <mysql> | ||
CREATE TABLE ` | CREATE TABLE `bins` ( | ||
`ID` INT(11) NOT NULL auto_increment, | `ID` INT(11) NOT NULL auto_increment, | ||
`ID_Place` INT(11) NOT NULL COMMENT "places.ID", | `ID_Place` INT(11) NOT NULL COMMENT "places.ID", | ||
Revision as of 02:48, 9 March 2013
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>
