VbzCart/docs/tables/ stk containers: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
(not used; use the query instead)
m (Woozle moved page VbzCart/VbzCart/tables/ stk containers to VbzCart/docs/tables/ stk containers without leaving a redirect: part 3/5)
 
(No difference)

Latest revision as of 01:56, 25 February 2024

About

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

SQL

<section begin=sql /><mysql>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;</mysql>

<section end=sql />

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/tables/_stk_containers&oldid=6850"