User:Woozle/StockFerret/items
< User:Woozle | StockFerret
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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>