VbzCart/tables/rstk req item - Revision history

Woozle at 15:52, 28 December 2019

2019-12-28T15:52:24Z

← Older revision		Revision as of 15:52, 28 December 2019
Line 1:		Line 1:
			[[category:VbzCart/tables]]
	==About==		==About==
	~~[[category:VbzCart/tables]]~~
	* '''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` INT COMMENT "rstk_req.ID of request to which this item belongs",		`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 = ~~MYISAM~~;</~~mysql~~>		ENGINE = InnoDB;</source>

Woozle: removed old TODO renaming (it was already done) and replaced it with a new one

2016-01-15T19:32:20Z

removed old TODO renaming (it was already done) and replaced it with a new one

← Older revision		Revision as of 19:32, 15 January 2016
Line 2:		Line 2:
	[[category:VbzCart/tables]]		[[category:VbzCart/tables]]
	* '''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 '''~~ID_Restock~~''' field to '''~~ID_Request~~''' (~~same needs to be done with {{l/same\|rstk_rcd}}~~)		* '''Future''': Rename '''QtyOrd''' field to '''QtyReq''' (quantity requested).
	* '''History''':		* '''History''':
	** '''2008-11-07''' Created for new restock process		** '''2008-11-07''' Created for new restock process

Woozle: ID_Restock -> ID_Parent

2016-01-07T13:04:28Z

ID_Restock -> ID_Parent

← Older revision		Revision as of 13:04, 7 January 2016
Line 7:		Line 7:
	** '''2008-12-04''' Added '''QtyCust''' field to make it easier to tell how much immediate revenue a restock is likely to generate		** '''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.		** '''2014-12-14''' Changed '''isGone''' from BOOL (which apparently equates to TINYINT) to BIT.
			** '''2016-01-07''' Changed '''ID_Restock''' to '''ID_Parent'''
	* '''Notes''':		* '''Notes''':
	** replaces part of {{vbzcart\|table\|rstk_lines}}		** replaces part of {{vbzcart\|table\|rstk_lines}}
	==SQL==		==SQL==
	<mysql>CREATE TABLE `rstk_req_item` (		<mysql>CREATE TABLE `rstk_req_item` (
	`~~ID_Restock~~` INT COMMENT "rstk_req.ID of ~~restock~~ this item belongs to",		`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",

Woozle: future note

2016-01-01T01:51:56Z

future note

← Older revision		Revision as of 01:51, 1 January 2016
Line 2:		Line 2:
	[[category:VbzCart/tables]]		[[category:VbzCart/tables]]
	* '''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 '''ID_Restock''' field to '''ID_Request''' (same needs to be done with {{l/same\|rstk_rcd}})
	* '''History''':		* '''History''':
	** '''2008-11-07''' Created for new restock process		** '''2008-11-07''' Created for new restock process
Line 7:		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.
	* '''Notes''':		* '''Notes''':
	** replaces part of {{vbzcart/table\|rstk_lines}}		** replaces part of {{vbzcart\|table\|rstk_lines}}
	==SQL==		==SQL==
	<mysql>CREATE TABLE `rstk_req_item` (		<mysql>CREATE TABLE `rstk_req_item` (

Woozle: tidied obsolete markup; changed isGone

2014-12-14T23:17:30Z

tidied obsolete markup; changed isGone

← Older revision		Revision as of 23:17, 14 December 2014
Line 5:		Line 5:
	** '''2008-11-07''' Created for new restock process		** '''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		** '''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.
	* '''Notes''':		* '''Notes''':
	** replaces part of {{vbzcart/table\|rstk_lines}}		** replaces part of {{vbzcart/table\|rstk_lines}}
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>CREATE TABLE `rstk_req_item` (		<mysql>CREATE TABLE `rstk_req_item` (
	`ID_Restock` INT COMMENT "rstk_req.ID of restock this item belongs to",		`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",
Line 20:		Line 21:
	`QtyOrd` INT COMMENT "quantity actually ordered from supplier",		`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",		`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)",		`isGone` BIT COMMENT "YES = item discontinued, no more available (if info from source other than invoice)",
	/* cost information */		/* cost information */
	`CostExpPer` DECIMAL(9,2) COMMENT "expected per-item cost",		`CostExpPer` DECIMAL(9,2) COMMENT "expected per-item cost",
Line 27:		Line 28:
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~

Woozle: minor doc correction

2009-12-14T17:05:51Z

minor doc correction

← Older revision		Revision as of 17:05, 14 December 2009
Line 1:		Line 1:
	==About==		==About==
	[[category:VbzCart/tables]]		[[category:VbzCart/tables]]
	* '''Purpose''': Stores requested restock contents by item; planned distribution to customers is in ~~[[../rstk_ord_lines]]~~		* '''Purpose''': Stores requested restock contents by item; planned distribution to customers is in {{vbzcart\|table\|rstk_ord_line}}
	* '''History''':		* '''History''':
	** '''2008-11-07''' Created for new restock process		** '''2008-11-07''' Created for new restock process

Woozle: Reverted edits by 62.159.143.172 (Talk); changed back to last version by Woozle

2009-06-18T23:45:54Z

Reverted edits by 62.159.143.172 (Talk); changed back to last version by Woozle

← Older revision		Revision as of 23:45, 18 June 2009
Line 1:		Line 1:
	~~Ep37OI hfN2cnPosa82GhrpCayYr~~		==About==
			[[category:VbzCart/tables]]
			* '''Purpose''': Stores requested restock contents by item; planned distribution to customers is in [[../rstk_ord_lines]]
			* '''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
			* '''Notes''':
			** replaces part of {{vbzcart/table\|rstk_lines}}
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `rstk_req_item` (		<section begin=sql /><mysql>CREATE TABLE `rstk_req_item` (

62.159.143.172: /* About */

2009-06-18T23:09:47Z

About

← Older revision		Revision as of 23:09, 18 June 2009
Line 1:		Line 1:
	~~==About==~~		Ep37OI hfN2cnPosa82GhrpCayYr
	~~[[category:VbzCart/tables]]~~
	* '''Purpose''': Stores requested restock contents by item; planned distribution to customers is in [[../rstk_ord_lines]]
	* '''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
	* '''Notes''':
	** replaces part of {{vbzcart/table\|rstk_lines}}
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `rstk_req_item` (		<section begin=sql /><mysql>CREATE TABLE `rstk_req_item` (

Woozle: +QtyCust; tidied documentation

2008-12-04T23:04:01Z

+QtyCust; tidied documentation

← Older revision		Revision as of 23:04, 4 December 2008
Line 1:		Line 1:
	==About==		==About==
	[[category:VbzCart/tables]]		[[category:VbzCart/tables]]
	* '''~~Created~~''': ~~2008-11-07~~		* '''Purpose''': Stores requested restock contents by item; planned distribution to customers is in [[../rstk_ord_lines]]
	* To replace old [[../rstk_lines]] after data is migrated		* '''History''':
	* Records requested restock contents by item; planned distribution to customers is in [[../rstk_ord_lines]]		** '''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
			* '''Notes''':
			** replaces part of {{vbzcart/table\|rstk_lines}}
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `rstk_req_item` (		<section begin=sql /><mysql>CREATE TABLE `rstk_req_item` (
Line 14:		Line 17:
	/* quantities - data from creation of restock */		/* quantities - data from creation of restock */
	`QtyNeed` INT COMMENT "quantity needed, either for an order or to keep stock at desired level",		`QtyNeed` INT COMMENT "quantity needed, either for an order or to keep stock at desired level",
	`QtyOrd` INT COMMENT "quantity actually ordered",		`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",		`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)",		`isGone` BOOL COMMENT "YES = item discontinued, no more available (if info from source other than invoice)",

Woozle: /* SQL */ no ID field; index only on restock & item IDs

2008-11-09T00:35:25Z

SQL: no ID field; index only on restock & item IDs

← Older revision		Revision as of 00:35, 9 November 2008
Line 6:		Line 6:
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `rstk_req_item` (		<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_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",
Line 21:		Line 20:
	`CostExpPer` DECIMAL(9,2) COMMENT "expected per-item cost",		`CostExpPer` DECIMAL(9,2) COMMENT "expected per-item cost",
	`Notes` VARCHAR(255) COMMENT "human-entered notes on this line item",		`Notes` VARCHAR(255) COMMENT "human-entered notes on this line item",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID_Restock`,`ID_Item`)
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />