Difference between revisions of "VbzCart/tables/stk places"
Jump to navigation
Jump to search
(corrections to match actual table) |
(link to bins; removed obsolete markup) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
| − | * '''Purpose''': places where | + | * '''Purpose''': places where {{vbzcart|table|stk_bins|bins}} may be found, organized hierarchically |
* '''History''': | * '''History''': | ||
** '''2010-11-30''' added '''isActive''' field, so we can hide all the old GA places | ** '''2010-11-30''' added '''isActive''' field, so we can hide all the old GA places | ||
| Line 9: | Line 9: | ||
** '''isEnabled''': (calculated by code) if TRUE, all parents between here and root are Active | ** '''isEnabled''': (calculated by code) if TRUE, all parents between here and root are Active | ||
==SQL== | ==SQL== | ||
| − | + | <mysql>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", | ||
| Line 18: | Line 18: | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) ENGINE = MYISAM;</mysql> | ) ENGINE = MYISAM;</mysql> | ||
| − | |||
==Archive== | ==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. | 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. | ||
Revision as of 21:24, 6 November 2015
About
- Purpose: places where bins may be found, organized hierarchically
- History:
- 2010-11-30 added isActive field, so we can hide all the old GA places
- 2012-02-06 added isEnabled field so cat_items stock can be calculated properly by query
- Also corrected type for isActive to match actual table
- Fields:
- isActive: if FALSE, then normal operations should ignore this place and all places inside it.
- isEnabled: (calculated by code) if TRUE, all parents between here and root are Active
SQL
<mysql>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` TINYINT(1) NOT NULL COMMENT "FALSE = don't normally show this place in lists or count its stock in totals", `isEnabled` TINYINT(1) NOT NULL COMMENT "(calculated field) TRUE = all parents between here and root are Active", `Name` VARCHAR(63) NOT NULL COMMENT "brief descriptive name for listings and tree-paths", `Descr` VARCHAR(127) DEFAULT NULL 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