VbzCart/tables/ stk containers

From HTYP, the free directory anyone can edit

[edit] About

• Purpose: Aggregate table listing all places where stock can be, mainly for the history table
• Status: NOT USED; use qryStock_containers instead
• Fields:
  • Name: auto-generated but hopefully somewhat descriptive and human-readable name for this container

[edit] SQL

DROP TABLE IF EXISTS `_stk_containers`;
CREATE TABLE `_stk_containers` (
   `IDS` VARCHAR(31) NOT NULL COMMENT "Type + ID_forType: unique ID for this container, across all types",
   `Type` CHAR(1) NOT NULL COMMENT "identifies which type of container each record refers to",
   `ID_forType` INT NOT NULL COMMENT "record's unique ID for that type",
   `Name` VARCHAR(63) NOT NULL COMMENT "auto-generated human-readable name for this container",
   `WHEN` DATETIME COMMENT "applicable date, as a somewhat more human-readable cue for some of the container types",
   PRIMARY KEY(`IDS`)
 ) ENGINE = MYISAM;