VbzCart/docs/tables/ord msg: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (New page: ==About== * '''Purpose''': Record of messages sent/received about this order * '''Notes''': This subsystem should probably be rethought at some point when everything else is working * '''R...) |
imported>Woozle (made "Notes" field wider) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': Record of messages sent/received about this order | * '''Purpose''': Record of messages sent/received about this order | ||
* '''Notes''': This subsystem should probably be rethought at some point when everything else is working | * '''Notes''': This subsystem should probably be rethought at some point when everything else is working -- possibly should be part of the order event log, along with {{vbzcart|table|ord_pulls}} | ||
* '''Relates to''': {{vbzcart|table|core_orders}}, {{vbzcart|table|ord_pkgs}}, {{vbzcart|table|ord_msg_media}} | * '''Relates to''': {{vbzcart|table|core_orders}}, {{vbzcart|table|ord_pkgs}}, {{vbzcart|table|ord_msg_media}} | ||
* '''History''': | * '''History''': | ||
** '''2009-07-09''' Adapted from MS Access | ** '''2009-07-09''' Adapted from MS Access | ||
** '''2009-07-10''' Changed "Notes" from VARCHAR(255) to MEDIUMTEXT | |||
* '''Fields''': | * '''Fields''': | ||
** '''TxtFrom''' (was "From") | ** '''TxtFrom''' (was "From") | ||
| Line 11: | Line 12: | ||
** '''doRelay''': does message need to be sent to a third party? (this has a specific meaning, but if I can't remember/reconstruct what it was... are any records using it?) | ** '''doRelay''': does message need to be sent to a third party? (this has a specific meaning, but if I can't remember/reconstruct what it was... are any records using it?) | ||
** '''WhenRelayed''' should only ever be set if '''doRelay''' is TRUE | ** '''WhenRelayed''' should only ever be set if '''doRelay''' is TRUE | ||
** '''Notes''' may contain the substance of the message record, because sometimes it's more about what happened than about a single message being transferred | |||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE TABLE `ord_msg` ( | <section begin=sql /><mysql>CREATE TABLE `ord_msg` ( | ||
| Line 25: | Line 27: | ||
`WhenRelayed` DATETIME DEFAULT NULL COMMENT "when message was relayed", | `WhenRelayed` DATETIME DEFAULT NULL COMMENT "when message was relayed", | ||
`Message` MEDIUMTEXT NOT NULL COMMENT "the message", | `Message` MEDIUMTEXT NOT NULL COMMENT "the message", | ||
`Notes` | `Notes` MEDIUMTEXT DEFAULT NULL COMMENT "internal notes", | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) | ) | ||
ENGINE = MYISAM;</mysql> | ENGINE = MYISAM;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
Revision as of 11:33, 10 July 2009
About
- Purpose: Record of messages sent/received about this order
- Notes: This subsystem should probably be rethought at some point when everything else is working -- possibly should be part of the order event log, along with Template:Vbzcart
- Relates to: Template:Vbzcart, Template:Vbzcart, Template:Vbzcart
- History:
- 2009-07-09 Adapted from MS Access
- 2009-07-10 Changed "Notes" from VARCHAR(255) to MEDIUMTEXT
- Fields:
- TxtFrom (was "From")
- TxtTo (was "To")
- TxtRe (was "Subject")
- doRelay: does message need to be sent to a third party? (this has a specific meaning, but if I can't remember/reconstruct what it was... are any records using it?)
- WhenRelayed should only ever be set if doRelay is TRUE
- Notes may contain the substance of the message record, because sometimes it's more about what happened than about a single message being transferred
SQL
<section begin=sql /><mysql>CREATE TABLE `ord_msg` (
`ID` INT NOT NULL AUTO_INCREMENT, `ID_Ord` INT NOT NULL COMMENT "core_orders.ID", `ID_Pkg` INT DEFAULT NULL COMMENT "ord_pkgs.ID", `ID_Media` INT NOT NULL COMMENT "ord_msg_media.ID", `TxtFrom` VARCHAR(63) DEFAULT NULL COMMENT "who this message is from", `TxtTo` VARCHAR(63) DEFAULT NULL COMMENT "who this message is to", `TxtRe` VARCHAR(127) DEFAULT NULL COMMENT "subject of message", `doRelay` BOOL DEFAULT NULL COMMENT "YES = this message needs to be relayed", `WhenCreated` DATETIME DEFAULT NULL COMMENT "when message was originally created", `WhenEntered` DATETIME DEFAULT NULL COMMENT "when message was entered into database", `WhenRelayed` DATETIME DEFAULT NULL COMMENT "when message was relayed", `Message` MEDIUMTEXT NOT NULL COMMENT "the message", `Notes` MEDIUMTEXT DEFAULT NULL COMMENT "internal notes", PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql> <section end=sql />