VbzCart/docs/tables/stk bin history: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle m (→About: table name correction) |
imported>Woozle (added WhoAdmin, WhoSystem, WhoNetwork) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': Documents changes to {{vbzcart|table|stk_bins}} data | * '''Purpose''': Documents things which happen to a stock bin -- usually changes to {{vbzcart|table|stk_bins}} data, but can also log collective movement of items to/from bins | ||
* '''History''': | * '''History''': | ||
** '''2009-11-07''' Added "Descr" field and made ID_Srce/ID_Dest NOT NULL | ** '''2009-11-07''' Added "Descr" field and made ID_Srce/ID_Dest NOT NULL | ||
** '''2009-12-20''' Added fields WhoAdmin, WhoSystem, WhoNetwork | |||
* '''Fields''': | * '''Fields''': | ||
** '''Descr''' is for events other than moving, e.g. field changes or stock recounts | ** '''Descr''' is for events other than moving, e.g. field changes or stock recounts | ||
| Line 9: | Line 10: | ||
<section begin=sql /><mysql>DROP TABLE IF EXISTS `stk_bin_history`; | <section begin=sql /><mysql>DROP TABLE IF EXISTS `stk_bin_history`; | ||
CREATE TABLE `stk_bin_history` ( | CREATE TABLE `stk_bin_history` ( | ||
`ID` INT | `ID` INT NOT NULL AUTO_INCREMENT, | ||
`ID_Bin` | `ID_Bin` INT NOT NULL COMMENT "stk_bins.ID of bin being moved", | ||
`WhenDone` | `WhenDone` DATETIME NOT NULL COMMENT "when the move happened", | ||
`ID_Srce` | `WhoAdmin` VARCHAR(127) NOT NULL COMMENT "VbzCart admin username", | ||
`ID_Dest` | `WhoSystem` VARCHAR(127) DEFAULT NULL COMMENT "who logged into the operating system, if using non-web client app", | ||
`Descr` VARCHAR(255) DEFAULT NULL COMMENT "code-generated description for non-move events", | `WhoNetwork` VARCHAR(64) NOT NULL COMMENT "network name or IP address of client machine", | ||
`Notes` VARCHAR(255) DEFAULT NULL COMMENT "optional explanatory notes", | `ID_Srce` INT NOT NULL COMMENT "stk_places.ID of where the bin came from (NULL = new bin)", | ||
`ID_Dest` INT NOT NULL COMMENT "stk_places.ID of where the bin was moved to (NULL = bin destroyed)", | |||
`Descr` VARCHAR(255) DEFAULT NULL COMMENT "code-generated description for non-move events", | |||
`Notes` VARCHAR(255) DEFAULT NULL COMMENT "optional explanatory notes", | |||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) ENGINE = MYISAM;</mysql> | ) ENGINE = MYISAM;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
Revision as of 00:40, 21 December 2009
About
- Purpose: Documents things which happen to a stock bin -- usually changes to Template:Vbzcart data, but can also log collective movement of items to/from bins
- History:
- 2009-11-07 Added "Descr" field and made ID_Srce/ID_Dest NOT NULL
- 2009-12-20 Added fields WhoAdmin, WhoSystem, WhoNetwork
- Fields:
- Descr is for events other than moving, e.g. field changes or stock recounts
SQL
<section begin=sql /><mysql>DROP TABLE IF EXISTS `stk_bin_history`; CREATE TABLE `stk_bin_history` (
`ID` INT NOT NULL AUTO_INCREMENT, `ID_Bin` INT NOT NULL COMMENT "stk_bins.ID of bin being moved", `WhenDone` DATETIME NOT NULL COMMENT "when the move happened", `WhoAdmin` VARCHAR(127) NOT NULL COMMENT "VbzCart admin username", `WhoSystem` VARCHAR(127) DEFAULT NULL COMMENT "who logged into the operating system, if using non-web client app", `WhoNetwork` VARCHAR(64) NOT NULL COMMENT "network name or IP address of client machine", `ID_Srce` INT NOT NULL COMMENT "stk_places.ID of where the bin came from (NULL = new bin)", `ID_Dest` INT NOT NULL COMMENT "stk_places.ID of where the bin was moved to (NULL = bin destroyed)", `Descr` VARCHAR(255) DEFAULT NULL COMMENT "code-generated description for non-move events", `Notes` VARCHAR(255) DEFAULT NULL COMMENT "optional explanatory notes", PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql> <section end=sql />