VbzCart/tables/ord event

From HTYP, the free directory anyone can edit

[edit] About

• Purpose: for tracking internally-generated events which (generally) do not affect the order's status
• History:
  • 2009-10-18 Created
• Fields:
  • VbzUser is the user's wiki username, and only applies to events initiated through the wiki user interface

[edit] SQL

CREATE TABLE `ord_event` (
  `ID`             INT         NOT NULL AUTO_INCREMENT,
  `ID_Ord`         INT         NOT NULL COMMENT "core_orders.ID",
  `WhenDone`  DATETIME         NOT NULL COMMENT "when the event happened",
  `WhatCode`  VARCHAR(7)       NOT NULL COMMENT "informal event type code",
  `VbzUser`   VARCHAR(127)              COMMENT "VbzCart username of whoever initiated the event, if available",
  `SysUser`   VARCHAR(127)              COMMENT "who logged into the operating system, if available",
  `Machine`   VARCHAR(63)      NOT NULL COMMENT "network name or IP address of client",
  `Descr`     VARCHAR(255) DEFAULT NULL COMMENT "human-readable description of what happened",
  `Notes`     VARCHAR(255) DEFAULT NULL COMMENT "human-entered notes, if needed",
  PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;