VbzCart/tables/ord pull

About

• Purpose: Log of order pulls/releases
• Notes: this should probably be expanded into an order-related event log
• Relates to: core_orders, ord_pull_type
• Fields:
  • WhenFreed (was WhenReleased): when the pull was cancelled/revoked; NOT NULL means this pull is inactive
• History:
  • 2009-07-09 Adapted from MS Access

SQL

<mysql>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",
 `Notes`     VARCHAR(255) DEFAULT NULL COMMENT "human-added notes",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>