User:Woozle/StockFerret/items

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: master catalog of all items known to the system
  • Adapted from: VbzCart/tables/cat items
  • Fields:
    • CatNum: a user-relevant unique ID, such as a catalog or SKU number.
    • SuppNum: supplier's preferred unique ID, where applicable

SQL

<mysql> CREATE TABLE `items` (

  `ID`                     INT NOT NULL AUTO_INCREMENT,
  `CatNum`    VARCHAR(64)  DEFAULT NULL COMMENT "catalog number: must be unique or null; can be changed",
  `Descr`     VARCHAR(127) DEFAULT NULL COMMENT "item-specific description",
  `SuppNum`   VARCHAR(32)  DEFAULT NULL COMMENT "supplier's catalog number, if available",
  PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;

</mysql>