User:Woozle/StockFerret/bins - Revision history

Woozle: changing design - any place can be a bin if it has a bin record

2013-03-09T02:52:36Z

changing design - any place can be a bin if it has a bin record

← Older revision		Revision as of 02:52, 9 March 2013
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': ~~containers~~ where stock items may be kept directly (without being surrounded by any additional levels of container)		* '''Purpose''': places where stock items may be kept directly (without being surrounded by any additional levels of container)
			* '''Depends on''': {{l/same\|places}}
	* '''Adapted from''': [[VbzCart/tables/stk bins]]		* '''Adapted from''': [[VbzCart/tables/stk bins]]
	==SQL==		==SQL==
	<mysql>		<mysql>
	CREATE TABLE `bins` (		CREATE TABLE `bins` (
	~~`ID` INT(11) NOT NULL auto_increment,~~
	`ID_Place` INT(11) NOT NULL COMMENT "places.ID",		`ID_Place` INT(11) NOT NULL COMMENT "places.ID",
	`Code` VARCHAR(15) NOT NULL COMMENT "code name meaningful to user -- can be barcode or just something written on the box",		`Code` VARCHAR(15) NOT NULL COMMENT "code name meaningful to user -- can be barcode or just something written on the box",
Line 14:		Line 14:
	`WhenCounted` DATETIME DEFAULT NULL COMMENT "timestamp of when bin's contents were last inventoried",		`WhenCounted` DATETIME DEFAULT NULL COMMENT "timestamp of when bin's contents were last inventoried",
	`Notes` TEXT,		`Notes` TEXT,
	PRIMARY KEY (`ID`)		PRIMARY KEY (`ID_Place`)
	) ENGINE=MyISAM ~~AUTO_INCREMENT=111 DEFAULT CHARSET=latin1~~;		) ENGINE=MyISAM;
	</mysql>		</mysql>

Woozle: CREATE TABLE name correction

2013-03-09T02:48:47Z

CREATE TABLE name correction

← Older revision		Revision as of 02:48, 9 March 2013
Line 4:		Line 4:
	==SQL==		==SQL==
	<mysql>		<mysql>
	CREATE TABLE `~~stk_bins~~` (		CREATE TABLE `bins` (
	`ID` INT(11) NOT NULL auto_increment,		`ID` INT(11) NOT NULL auto_increment,
	`ID_Place` INT(11) NOT NULL COMMENT "places.ID",		`ID_Place` INT(11) NOT NULL COMMENT "places.ID",

Woozle: Created page with "==About== * '''Purpose''': containers where stock items may be kept directly (without being surrounded by any additional levels of container) * '''Adapted from''': [[VbzCart/t..."

2013-03-09T02:47:48Z

Created page with "==About== * '''Purpose''': containers where stock items may be kept directly (without being surrounded by any additional levels of container) * '''Adapted from''': [[VbzCart/t..."

New page

==About==
* '''Purpose''': containers where stock items may be kept directly (without being surrounded by any additional levels of container)
* '''Adapted from''': [[VbzCart/tables/stk bins]]
==SQL==
<mysql>
CREATE TABLE `stk_bins` (
`ID` INT(11) NOT NULL auto_increment,
`ID_Place` INT(11) NOT NULL COMMENT "places.ID",
`Code` VARCHAR(15) NOT NULL COMMENT "code name meaningful to user -- can be barcode or just something written on the box",
`Descr` VARCHAR(63) DEFAULT NULL COMMENT 'brief summary of contents or container',
`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',
`WhenTainted` DATETIME DEFAULT NULL COMMENT "if NOT NULL, this bin needs re-inventorying",
`WhenCounted` DATETIME DEFAULT NULL COMMENT "timestamp of when bin's contents were last inventoried",
`Notes` TEXT,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;
</mysql>