VbzCart/tables/stk bins - Revision history

Woozle: actual table was already InnoDB

2017-09-05T13:34:32Z

actual table was already InnoDB

← Older revision		Revision as of 13:34, 5 September 2017
Line 15:		Line 15:
	* '''2015-11-17''' added '''WhenEdited''' field		* '''2015-11-17''' added '''WhenEdited''' field
	* '''2017-03-24''' deprecating '''isEnabled''' field		* '''2017-03-24''' deprecating '''isEnabled''' field
			* '''2017-09-05''' Changed MyISAM to InnoDB
	==SQL==		==SQL==
	<mysql>DROP TABLE IF EXISTS `stk_bins`;		<mysql>DROP TABLE IF EXISTS `stk_bins`;
Line 32:		Line 33:
	`Notes` TEXT,		`Notes` TEXT,
	PRIMARY KEY (`ID`)		PRIMARY KEY (`ID`)
	) ENGINE=~~MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1~~;</mysql>		) ENGINE=InnoDB;</mysql>

Woozle: referenced by stk_lines

2017-09-05T13:32:54Z

referenced by stk_lines

← Older revision		Revision as of 13:32, 5 September 2017
Line 2:		Line 2:
	* '''Purpose''': containers in which stock may be found		* '''Purpose''': containers in which stock may be found
	* '''Refers to''': {{vbzcart\|table\|stk_places}}		* '''Refers to''': {{vbzcart\|table\|stk_places}}
			* '''Referenced by''': {{l/vc/table\|stk_lines}}
	* '''Fields''':		* '''Fields''':
	** '''WhenCreated''' can be NOT NULL if you don't have any legacy data to deal with.		** '''WhenCreated''' can be NOT NULL if you don't have any legacy data to deal with.

Woozle: deprecating isEnabled

2017-03-24T12:36:33Z

deprecating isEnabled

Woozle: note about isEnabled

2016-02-24T13:08:44Z

note about isEnabled

← Older revision		Revision as of 13:08, 24 February 2016
Line 8:		Line 8:
	*** B. FALSE = this bin is not physically accessible to the shipping department; items must be shipped by someone at that location or sent here to be shipped from this location. This meaning should actually be reflected by the Warehouse set in {{vbzcart\|table\|stk_places}}, but that's going to take a little thinking to implement that properly because it's hierarchical. Administrators operating at a given location should only be able to move items into (or out of) bins ''at that location''. Right now, we just globally say that some bins are unreachable: not as good, but much easier to implement. Fix later.		*** B. FALSE = this bin is not physically accessible to the shipping department; items must be shipped by someone at that location or sent here to be shipped from this location. This meaning should actually be reflected by the Warehouse set in {{vbzcart\|table\|stk_places}}, but that's going to take a little thinking to implement that properly because it's hierarchical. Administrators operating at a given location should only be able to move items into (or out of) bins ''at that location''. Right now, we just globally say that some bins are unreachable: not as good, but much easier to implement. Fix later.
	** '''isEnabled''': TRUE = this bin is in a Place that is currently valid, usable, etc. FALSE = this bin should be treated as unshippable and unsellable even if isForShip and isForSale are marked TRUE		** '''isEnabled''': TRUE = this bin is in a Place that is currently valid, usable, etc. FALSE = this bin should be treated as unshippable and unsellable even if isForShip and isForSale are marked TRUE
			*** It looks like this was intended to be calculated from the status of the parent Place; possibly it should just be eliminated.
	* '''History''':		* '''History''':
	** '''2011-04-01''' added '''WhenCounted''' field -- for some reason, I thought this field was already here, but obviously it needs to be so we can track which bins are due for inventorying		** '''2011-04-01''' added '''WhenCounted''' field -- for some reason, I thought this field was already here, but obviously it needs to be so we can track which bins are due for inventorying

Woozle: /* SQL */ "TRUE" didn't make sense

2016-02-24T13:06:26Z

SQL: "TRUE" didn't make sense

← Older revision		Revision as of 13:06, 24 February 2016
Line 26:		Line 26:
	`isForSale` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is visible to customers as stock",		`isForSale` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is visible to customers as stock",
	`isForShip` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is available for filling orders",		`isForShip` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is available for filling orders",
	`isEnabled` TINYINT(1) DEFAULT NULL COMMENT "~~TRUE~~ = (calculated) treat as unshippable/unsellable regardless of isForSale/isForShip",		`isEnabled` TINYINT(1) DEFAULT NULL COMMENT "FALSE = (calculated) treat as unshippable/unsellable regardless of isForSale/isForShip",
	`Notes` TEXT,		`Notes` TEXT,
	PRIMARY KEY (`ID`)		PRIMARY KEY (`ID`)
	) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;</mysql>		) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;</mysql>

Woozle: WhenEdited

2015-11-07T21:03:09Z

WhenEdited

← Older revision		Revision as of 21:03, 7 November 2015
Line 11:		Line 11:
	** '''2011-04-01''' added '''WhenCounted''' field -- for some reason, I thought this field was already here, but obviously it needs to be so we can track which bins are due for inventorying		** '''2011-04-01''' added '''WhenCounted''' field -- for some reason, I thought this field was already here, but obviously it needs to be so we can track which bins are due for inventorying
	** '''2012-02-06''' added '''isEnabled''' field		** '''2012-02-06''' added '''isEnabled''' field
			** '''2015-11-17''' added '''WhenEdited''' field
	==SQL==		==SQL==
	<mysql>DROP TABLE IF EXISTS `stk_bins`;		<mysql>DROP TABLE IF EXISTS `stk_bins`;
Line 19:		Line 20:
	`Descr` VARCHAR(63) DEFAULT NULL COMMENT 'brief summary of contents',		`Descr` VARCHAR(63) DEFAULT NULL COMMENT 'brief summary of contents',
	`WhenCreated` DATETIME DEFAULT NULL COMMENT 'date when container was added to the database',		`WhenCreated` DATETIME DEFAULT NULL COMMENT 'date when container was added to the database',
			`WhenEdited` DATETIME DEFAULT NULL COMMENT 'date when container record was last edited',
	`WhenVoided` DATETIME DEFAULT NULL COMMENT 'date when container was destroyed or removed from usage',		`WhenVoided` DATETIME DEFAULT NULL COMMENT 'date when container was destroyed or removed from usage',
	`WhenTainted` DATETIME DEFAULT NULL COMMENT "if NOT NULL, this bin needs re-inventorying",		`WhenTainted` DATETIME DEFAULT NULL COMMENT "if NOT NULL, this bin needs re-inventorying",

Woozle: tidying

2014-05-11T20:32:30Z

tidying

← Older revision		Revision as of 20:32, 11 May 2014
Line 12:		Line 12:
	** '''2012-02-06''' added '''isEnabled''' field		** '''2012-02-06''' added '''isEnabled''' field
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>DROP TABLE IF EXISTS `stk_bins`;		<mysql>DROP TABLE IF EXISTS `stk_bins`;
	CREATE TABLE `stk_bins` (		CREATE TABLE `stk_bins` (
	`ID` INT(11) NOT NULL auto_increment,		`ID` INT(11) NOT NULL auto_increment,
Line 28:		Line 28:
	PRIMARY KEY (`ID`)		PRIMARY KEY (`ID`)
	) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;</mysql>		) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;</mysql>
	~~<section end=sql />~~

Woozle: isEnabled field

2012-02-06T16:46:37Z

isEnabled field

← Older revision		Revision as of 16:46, 6 February 2012
Line 7:		Line 7:
	*** A. FALSE = do not ship this item, even though we have it on site (why would this happen? not sure if needed)		*** A. FALSE = do not ship this item, even though we have it on site (why would this happen? not sure if needed)
	*** B. FALSE = this bin is not physically accessible to the shipping department; items must be shipped by someone at that location or sent here to be shipped from this location. This meaning should actually be reflected by the Warehouse set in {{vbzcart\|table\|stk_places}}, but that's going to take a little thinking to implement that properly because it's hierarchical. Administrators operating at a given location should only be able to move items into (or out of) bins ''at that location''. Right now, we just globally say that some bins are unreachable: not as good, but much easier to implement. Fix later.		*** B. FALSE = this bin is not physically accessible to the shipping department; items must be shipped by someone at that location or sent here to be shipped from this location. This meaning should actually be reflected by the Warehouse set in {{vbzcart\|table\|stk_places}}, but that's going to take a little thinking to implement that properly because it's hierarchical. Administrators operating at a given location should only be able to move items into (or out of) bins ''at that location''. Right now, we just globally say that some bins are unreachable: not as good, but much easier to implement. Fix later.
			** '''isEnabled''': TRUE = this bin is in a Place that is currently valid, usable, etc. FALSE = this bin should be treated as unshippable and unsellable even if isForShip and isForSale are marked TRUE
	* '''History''':		* '''History''':
	** '''2011-04-01''' added '''WhenCounted''' field -- for some reason, I thought this field was already here, but obviously it needs to be so we can track which bins are due for inventorying		** '''2011-04-01''' added '''WhenCounted''' field -- for some reason, I thought this field was already here, but obviously it needs to be so we can track which bins are due for inventorying
			** '''2012-02-06''' added '''isEnabled''' field
	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP TABLE IF EXISTS `stk_bins`;		<section begin=sql /><mysql>DROP TABLE IF EXISTS `stk_bins`;
Line 22:		Line 24:
	`isForSale` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is visible to customers as stock",		`isForSale` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is visible to customers as stock",
	`isForShip` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is available for filling orders",		`isForShip` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is available for filling orders",
			`isEnabled` TINYINT(1) DEFAULT NULL COMMENT "TRUE = (calculated) treat as unshippable/unsellable regardless of isForSale/isForShip",
	`Notes` TEXT,		`Notes` TEXT,
	PRIMARY KEY (`ID`)		PRIMARY KEY (`ID`)
	) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;</mysql>		) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;</mysql>
	<section end=sql />		<section end=sql />

Woozle: new field: WhenCounted; some tidying

2011-04-01T18:30:49Z

new field: WhenCounted; some tidying

← Older revision		Revision as of 18:30, 1 April 2011
Line 7:		Line 7:
	*** A. FALSE = do not ship this item, even though we have it on site (why would this happen? not sure if needed)		*** A. FALSE = do not ship this item, even though we have it on site (why would this happen? not sure if needed)
	*** B. FALSE = this bin is not physically accessible to the shipping department; items must be shipped by someone at that location or sent here to be shipped from this location. This meaning should actually be reflected by the Warehouse set in {{vbzcart\|table\|stk_places}}, but that's going to take a little thinking to implement that properly because it's hierarchical. Administrators operating at a given location should only be able to move items into (or out of) bins ''at that location''. Right now, we just globally say that some bins are unreachable: not as good, but much easier to implement. Fix later.		*** B. FALSE = this bin is not physically accessible to the shipping department; items must be shipped by someone at that location or sent here to be shipped from this location. This meaning should actually be reflected by the Warehouse set in {{vbzcart\|table\|stk_places}}, but that's going to take a little thinking to implement that properly because it's hierarchical. Administrators operating at a given location should only be able to move items into (or out of) bins ''at that location''. Right now, we just globally say that some bins are unreachable: not as good, but much easier to implement. Fix later.
			* '''History''':
			** '''2011-04-01''' added '''WhenCounted''' field -- for some reason, I thought this field was already here, but obviously it needs to be so we can track which bins are due for inventorying
	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP TABLE IF EXISTS `stk_bins`;		<section begin=sql /><mysql>DROP TABLE IF EXISTS `stk_bins`;

	CREATE TABLE `stk_bins` (		CREATE TABLE `stk_bins` (
	`ID` ~~int~~(11) NOT NULL auto_increment,		`ID` INT(11) NOT NULL auto_increment,
	`ID_Place` ~~int~~(11) NOT NULL COMMENT 'stk_places.ID',		`ID_Place` INT(11) NOT NULL COMMENT 'stk_places.ID',
	`Code` ~~varchar~~(15) NOT NULL COMMENT 'code name, e.g. NC01 -- must appear on outside of box',		`Code` VARCHAR(15) NOT NULL COMMENT 'code name, e.g. NC01 -- must appear on outside of box',
	`Descr` ~~varchar~~(63) ~~default~~ NULL COMMENT 'brief summary of contents',		`Descr` VARCHAR(63) DEFAULT NULL COMMENT 'brief summary of contents',
	`WhenCreated` ~~datetime default~~ NULL COMMENT 'date when container was added to the database',		`WhenCreated` DATETIME DEFAULT NULL COMMENT 'date when container was added to the database',
	`WhenVoided` ~~datetime default~~ NULL COMMENT 'date when container was destroyed or removed from usage',		`WhenVoided` DATETIME DEFAULT NULL COMMENT 'date when container was destroyed or removed from usage',
	`WhenTainted` ~~datetime default~~ NULL COMMENT "if NOT NULL, this bin needs re-inventorying",		`WhenTainted` DATETIME DEFAULT NULL COMMENT "if NOT NULL, this bin needs re-inventorying",
	`isForSale` ~~tinyint~~(1) ~~default~~ NULL COMMENT "TRUE = this item is visible to customers as stock",		`WhenCounted` DATETIME DEFAULT NULL COMMENT "timestamp of when bin's contents were last inventoried",
	`isForShip` ~~tinyint~~(1) ~~default~~ NULL COMMENT "TRUE = this item is available for filling orders",		`isForSale` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is visible to customers as stock",
	`Notes` ~~text~~,		`isForShip` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is available for filling orders",
	PRIMARY KEY (`ID`)		`Notes` TEXT,
			PRIMARY KEY (`ID`)
	) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;</mysql>		) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;</mysql>
	<section end=sql />		<section end=sql />

Woozle: notes about isForShip

2009-12-20T20:36:09Z

notes about isForShip

← Older revision		Revision as of 20:36, 20 December 2009
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': containers in which stock may be found		* '''Purpose''': containers in which stock may be found
	* '''Refers to''': {{vbzcart/table\|stk_places}}		* '''Refers to''': {{vbzcart\|table\|stk_places}}
	* '''Fields''':		* '''Fields''':
	** '''WhenCreated''' can be NOT NULL if you don't have any legacy data to deal with.		** '''WhenCreated''' can be NOT NULL if you don't have any legacy data to deal with.
	** '''isForShip''' got ~~eventually~~ added because I kept forgetting to use WhenVoided, and I finally decided that it wasn't redundant to have a flag specifically for this attribute		** '''isForShip''' eventually got added because I kept forgetting to use WhenVoided, and I finally decided that it wasn't redundant to have a flag specifically for this attribute. It has two meanings which may eventually need to be separated into separate fields:
			*** A. FALSE = do not ship this item, even though we have it on site (why would this happen? not sure if needed)
			*** B. FALSE = this bin is not physically accessible to the shipping department; items must be shipped by someone at that location or sent here to be shipped from this location. This meaning should actually be reflected by the Warehouse set in {{vbzcart\|table\|stk_places}}, but that's going to take a little thinking to implement that properly because it's hierarchical. Administrators operating at a given location should only be able to move items into (or out of) bins ''at that location''. Right now, we just globally say that some bins are unreachable: not as good, but much easier to implement. Fix later.
	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP TABLE IF EXISTS `stk_bins`;		<section begin=sql /><mysql>DROP TABLE IF EXISTS `stk_bins`;

← Older revision		Revision as of 12:36, 24 March 2017
Line 7:		Line 7:
	*** A. FALSE = do not ship this item, even though we have it on site (why would this happen? not sure if needed)		*** A. FALSE = do not ship this item, even though we have it on site (why would this happen? not sure if needed)
	*** B. FALSE = this bin is not physically accessible to the shipping department; items must be shipped by someone at that location or sent here to be shipped from this location. This meaning should actually be reflected by the Warehouse set in {{vbzcart\|table\|stk_places}}, but that's going to take a little thinking to implement that properly because it's hierarchical. Administrators operating at a given location should only be able to move items into (or out of) bins ''at that location''. Right now, we just globally say that some bins are unreachable: not as good, but much easier to implement. Fix later.		*** B. FALSE = this bin is not physically accessible to the shipping department; items must be shipped by someone at that location or sent here to be shipped from this location. This meaning should actually be reflected by the Warehouse set in {{vbzcart\|table\|stk_places}}, but that's going to take a little thinking to implement that properly because it's hierarchical. Administrators operating at a given location should only be able to move items into (or out of) bins ''at that location''. Right now, we just globally say that some bins are unreachable: not as good, but much easier to implement. Fix later.
	** '''isEnabled''': TRUE = this bin is in a Place that is currently valid, usable, etc. FALSE = this bin should be treated as unshippable and unsellable even if isForShip and isForSale are marked TRUE		** '''isEnabled''' (DEPRECATED): TRUE = this bin is in a Place that is currently valid, usable, etc. FALSE = this bin should be treated as unshippable and unsellable even if isForShip and isForSale are marked TRUE
	*** It looks like this was intended to be calculated from the status of the parent Place; possibly it should just be eliminated.		*** It looks like this was intended to be calculated from the status of the parent Place; possibly it should just be eliminated.
	* '''History~~''':~~		==History==
	** '''2011-04-01''' added '''WhenCounted''' field -- for some reason, I thought this field was already here, but obviously it needs to be so we can track which bins are due for inventorying		* '''2011-04-01''' added '''WhenCounted''' field -- for some reason, I thought this field was already here, but obviously it needs to be so we can track which bins are due for inventorying
	** '''2012-02-06''' added '''isEnabled''' field		* '''2012-02-06''' added '''isEnabled''' field
	** '''2015-11-17''' added '''WhenEdited''' field		* '''2015-11-17''' added '''WhenEdited''' field
			* '''2017-03-24''' deprecating '''isEnabled''' field
	==SQL==		==SQL==
	<mysql>DROP TABLE IF EXISTS `stk_bins`;		<mysql>DROP TABLE IF EXISTS `stk_bins`;
Line 27:		Line 28:
	`isForSale` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is visible to customers as stock",		`isForSale` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is visible to customers as stock",
	`isForShip` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is available for filling orders",		`isForShip` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is available for filling orders",
	`isEnabled` TINYINT(1) DEFAULT NULL COMMENT "~~FALSE = (calculated) treat as unshippable/unsellable regardless of isForSale/isForShip~~",		`isEnabled` TINYINT(1) DEFAULT NULL COMMENT "DEPRECATED; do not use; will be removed soon",
	`Notes` TEXT,		`Notes` TEXT,
	PRIMARY KEY (`ID`)		PRIMARY KEY (`ID`)
	) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;</mysql>		) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;</mysql>