Difference between revisions of "VbzCart/tables/stk bin history"
Jump to navigation
Jump to search
m (→About: table name correction) |
(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 stk_bins 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
<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>