VbzCart/tables/ord pull type

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

This documentation is obsolete, and is being kept solely for archival purposes.
This table (ord_pull_type) has been replaced by ord_hold_type.

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>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/tables/ord_pull_type&oldid=22687"