Difference between revisions of "User:Woozle/StockFerret/bins"
< User:Woozle | StockFerret
Jump to navigation
Jump to search
(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>