User:Woozle/StockFerret/items

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",
  `QtyIn_Stk` INT          DEFAULT NULL COMMENT "total quantity of this item found across all for-sale stock locations",
  PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;

</mysql>