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...") |
(changing design - any place can be a bin if it has a bin record) |
||
| (One intermediate revision by the same user not shown) | |||
| 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 ` | + | 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>