VbzCart/tables/ord msg - Revision history

Woozle: future: messaging subsystem

2010-09-23T11:59:54Z

future: messaging subsystem

← Older revision		Revision as of 11:59, 23 September 2010
Line 13:		Line 13:
	** '''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		** '''Notes''' may contain the substance of the message record, because sometimes it's more about what happened than about a single message being transferred
			* '''Future''':
			** Possibly message relaying should be handled by a separate app, but if not it needs to be rethought a bit:
			*** {{vbzcart\|table\|ord_msg_media}} should probably include a flag to indicate if a given medium (method?) needs human relaying (NO = automatic, like email)
			*** Is '''WhenRelayed''' basically the mirror of '''WhenCreated''', just in the other direction? Or can they both have meaning in the same context?
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `ord_msg` (		<section begin=sql /><mysql>CREATE TABLE `ord_msg` (

Woozle: ord_pulls -> ord_pull

2010-09-22T11:41:48Z

ord_pulls -> ord_pull

← Older revision		Revision as of 11:41, 22 September 2010
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 -- possibly should be part of the order event log, along with {{vbzcart\|table\|~~ord_pulls~~}}		* '''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_pull}}
	* '''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''':

Woozle: made "Notes" field wider

2009-07-10T11:33:48Z

made "Notes" field wider

← Older revision		Revision as of 11:33, 10 July 2009
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` ~~VARCHAR(255)~~ DEFAULT NULL COMMENT "internal 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 />

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...

2009-07-10T01:19:40Z

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...

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
* '''Relates to''': {{vbzcart|table|core_orders}}, {{vbzcart|table|ord_pkgs}}, {{vbzcart|table|ord_msg_media}}
* '''History''':
** '''2009-07-09''' Adapted from MS Access
* '''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
==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` VARCHAR(255) DEFAULT NULL COMMENT "internal notes",
PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>
<section end=sql />