VbzCart/docs/tables/stk places

About

• Purpose: places where containers may be found, organized hierarchically
• Rules: Both stock Bins and order Packages can be in Places. Later, Places may have attributes to tell us whether we can ship items directly from there (or at all) and whether or not they are effectively "local" to us, but for now they don't.
• Fields:
  • isLocal: FALSE = items aren't where we are, so they must either be shipped here first or shipped to customer in separate pkg
  • isWhse: TRUE = items have to be fetched for shipping; some delay involved, and may want to print out lists of stuff to fetch
  • ID_Supp: NOT NULL = this location is a supplier's stock, and items must be ordered from it in order to be shippable

SQL

<section begin=sql /><mysql> DROP TABLE IF EXISTS `stk_places`;

CREATE TABLE `stk_places` (
  `ID` INT  NOT NULL AUTO_INCREMENT,
  `ID_Parent` INT COMMENT 'self.ID of place in which this place is found; may be NULL',
  `Name` VARCHAR(63) NOT NULL COMMENT 'brief descriptive name for listings and tree-paths',
  `Descr` VARCHAR(127) COMMENT '(optional) description of this place, so it can be located',
  PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>

<section end=sql />