VbzCart/tables/stk bins

From HTYP, the free directory anyone can edit

[edit] About

• Purpose: containers in which stock may be found
• Refers to: stk_places
• Fields:
  • WhenCreated can be NOT NULL if you don't have any legacy data to deal with.
  • isForShip eventually got added because I kept forgetting to use WhenVoided, and I finally decided that it wasn't redundant to have a flag specifically for this attribute. It has two meanings which may eventually need to be separated into separate fields:
    • A. FALSE = do not ship this item, even though we have it on site (why would this happen? not sure if needed)
    • B. FALSE = this bin is not physically accessible to the shipping department; items must be shipped by someone at that location or sent here to be shipped from this location. This meaning should actually be reflected by the Warehouse set in stk_places, but that's going to take a little thinking to implement that properly because it's hierarchical. Administrators operating at a given location should only be able to move items into (or out of) bins at that location. Right now, we just globally say that some bins are unreachable: not as good, but much easier to implement. Fix later.

[edit] SQL

DROP TABLE IF EXISTS `stk_bins`;
 
CREATE TABLE `stk_bins` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `ID_Place` INT(11) NOT NULL COMMENT 'stk_places.ID',
  `Code` VARCHAR(15) NOT NULL COMMENT 'code name, e.g. NC01 -- must appear on outside of box',
  `Descr` VARCHAR(63) DEFAULT NULL COMMENT 'brief summary of contents',
  `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",
  `isForSale` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is visible to customers as stock",
  `isForShip` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is available for filling orders",
  `Notes` TEXT,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;