Difference between revisions of "VbzCart/tables/ord pull"
Jump to navigation
Jump to search
(New page: ==About== * '''Purpose''': Log of order pulls/releases * '''Notes''': this should probably be expanded into an order-related event log * '''Relates to''': {{vbzcart|table|core_orders}}, {{...) |
(expanded "Notes" field) |
||
Line 5: | Line 5: | ||
* '''Fields''': | * '''Fields''': | ||
** '''WhenFreed''' (was '''WhenReleased'''): when the pull was cancelled/revoked; NOT NULL means this pull is inactive | ** '''WhenFreed''' (was '''WhenReleased'''): when the pull was cancelled/revoked; NOT NULL means this pull is inactive | ||
+ | ** '''Notes''' may include quite lengthy explanations of what happened (similar to {{vbzcart|table|ord_msg}}) | ||
* '''History''': | * '''History''': | ||
** '''2009-07-09''' Adapted from MS Access | ** '''2009-07-09''' Adapted from MS Access | ||
+ | ** '''2009-07-10''' Expanded "Notes" from VARCHAR(255) to MEDIUMTEXT | ||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE TABLE `ord_pull` ( | <section begin=sql /><mysql>CREATE TABLE `ord_pull` ( | ||
− | `ID` INT | + | `ID` INT NOT NULL AUTO_INCREMENT, |
− | `ID_Ord` INT | + | `ID_Ord` INT NOT NULL COMMENT "core_orders.ID", |
− | `ID_Type` INT | + | `ID_Type` INT NOT NULL COMMENT "ord_pull_type.ID", |
− | `WhenPulled` DATETIME | + | `WhenPulled` DATETIME NOT NULL COMMENT "when this pull occurred", |
− | `WhenFreed` DATETIME | + | `WhenFreed` DATETIME DEFAULT NULL COMMENT "when this pull was dropped", |
− | `Notes` | + | `Notes` MEDIUMTEXT DEFAULT NULL COMMENT "human-added notes", |
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) | ) | ||
ENGINE = MYISAM;</mysql> | ENGINE = MYISAM;</mysql> | ||
<section end=sql /> | <section end=sql /> |
Revision as of 11:41, 10 July 2009
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
- Notes may include quite lengthy explanations of what happened (similar to ord_msg)
- History:
- 2009-07-09 Adapted from MS Access
- 2009-07-10 Expanded "Notes" from VARCHAR(255) to MEDIUMTEXT
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` MEDIUMTEXT DEFAULT NULL COMMENT "human-added notes", PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>