VbzCart/docs/tables/stk bins: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (new field: WhenCounted; some tidying) |
m (Woozle moved page VbzCart/VbzCart/tables/stk bins to VbzCart/docs/tables/stk bins without leaving a redirect: part 4/5) |
||
| (8 intermediate revisions by one other user not shown) | |||
| Line 2: | Line 2: | ||
* '''Purpose''': containers in which stock may be found | * '''Purpose''': containers in which stock may be found | ||
* '''Refers to''': {{vbzcart|table|stk_places}} | * '''Refers to''': {{vbzcart|table|stk_places}} | ||
* '''Referenced by''': {{l/vc/table|stk_lines}} | |||
* '''Fields''': | * '''Fields''': | ||
** '''WhenCreated''' can be NOT NULL if you don't have any legacy data to deal with. | ** '''WhenCreated''' can be NOT NULL if you don't have any legacy data to deal with. | ||
| Line 7: | Line 8: | ||
*** A. FALSE = do not ship this item, even though we have it on site (why would this happen? not sure if needed) | *** A. FALSE = do not ship this item, even though we have it on site (why would this happen? not sure if needed) | ||
*** B. FALSE = this bin is not physically accessible to the shipping department; items must be shipped by someone at that location or sent here to be shipped from this location. This meaning should actually be reflected by the Warehouse set in {{vbzcart|table|stk_places}}, but that's going to take a little thinking to implement that properly because it's hierarchical. Administrators operating at a given location should only be able to move items into (or out of) bins ''at that location''. Right now, we just globally say that some bins are unreachable: not as good, but much easier to implement. Fix later. | *** B. FALSE = this bin is not physically accessible to the shipping department; items must be shipped by someone at that location or sent here to be shipped from this location. This meaning should actually be reflected by the Warehouse set in {{vbzcart|table|stk_places}}, but that's going to take a little thinking to implement that properly because it's hierarchical. Administrators operating at a given location should only be able to move items into (or out of) bins ''at that location''. Right now, we just globally say that some bins are unreachable: not as good, but much easier to implement. Fix later. | ||
* ''' | ** '''isEnabled''' (DEPRECATED): TRUE = this bin is in a Place that is currently valid, usable, etc. FALSE = this bin should be treated as unshippable and unsellable even if isForShip and isForSale are marked TRUE | ||
** '''2011-04-01''' added '''WhenCounted''' field -- for some reason, I thought this field was already here, but obviously it needs to be so we can track which bins are due for inventorying | *** It looks like this was intended to be calculated from the status of the parent Place; possibly it should just be eliminated. | ||
==History== | |||
* '''2011-04-01''' added '''WhenCounted''' field -- for some reason, I thought this field was already here, but obviously it needs to be so we can track which bins are due for inventorying | |||
* '''2012-02-06''' added '''isEnabled''' field | |||
* '''2015-11-17''' added '''WhenEdited''' field | |||
* '''2017-03-24''' deprecating '''isEnabled''' field | |||
* '''2017-09-05''' Changed MyISAM to InnoDB | |||
==SQL== | ==SQL== | ||
<mysql>DROP TABLE IF EXISTS `stk_bins`; | |||
CREATE TABLE `stk_bins` ( | CREATE TABLE `stk_bins` ( | ||
`ID` INT(11) NOT NULL auto_increment, | `ID` INT(11) NOT NULL auto_increment, | ||
| Line 17: | Line 24: | ||
`Descr` VARCHAR(63) DEFAULT NULL COMMENT 'brief summary of contents', | `Descr` VARCHAR(63) DEFAULT NULL COMMENT 'brief summary of contents', | ||
`WhenCreated` DATETIME DEFAULT NULL COMMENT 'date when container was added to the database', | `WhenCreated` DATETIME DEFAULT NULL COMMENT 'date when container was added to the database', | ||
`WhenEdited` DATETIME DEFAULT NULL COMMENT 'date when container record was last edited', | |||
`WhenVoided` DATETIME DEFAULT NULL COMMENT 'date when container was destroyed or removed from usage', | `WhenVoided` DATETIME DEFAULT NULL COMMENT 'date when container was destroyed or removed from usage', | ||
`WhenTainted` DATETIME DEFAULT NULL COMMENT "if NOT NULL, this bin needs re-inventorying", | `WhenTainted` DATETIME DEFAULT NULL COMMENT "if NOT NULL, this bin needs re-inventorying", | ||
| Line 22: | Line 30: | ||
`isForSale` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is visible to customers as stock", | `isForSale` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is visible to customers as stock", | ||
`isForShip` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is available for filling orders", | `isForShip` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is available for filling orders", | ||
`isEnabled` TINYINT(1) DEFAULT NULL COMMENT "DEPRECATED; do not use; will be removed soon", | |||
`Notes` TEXT, | `Notes` TEXT, | ||
PRIMARY KEY (`ID`) | PRIMARY KEY (`ID`) | ||
) ENGINE= | ) ENGINE=InnoDB;</mysql> | ||
Latest revision as of 01:57, 25 February 2024
About
- Purpose: containers in which stock may be found
- Refers to: Template:Vbzcart
- Referenced by: Template:L/vc/table
- Fields:
- WhenCreated can be NOT NULL if you don't have any legacy data to deal with.
- isForShip eventually got added because I kept forgetting to use WhenVoided, and I finally decided that it wasn't redundant to have a flag specifically for this attribute. It has two meanings which may eventually need to be separated into separate fields:
- A. FALSE = do not ship this item, even though we have it on site (why would this happen? not sure if needed)
- B. FALSE = this bin is not physically accessible to the shipping department; items must be shipped by someone at that location or sent here to be shipped from this location. This meaning should actually be reflected by the Warehouse set in Template:Vbzcart, but that's going to take a little thinking to implement that properly because it's hierarchical. Administrators operating at a given location should only be able to move items into (or out of) bins at that location. Right now, we just globally say that some bins are unreachable: not as good, but much easier to implement. Fix later.
- isEnabled (DEPRECATED): TRUE = this bin is in a Place that is currently valid, usable, etc. FALSE = this bin should be treated as unshippable and unsellable even if isForShip and isForSale are marked TRUE
- It looks like this was intended to be calculated from the status of the parent Place; possibly it should just be eliminated.
History
- 2011-04-01 added WhenCounted field -- for some reason, I thought this field was already here, but obviously it needs to be so we can track which bins are due for inventorying
- 2012-02-06 added isEnabled field
- 2015-11-17 added WhenEdited field
- 2017-03-24 deprecating isEnabled field
- 2017-09-05 Changed MyISAM to InnoDB
SQL
<mysql>DROP TABLE IF EXISTS `stk_bins`; CREATE TABLE `stk_bins` (
`ID` INT(11) NOT NULL auto_increment, `ID_Place` INT(11) NOT NULL COMMENT 'stk_places.ID', `Code` VARCHAR(15) NOT NULL COMMENT 'code name, e.g. NC01 -- must appear on outside of box', `Descr` VARCHAR(63) DEFAULT NULL COMMENT 'brief summary of contents', `WhenCreated` DATETIME DEFAULT NULL COMMENT 'date when container was added to the database', `WhenEdited` DATETIME DEFAULT NULL COMMENT 'date when container record was last edited', `WhenVoided` DATETIME DEFAULT NULL COMMENT 'date when container was destroyed or removed from usage', `WhenTainted` DATETIME DEFAULT NULL COMMENT "if NOT NULL, this bin needs re-inventorying", `WhenCounted` DATETIME DEFAULT NULL COMMENT "timestamp of when bin's contents were last inventoried", `isForSale` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is visible to customers as stock", `isForShip` TINYINT(1) DEFAULT NULL COMMENT "TRUE = this item is available for filling orders", `isEnabled` TINYINT(1) DEFAULT NULL COMMENT "DEPRECATED; do not use; will be removed soon", `Notes` TEXT, PRIMARY KEY (`ID`)
) ENGINE=InnoDB;</mysql>