User:Woozle/StockFerret/items: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Created page with "==About== * '''Purpose''': master catalog of all items known to the system * '''Adapted from''': VbzCart/tables/cat items * '''Fields''': ** '''CatNum''': a user-relevant ..." |
qty in stock doesn't seem like it should be part of this |
||
| Line 12: | Line 12: | ||
`Descr` VARCHAR(127) DEFAULT NULL COMMENT "item-specific description", | `Descr` VARCHAR(127) DEFAULT NULL COMMENT "item-specific description", | ||
`SuppNum` VARCHAR(32) DEFAULT NULL COMMENT "supplier's catalog number, if available", | `SuppNum` VARCHAR(32) DEFAULT NULL COMMENT "supplier's catalog number, if available", | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) | ) | ||
ENGINE = MYISAM; | ENGINE = MYISAM; | ||
</mysql> | </mysql> | ||
Latest revision as of 15:25, 9 March 2013
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>
