VbzCart/tables/cat ioptns

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, search

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

<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>