VbzCart/tables/ depts

From HTYP, the free directory anyone can edit

[edit] About

• Purpose: Calculated information about departments

[edit] SQL

 DROP TABLE IF EXISTS `_depts`;
 CREATE TABLE `_depts` (
   `ID` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
   `ID_Supp` INT(11) UNSIGNED NOT NULL COMMENT 'needed to simplify calculation of _titles',
   `CatNum` VARCHAR(63) NOT NULL,
   `CatKey` VARCHAR(7),
   `CatWeb_Dept` VARCHAR(63) NOT NULL,
   `CatWeb_Title` VARCHAR(63) NOT NULL,
   `cntForSale` INT DEFAULT NULL,
   `cntInPrint` INT DEFAULT NULL,
   `qtyInStock` INT DEFAULT NULL,
   PRIMARY KEY (`ID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;