VbzCart/tables/ title ittyps - Revision history

Woozle: correction

2011-01-24T18:34:31Z

correction

← Older revision		Revision as of 18:34, 24 January 2011
Line 1:		Line 1:
	==About==		==About==
	* '''Returns''': list of available titles for each item type		* '''Returns''': list of available titles for each item type
	** This table provides the same ~~general~~ information as {{vbzcart/query\|qryTitles_ItTyps_ItTyps}}		** This table provides some of the same information as {{vbzcart/query\|qryTitles_ItTyps_ItTyps}}, but consolidated by ItTyp
	* '''Sources''': {{vbzcart\|proc\|Upd_TitleIttyps_fr_CatItems_Titles}}, {{vbzcart\|proc\|Upd_TitleIttyps_fr_CatIttyps}}, {{vbzcart\|proc\|Upd_TitleIttyps_fr_Titles}}		* '''Sources''': {{vbzcart\|proc\|Upd_TitleIttyps_fr_CatItems_Titles}}, {{vbzcart\|proc\|Upd_TitleIttyps_fr_CatIttyps}}, {{vbzcart\|proc\|Upd_TitleIttyps_fr_Titles}}
	* '''Used by''': {{vbzcart\|proc\|Upd_Titles_fr_TitleIttyps}}, {{vbzcart\|proc\|Upd_DeptIttyps_fr_TitleIttyps}}, {{vbzcart\|proc\|Upd_SupplierIttyps}}		* '''Used by''': {{vbzcart\|proc\|Upd_Titles_fr_TitleIttyps}}, {{vbzcart\|proc\|Upd_DeptIttyps_fr_TitleIttyps}}, {{vbzcart\|proc\|Upd_SupplierIttyps}}

Woozle: note similarity to now-redundant query

2011-01-24T17:17:17Z

note similarity to now-redundant query

← Older revision		Revision as of 17:17, 24 January 2011
Line 1:		Line 1:
	==About==		==About==
	* '''~~Purpose~~''': list of available titles for each item type		* '''Returns''': list of available titles for each item type
			** This table provides the same general information as {{vbzcart/query\|qryTitles_ItTyps_ItTyps}}
	* '''Sources''': {{vbzcart\|proc\|Upd_TitleIttyps_fr_CatItems_Titles}}, {{vbzcart\|proc\|Upd_TitleIttyps_fr_CatIttyps}}, {{vbzcart\|proc\|Upd_TitleIttyps_fr_Titles}}		* '''Sources''': {{vbzcart\|proc\|Upd_TitleIttyps_fr_CatItems_Titles}}, {{vbzcart\|proc\|Upd_TitleIttyps_fr_CatIttyps}}, {{vbzcart\|proc\|Upd_TitleIttyps_fr_Titles}}
	* '''Used by''': {{vbzcart\|proc\|Upd_Titles_fr_TitleIttyps}}, {{vbzcart\|proc\|Upd_DeptIttyps_fr_TitleIttyps}}, {{vbzcart\|proc\|Upd_SupplierIttyps}}		* '''Used by''': {{vbzcart\|proc\|Upd_Titles_fr_TitleIttyps}}, {{vbzcart\|proc\|Upd_DeptIttyps_fr_TitleIttyps}}, {{vbzcart\|proc\|Upd_SupplierIttyps}}

Woozle: used by...

2010-11-14T17:01:14Z

used by...

← Older revision		Revision as of 17:01, 14 November 2010
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': list of available titles for each item type		* '''Purpose''': list of available titles for each item type
	* '''~~Filled by~~''': {{vbzcart\|proc\|Upd_TitleIttyps_fr_CatItems_Titles}}, {{vbzcart\|proc\|Upd_TitleIttyps_fr_CatIttyps}}, {{vbzcart\|proc\|Upd_TitleIttyps_fr_Titles}}		* '''Sources''': {{vbzcart\|proc\|Upd_TitleIttyps_fr_CatItems_Titles}}, {{vbzcart\|proc\|Upd_TitleIttyps_fr_CatIttyps}}, {{vbzcart\|proc\|Upd_TitleIttyps_fr_Titles}}
	* '''~~Source for~~''':		* '''Used by''': {{vbzcart\|proc\|Upd_Titles_fr_TitleIttyps}}, {{vbzcart\|proc\|Upd_DeptIttyps_fr_TitleIttyps}}, {{vbzcart\|proc\|Upd_SupplierIttyps}}
	* '''History''':		* '''History''':
	** '''2007-09-20''' Added cntInStock field because we need to be able to figure out how many line items are available but ''not'' in stock (cntForSale-cntInStock)		** '''2007-09-20''' Added cntInStock field because we need to be able to figure out how many line items are available but ''not'' in stock (cntForSale-cntInStock)

Woozle: 2 new fields

2010-11-14T00:08:12Z

2 new fields

← Older revision		Revision as of 00:08, 14 November 2010
Line 5:		Line 5:
	* '''History''':		* '''History''':
	** '''2007-09-20''' Added cntInStock field because we need to be able to figure out how many line items are available but ''not'' in stock (cntForSale-cntInStock)		** '''2007-09-20''' Added cntInStock field because we need to be able to figure out how many line items are available but ''not'' in stock (cntForSale-cntInStock)
			** '''2010-11-13''' Added 2 fields to help with availability status display: '''cntLines''', '''cntCurrent'''
	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP TABLE IF EXISTS `_title_ittyps`;		<section begin=sql /><mysql>DROP TABLE IF EXISTS `_title_ittyps`;
Line 15:		Line 16:
	`ItTypNamePlr` varchar(63) COMMENT "cat_ittyps.NamePlr",		`ItTypNamePlr` varchar(63) COMMENT "cat_ittyps.NamePlr",
	`ItTypSort` varchar(31) COMMENT "cat_ittyps.Sort",		`ItTypSort` varchar(31) COMMENT "cat_ittyps.Sort",
			`cntLines` int COMMENT "# of different items for this title+type",
			`cntCurrent` int COMMENT "# of different items whose item data is current, for this title+type",
			`cntInPrint` int COMMENT "# of different items (for type) in print for this title",
	`cntForSale` int COMMENT "# of different items available for type (either in stock or in print)",		`cntForSale` int COMMENT "# of different items available for type (either in stock or in print)",
	~~`cntInPrint` int COMMENT "# of different items (for type) in print for this title",~~
	`cntInStock` int COMMENT "# of different items (for type) which are for sale due to at least being in stock",		`cntInStock` int COMMENT "# of different items (for type) which are for sale due to at least being in stock",
	`qtyInStock` int COMMENT "-1 = some in stock, but don't know how many",		`qtyInStock` int COMMENT "-1 = some in stock, but don't know how many",
Line 25:		Line 28:
	`CatDir` varchar(63) DEFAULT NULL,		`CatDir` varchar(63) DEFAULT NULL,
	PRIMARY KEY (`ID_Title`,`ID_ItTyp`,`ID_Dept`)		PRIMARY KEY (`ID_Title`,`ID_ItTyp`,`ID_Dept`)
	) ENGINE=MyISAM ~~DEFAULT CHARSET=latin1~~;</mysql>		) ENGINE=MyISAM;</mysql>
	<section end=sql />		<section end=sql />

Woozle: filled by (procs)

2010-11-13T23:02:42Z

filled by (procs)

← Older revision		Revision as of 23:02, 13 November 2010
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': list of available titles for each item type		* '''Purpose''': list of available titles for each item type
			* '''Filled by''': {{vbzcart\|proc\|Upd_TitleIttyps_fr_CatItems_Titles}}, {{vbzcart\|proc\|Upd_TitleIttyps_fr_CatIttyps}}, {{vbzcart\|proc\|Upd_TitleIttyps_fr_Titles}}
			* '''Source for''':
	* '''History''':		* '''History''':
	** '''2007-09-20''' Added cntInStock field because we need to be able to figure out how many line items are available but ''not'' in stock (cntForSale-cntInStock)		** '''2007-09-20''' Added cntInStock field because we need to be able to figure out how many line items are available but ''not'' in stock (cntForSale-cntInStock)

Woozle: New page: ==About== * '''Purpose''': list of available titles for each item type * '''History''': ** '''2007-09-20''' Added cntInStock field because we need to be able to figure out how many line it...

2009-03-08T19:48:53Z

New page: ==About== * '''Purpose''': list of available titles for each item type * '''History''': ** '''2007-09-20''' Added cntInStock field because we need to be able to figure out how many line it...

New page

==About==
* '''Purpose''': list of available titles for each item type
* '''History''':
** '''2007-09-20''' Added cntInStock field because we need to be able to figure out how many line items are available but ''not'' in stock (cntForSale-cntInStock)
==SQL==
<section begin=sql /><mysql>DROP TABLE IF EXISTS `_title_ittyps`;
CREATE TABLE `_title_ittyps` (
`ID_Title` int unsigned NOT NULL,
`ID_ItTyp` int unsigned NOT NULL,
`ID_Dept` int unsigned NOT NULL,
`TitleName` varchar(127),
`ItTypNameSng` varchar(63) COMMENT "cat_ittyps.NameSng",
`ItTypNamePlr` varchar(63) COMMENT "cat_ittyps.NamePlr",
`ItTypSort` varchar(31) COMMENT "cat_ittyps.Sort",
`cntForSale` int COMMENT "# of different items available for type (either in stock or in print)",
`cntInPrint` int COMMENT "# of different items (for type) in print for this title",
`cntInStock` int COMMENT "# of different items (for type) which are for sale due to at least being in stock",
`qtyInStock` int COMMENT "-1 = some in stock, but don't know how many",
`currMinPrice` DECIMAL(9,2) DEFAULT NULL COMMENT 'minimum price for this item type',
`currMaxPrice` DECIMAL(9,2) DEFAULT NULL COMMENT 'maximum price for this item type',
`CatNum` varchar(63) DEFAULT NULL,
`CatWeb` varchar(63) DEFAULT NULL,
`CatDir` varchar(63) DEFAULT NULL,
PRIMARY KEY (`ID_Title`,`ID_ItTyp`,`ID_Dept`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;</mysql>
<section end=sql />