Difference between revisions of "VbzCart/tables/stk places"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(extracted from VbzCart/tables)
 
(+isActive field)
Line 1: Line 1:
 
==About==
 
==About==
 
* '''Purpose''': places where containers may be found, organized hierarchically
 
* '''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.
+
* '''History''':
 +
** '''2010-11-30''' added '''isActive''' field, so we can hide all the old GA places
 
* '''Fields''':
 
* '''Fields''':
−
** '''isLocal''': FALSE = items aren't where we are, so they must either be shipped here first or shipped to customer in separate pkg
+
** '''isActive''': if FALSE, then normal operations should ignore this place ''and all places inside it''.
−
** '''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==
 
==SQL==
 
<section begin=sql /><mysql> DROP TABLE IF EXISTS `stk_places`;
 
<section begin=sql /><mysql> DROP TABLE IF EXISTS `stk_places`;
 
   
 
   
 
  CREATE TABLE `stk_places` (
 
  CREATE TABLE `stk_places` (
−
   `ID` INT NOT NULL AUTO_INCREMENT,
+
   `ID` INT NOT NULL AUTO_INCREMENT,
−
   `ID_Parent` INT COMMENT 'self.ID of place in which this place is found; may be NULL',
+
   `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',
+
  `isActive`    BOOL          COMMENT "FALSE = don't normally show this place in lists or count its stock in totals",
−
   `Descr` VARCHAR(127) COMMENT '(optional) description of this place, so it can be located',
+
   `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`)
 
   PRIMARY KEY(`ID`)
 
  ) ENGINE = MYISAM;</mysql>
 
  ) ENGINE = MYISAM;</mysql>
 
<section end=sql />
 
<section end=sql />
 +
==Archive==
 +
These notes do not currently apply. They may be things we will want to use at some point, but are not currently in use on this table.
 +
* '''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

Revision as of 20:14, 30 November 2010

About

  • Purpose: places where containers may be found, organized hierarchically
  • History:
    • 2010-11-30 added isActive field, so we can hide all the old GA places
  • Fields:
    • isActive: if FALSE, then normal operations should ignore this place and all places inside it.

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",
  `isActive`     BOOL          COMMENT "FALSE = don't normally show this place in lists or count its stock in totals",
  `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>

Archive

These notes do not currently apply. They may be things we will want to use at some point, but are not currently in use on this table.

  • 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
Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/tables/stk_places&oldid=14518"