VbzCart/docs/tables/stk whse

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search

About

  • Purpose: tracks Template:L/vc/term locations
  • Future: we'll probably want contact information, eventually.
  • History:
    • 2016-01-08 created because it really doesn't make sense to have warehouses in the suppliers table, but we do (or will) need a way to track them.

SQL

<mysql>CREATE TABLE `stk_whse` (

  `ID` INT NOT NULL AUTO_INCREMENT,
  `Name`     VARCHAR(64) COMMENT 'name of supplier as displayed',
  `isActive` BOOL COMMENT 'if FALSE, hide from casual listings',
  `Notes`    TEXT COMMENT "Human-entered notes about this supplier, for quick reference",
  PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>