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
CREATE TABLE name correction |
changing design - any place can be a bin if it has a bin record |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': | * '''Purpose''': places where stock items may be kept directly (without being surrounded by any additional levels of container) | ||
* '''Depends on''': {{l/same|places}} | |||
* '''Adapted from''': [[VbzCart/tables/stk bins]] | * '''Adapted from''': [[VbzCart/tables/stk bins]] | ||
==SQL== | ==SQL== | ||
<mysql> | <mysql> | ||
CREATE TABLE `bins` ( | CREATE TABLE `bins` ( | ||
`ID_Place` INT(11) NOT NULL COMMENT "places.ID", | `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", | `Code` VARCHAR(15) NOT NULL COMMENT "code name meaningful to user -- can be barcode or just something written on the box", | ||
| Line 14: | Line 14: | ||
`WhenCounted` DATETIME DEFAULT NULL COMMENT "timestamp of when bin's contents were last inventoried", | `WhenCounted` DATETIME DEFAULT NULL COMMENT "timestamp of when bin's contents were last inventoried", | ||
`Notes` TEXT, | `Notes` TEXT, | ||
PRIMARY KEY (` | PRIMARY KEY (`ID_Place`) | ||
) ENGINE=MyISAM | ) ENGINE=MyISAM; | ||
</mysql> | </mysql> | ||
Latest revision as of 02:52, 9 March 2013
About
- Purpose: places where stock items may be kept directly (without being surrounded by any additional levels of container)
- Depends on: places
- Adapted from: VbzCart/tables/stk bins
SQL
<mysql> CREATE TABLE `bins` (
`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_Place`)
) ENGINE=MyISAM; </mysql>
