Ferreteria/sql/event

About

• Purpose: base table for logging application events
  • Records only the basic information common to all (or nearly all) events.

History

• 2017-05-06 Adapting the good bits from VbzCart/tables/event log

SQL

<mysql>CREATE TABLE `event` (

   ID         INT              NOT NULL AUTO_INCREMENT COMMENT "log line identifier",
   WhenStart  DATETIME         NOT NULL COMMENT "set just before starting the event",
   ID_Session INT              NOT NULL COMMENT "session.ID of active session",
   TypeCode    VARCHAR(7)  DEFAULT NULL COMMENT "mnemonic event code",
   Descrip    TEXT         DEFAULT NULL COMMENT "code-generated description of event",
   Stash      TEXT         DEFAULT NULL COMMENT "additional event-related data that doesn't need to be searchable",
   PRIMARY KEY (`ID`)
) ENGINE = InnoDB;</mysql>