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

< VbzCart‎ | tables

Revision as of 11:14, 2 June 2017 by Woozle (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

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"

obsolete