VbzCart/tables/ord pull type
Jump to navigation
Jump to search
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>