VbzCart/tables/cat ioptns

From HTYP, the free directory anyone can edit

[edit] About

• Purpose: catalog options - these typically distinguish items within a title
• Fields:
  • CatKey (string(8)): appended to catalog number (with dash prefix)
  • Descr (string(64)): appended to item description (with separator of some kind)
  • Sort (string(8)): sorting order when options for a title appear together in a list

[edit] SQL

 CREATE TABLE `cat_ioptns` (
   `ID` INT NOT NULL AUTO_INCREMENT,
   `CatKey` VARCHAR(7) NOT NULL COMMENT 'appended to catalog number (with dash prefix)',
   `Descr` VARCHAR(127) NOT NULL COMMENT 'appended to item description (with separator of some kind)',
   `Sort` VARCHAR(7) COMMENT 'sorting order when options for a title appear together in a list',
  PRIMARY KEY(`ID`)
 ) ENGINE = MYISAM;