VbzCart/docs/tables/ stk containers: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (New page: ==About== * '''Purpose''': Aggregate table listing all places where stock can be, mainly for the history table * '''Fields''': ** '''Name''': auto-generated but hopefully somewhat descript...) |
imported>Woozle (not used; use the query instead) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': Aggregate table listing all places where stock can be, mainly for the history table | * '''Purpose''': Aggregate table listing all places where stock can be, mainly for the history table | ||
* '''Status''': NOT USED; use {{vbzcart/query|qryStock_containers}} instead | |||
* '''Fields''': | * '''Fields''': | ||
** '''Name''': auto-generated but hopefully somewhat descriptive and human-readable name for this container | ** '''Name''': auto-generated but hopefully somewhat descriptive and human-readable name for this container | ||
Revision as of 11:19, 9 March 2009
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 />