VbzCart/docs/tables/cat ioptns: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
(extracted from "tables" page)
 
m (Woozle moved page VbzCart/VbzCart/tables/cat ioptns to VbzCart/docs/tables/cat ioptns without leaving a redirect: part 3/5)
 
(No difference)

Latest revision as of 01:56, 25 February 2024

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

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/tables/cat_ioptns&oldid=6866"