Difference between revisions of "VbzCart/tables/ord pull"
Jump to navigation
Jump to search
(expanded "Notes" field) |
m (markup fix) |
||
(8 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | {{hdr/status/obsolete|The {{l/vbzcart/table|ord_pull}} table is being replaced by {{l/vbzcart/table|event_vc_ord_change}}. See {{l/sub|migration}} for details.}} | ||
==About== | ==About== | ||
* '''Purpose''': Log of order pulls/releases | * '''Purpose''': Log of order pulls/releases | ||
− | * '''Notes''': this | + | * '''Notes''': this will eventually be replaced by {{vbzcart|table|ord_change}} |
* '''Relates to''': {{vbzcart|table|core_orders}}, {{vbzcart|table|ord_pull_type}} | * '''Relates to''': {{vbzcart|table|core_orders}}, {{vbzcart|table|ord_pull_type}} | ||
* '''Fields''': | * '''Fields''': | ||
− | ** '''WhenFreed''' (was '''WhenReleased'''): when the pull was cancelled/revoked; | + | ** '''WhenFreed''' (was '''WhenReleased'''): when the pull was cancelled/revoked; if it is set, this pull is inactive |
− | ** '''Notes''' may include quite lengthy explanations of what happened (similar to {{vbzcart|table|ord_msg}}) | + | ** '''Notes*''' may include quite lengthy explanations of what happened (similar to {{vbzcart|table|ord_msg}}) |
* '''History''': | * '''History''': | ||
** '''2009-07-09''' Adapted from MS Access | ** '''2009-07-09''' Adapted from MS Access | ||
** '''2009-07-10''' Expanded "Notes" from VARCHAR(255) to MEDIUMTEXT | ** '''2009-07-10''' Expanded "Notes" from VARCHAR(255) to MEDIUMTEXT | ||
+ | ** '''2009-10-27''' Added user/machine fields; Notes -> NotesPull, added NotesFree | ||
+ | *** This should ease the transition to using the {{vbzcart|table|ord_change}} table | ||
+ | ** '''2017-06-02''' Migrating to {{l/vbzcart/table|event_vc_ord_hold}}; documenting {{l/sub|migration}} process. | ||
==SQL== | ==SQL== | ||
− | < | + | <source lang=mysql>CREATE TABLE `ord_pull` ( |
`ID` INT NOT NULL AUTO_INCREMENT, | `ID` INT NOT NULL AUTO_INCREMENT, | ||
`ID_Ord` INT NOT NULL COMMENT "core_orders.ID", | `ID_Ord` INT NOT NULL COMMENT "core_orders.ID", | ||
Line 16: | Line 20: | ||
`WhenPulled` DATETIME NOT NULL COMMENT "when this pull occurred", | `WhenPulled` DATETIME NOT NULL COMMENT "when this pull occurred", | ||
`WhenFreed` DATETIME DEFAULT NULL COMMENT "when this pull was dropped", | `WhenFreed` DATETIME DEFAULT NULL COMMENT "when this pull was dropped", | ||
− | ` | + | /* fields relating to who pulled the order */ |
+ | `VbzUser` VARCHAR(127) COMMENT "VbzCart username, if available", | ||
+ | `SysUser` VARCHAR(127) COMMENT "operating system username, if available", | ||
+ | `Machine` VARCHAR(63) NOT NULL COMMENT "network name or IP address of client", | ||
+ | `NotesPull` MEDIUMTEXT DEFAULT NULL COMMENT "human-added notes about the pull", | ||
+ | `NotesFree` MEDIUMTEXT DEFAULT NULL COMMENT "human-added notes about the release", | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) | ) | ||
− | ENGINE = MYISAM;</ | + | ENGINE = MYISAM;</source> |
− |
Latest revision as of 15:44, 26 February 2020
This documentation is obsolete, and is being kept solely for archival purposes. |
About
- Purpose: Log of order pulls/releases
- Notes: this will eventually be replaced by ord_change
- Relates to: core_orders, ord_pull_type
- Fields:
- WhenFreed (was WhenReleased): when the pull was cancelled/revoked; if it is set, this pull is inactive
- Notes* may include quite lengthy explanations of what happened (similar to ord_msg)
- History:
- 2009-07-09 Adapted from MS Access
- 2009-07-10 Expanded "Notes" from VARCHAR(255) to MEDIUMTEXT
- 2009-10-27 Added user/machine fields; Notes -> NotesPull, added NotesFree
- This should ease the transition to using the ord_change table
- 2017-06-02 Migrating to event_vc_ord_hold; documenting migration process.
SQL
CREATE TABLE `ord_pull` (
`ID` INT NOT NULL AUTO_INCREMENT,
`ID_Ord` INT NOT NULL COMMENT "core_orders.ID",
`ID_Type` INT NOT NULL COMMENT "ord_pull_type.ID",
`WhenPulled` DATETIME NOT NULL COMMENT "when this pull occurred",
`WhenFreed` DATETIME DEFAULT NULL COMMENT "when this pull was dropped",
/* fields relating to who pulled the order */
`VbzUser` VARCHAR(127) COMMENT "VbzCart username, if available",
`SysUser` VARCHAR(127) COMMENT "operating system username, if available",
`Machine` VARCHAR(63) NOT NULL COMMENT "network name or IP address of client",
`NotesPull` MEDIUMTEXT DEFAULT NULL COMMENT "human-added notes about the pull",
`NotesFree` MEDIUMTEXT DEFAULT NULL COMMENT "human-added notes about the release",
PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;