VbzCart/tables/ord hold type

About

• Purpose: Admin-maintained table for different types of order-related events and how the order itself is affected by each event of that type
• Relates to: ord_events
• Background: See ord_events
• History:
  • 2008-12-27 Extracted from main "tables" listing, no design changes; no documentation yet, either
  • 2009-07-12 Removed isActive field; added "Hold" to field names for directional consistency (+1 always turns on an alert); preliminary documentation
• Fields:
  • doHoldRstk - alert flag
  • doHoldChrg - alert flag
  • doContact - alert flag
  • doExamine - alert flag

alert flags

The alert flag fields each have 3 possible values:

0 = no change

+1 = FORBID / TURN ON ALERT

-1 = ALLOW / TURN OFF ALERT

Each one affects the corresponding field in the order (not yet implemented as of 2009-07-12) as described above when an event of the type defined in this record occurs

If the order has any one of these flags set, then the order is "on hold".

SQL

<mysql>CREATE TABLE `ord_event_types` (

 `ID`           INT NOT NULL AUTO_INCREMENT,
 `Display`      VARCHAR(63) COMMENT "brief name for this event type",
 `Descr`        VARCHAR(127) COMMENT "longer description of usage",
 `doHoldRstk` TINYINT COMMENT "forbid(+1)/allow(-1) restocking this order's items",
 `doHoldChrg` TINYINT COMMENT "forbid(+1)/allow(-1) charging bank card for this order",
 `doContact`  TINYINT COMMENT "turn on(+1)/off(-1) need-to-contact flag for this order",
 `doExamine`  TINYINT COMMENT "turn on(+1)/off(-1) need-to-examine flag for this order",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>