VbzCart/docs/tables/rstk req item: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (removed old TODO renaming (it was already done) and replaced it with a new one) |
imported>Woozle No edit summary |
||
| Line 1: | Line 1: | ||
[[category:VbzCart/tables]] | |||
==About== | ==About== | ||
* '''Purpose''': Stores requested restock contents by item; planned distribution to customers is in {{vbzcart|table|rstk_ord_line}} | * '''Purpose''': Stores requested restock contents by item; planned distribution to customers is in {{vbzcart|table|rstk_ord_line}} | ||
* '''Future''': Rename '''QtyOrd''' field to '''QtyReq''' (quantity requested). | * '''Future''': Rename '''QtyOrd''' field to '''QtyReq''' (quantity requested). | ||
| Line 8: | Line 8: | ||
** '''2014-12-14''' Changed '''isGone''' from BOOL (which apparently equates to TINYINT) to BIT. | ** '''2014-12-14''' Changed '''isGone''' from BOOL (which apparently equates to TINYINT) to BIT. | ||
** '''2016-01-07''' Changed '''ID_Restock''' to '''ID_Parent''' | ** '''2016-01-07''' Changed '''ID_Restock''' to '''ID_Parent''' | ||
** '''2019-12-28''' changed ENGINE from MyISAM to InnoDB | |||
* '''Notes''': | * '''Notes''': | ||
** replaces part of {{vbzcart|table|rstk_lines}} | ** replaces part of {{vbzcart|table|rstk_lines}} | ||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `rstk_req_item` ( | <source lang=mysql>CREATE TABLE `rstk_req_item` ( | ||
`ID_Parent` | `ID_Parent` INT COMMENT "rstk_req.ID of request to which this item belongs", | ||
`ID_Item` INT COMMENT "cat_items.ID of item being restocked", | `ID_Item` INT COMMENT "cat_items.ID of item being restocked", | ||
`Descr` VARCHAR(255) DEFAULT NULL COMMENT "Item description as given at time of shopping", | `Descr` VARCHAR(255) DEFAULT NULL COMMENT "Item description as given at time of shopping", | ||
| Line 29: | Line 30: | ||
PRIMARY KEY(`ID_Restock`,`ID_Item`) | PRIMARY KEY(`ID_Restock`,`ID_Item`) | ||
) | ) | ||
ENGINE = | ENGINE = InnoDB;</source> | ||
Revision as of 15:52, 28 December 2019
About
- Purpose: Stores requested restock contents by item; planned distribution to customers is in Template:Vbzcart
- Future: Rename QtyOrd field to QtyReq (quantity requested).
- History:
- 2008-11-07 Created for new restock process
- 2008-12-04 Added QtyCust field to make it easier to tell how much immediate revenue a restock is likely to generate
- 2014-12-14 Changed isGone from BOOL (which apparently equates to TINYINT) to BIT.
- 2016-01-07 Changed ID_Restock to ID_Parent
- 2019-12-28 changed ENGINE from MyISAM to InnoDB
- Notes:
- replaces part of Template:Vbzcart
SQL
CREATE TABLE `rstk_req_item` (
`ID_Parent` INT COMMENT "rstk_req.ID of request to which this item belongs",
`ID_Item` INT COMMENT "cat_items.ID of item being restocked",
`Descr` VARCHAR(255) DEFAULT NULL COMMENT "Item description as given at time of shopping",
/* timestamps */
`WhenCreated` DATETIME DEFAULT NULL COMMENT "when this line was added",
`WhenVoided` DATETIME DEFAULT NULL COMMENT "when this line was voided; not NULL = ignore this line",
/* quantities - data from creation of restock */
`QtyNeed` INT COMMENT "quantity needed, either for an order or to keep stock at desired level",
`QtyCust` INT COMMENT "quantity needed just to fill customer orders",
`QtyOrd` INT COMMENT "quantity actually ordered from supplier",
`QtyExp` INT COMMENT "quantity actually expected, if supplier doesn't have enough available to fill the order",
`isGone` BIT COMMENT "YES = item discontinued, no more available (if info from source other than invoice)",
/* cost information */
`CostExpPer` DECIMAL(9,2) COMMENT "expected per-item cost",
`Notes` VARCHAR(255) COMMENT "human-entered notes on this line item",
PRIMARY KEY(`ID_Restock`,`ID_Item`)
)
ENGINE = InnoDB;