Difference between revisions of "VbzCart/tables/ord pull type"
Jump to navigation
Jump to search
(Group->OptionGroup) |
m |
||
(One intermediate revision by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | {{hdr/status/obsolete|This table (ord_pull_type) has been replaced by {{l/vbzcart/table|ord_hold_type}}.}} | ||
==About== | ==About== | ||
* '''Used by''': {{vbzcart|table|ord_pull}} | * '''Used by''': {{vbzcart|table|ord_pull}} |
Latest revision as of 11:14, 2 June 2017
This documentation is obsolete, and is being kept solely for archival purposes. |
About
- Used by: ord_pull
- History:
- 2009-07-09 adapted from MS Access (was: [Order Pull Types])
- 2016-03-06
- changed Notes to Reason, because it's actually kind of important
- added OptionGroup field (originally "Group", but that's a reserved word)
SQL
<mysql>CREATE TABLE `ord_pull_type` (
`ID` INT NOT NULL AUTO_INCREMENT, `Name` VARCHAR(31) NOT NULL COMMENT "brief name for this pull type", `Reason` VARCHAR(255) DEFAULT NULL COMMENT "reason why this type would be used", `OptionGroup` VARCHAR(45) DEFAULT NULL COMMENT "Optional grouping for drop-down lists",
PRIMARY KEY(`ID`) ) ENGINE = MYISAM;</mysql>