VbzCart/tables/ title ittyps

From HTYP, the free directory anyone can edit

[edit] 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)

[edit] SQL

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;