VbzCart/tables/cat ioptns

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | tables
Revision as of 15:31, 6 December 2008 by Woozle (talk | contribs) (extracted from "tables" page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to 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>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/tables/cat_ioptns&oldid=10989"