VbzCart/docs/tables/rstk req item: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle m (VbzCart/tables/rstk line new moved to VbzCart/tables/rstk req item: reorganized naming for restock tables) |
imported>Woozle m (→SQL: updated name of table) |
||
Line 5: | Line 5: | ||
* Records requested restock contents by item; planned distribution to customers is in [[../rstk_ord_lines]] | * Records requested restock contents by item; planned distribution to customers is in [[../rstk_ord_lines]] | ||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE TABLE ` | <section begin=sql /><mysql>CREATE TABLE `rstk_req_item` ( | ||
`ID` INT NOT NULL AUTO_INCREMENT, | `ID` INT NOT NULL AUTO_INCREMENT, | ||
`ID_Restock` INT COMMENT " | `ID_Restock` INT COMMENT "rstk_req.ID of restock this item belongs to", | ||
`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", |
Revision as of 01:54, 8 November 2008
About
- Created: 2008-11-07
- To replace old VbzCart/docs/tables/rstk_lines after data is migrated
- Records requested restock contents by item; planned distribution to customers is in VbzCart/docs/tables/rstk_ord_lines
SQL
<section begin=sql /><mysql>CREATE TABLE `rstk_req_item` (
`ID` INT NOT NULL AUTO_INCREMENT, `ID_Restock` INT COMMENT "rstk_req.ID of restock this item belongs to", `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", `QtyOrd` INT COMMENT "quantity actually ordered", `QtyExp` INT COMMENT "quantity actually expected, if supplier doesn't have enough available to fill the order", `isGone` BOOL 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`) ) ENGINE = MYISAM;</mysql>
<section end=sql />