Difference between revisions of "VbzCart/tables/event vc ord hold/2009"
< VbzCart | tables | event vc ord hold
Jump to navigation
Jump to search
m (Woozle moved page VbzCart/tables/event vc ord change/2009 to VbzCart/tables/event vc ord hold/2009: see in-page history) |
(removing references to moved pages; post-mortem) |
||
| Line 1: | Line 1: | ||
==Backstory== | ==Backstory== | ||
| − | I apparently designed this and its "types" table ({{l/vbzcart/table| | + | I apparently designed this and its "types" table (ord_change_type, now renamed to {{l/vbzcart/table|ord_hold_type}}) sometime in 2008, but didn't document them; a note on the former ord_change_type page dated 2008-12-27 said "Are we actually using this, or is it part of the future online ordering system redesign?" |
As of 2009-07, though, it has become clear that a general order log seems necessary for the following reasons: | As of 2009-07, though, it has become clear that a general order log seems necessary for the following reasons: | ||
| Line 12: | Line 12: | ||
* '''2009-07-12''' | * '''2009-07-12''' | ||
** Preliminary documentation | ** Preliminary documentation | ||
| − | ** Added '''isActive''' field (was in | + | ** Added '''isActive''' field (was in ord_change_type, didn't belong there) |
** Added '''VbzUser''' and '''Machine''' fields | ** Added '''VbzUser''' and '''Machine''' fields | ||
** Renamed to singular form | ** Renamed to singular form | ||
| Line 19: | Line 19: | ||
** Added '''SysUser''', for consistency with other event log tables | ** Added '''SysUser''', for consistency with other event log tables | ||
** Renamed from '''ord_event''' to '''ord_change'''; using '''{{l/vbzcart/table|ord_event}}''' for stateless/internal events | ** Renamed from '''ord_event''' to '''ord_change'''; using '''{{l/vbzcart/table|ord_event}}''' for stateless/internal events | ||
| + | |||
| + | ==Post-Mortem== | ||
| + | * '''2017-06-02''' It looks like the non-pull(hold)-related needs here may have been addressed by creating the EventPlex system. | ||
Latest revision as of 11:21, 2 June 2017
Backstory
I apparently designed this and its "types" table (ord_change_type, now renamed to ord_hold_type) sometime in 2008, but didn't document them; a note on the former ord_change_type page dated 2008-12-27 said "Are we actually using this, or is it part of the future online ordering system redesign?"
As of 2009-07, though, it has become clear that a general order log seems necessary for the following reasons:
- To replace the ord_pull table
- To make it unnecessary to track user details inside other order-related records
- To keep an automatic record of all changes made to an order and any significant processing events
The system implemented here of defining event types which may or may not block certain things seems compatible with this goal, and we mainly just needed to add fields for user-tracking.
History Details
- 2009-07-12
- Preliminary documentation
- Added isActive field (was in ord_change_type, didn't belong there)
- Added VbzUser and Machine fields
- Renamed to singular form
- 2009-10-18
- Replaced isActive field with do* fields
- Added SysUser, for consistency with other event log tables
- Renamed from ord_event to ord_change; using ord_event for stateless/internal events
Post-Mortem
- 2017-06-02 It looks like the non-pull(hold)-related needs here may have been addressed by creating the EventPlex system.