VbzCart/docs/tables/cat ioptns

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

SQL

<section begin=sql /><mysql> 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;</mysql>

<section end=sql />