VbzCart/docs/tables/shop log

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search

About

  • Status: design is under construction
  • Purpose: logs customer movement through the store, for analysis of usage patterns and looking for problems

SQL

<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_log`; CREATE TABLE `shop_log` ( 

 `ID`         INT      NOT NULL AUTO_INCREMENT,
 `ID_Client`  INT      NOT NULL COMMENT "shop_clients.ID",
 `EvWhen`     DATETIME NOT NULL COMMENT "When this event occurred",
 `Code`       INT      NOT NULL COMMENT "type of event",
 `Descr`      VARCHAR(255) DEFAULT NULL COMMENT "Any details specific to this occurrence",
 `Notes`      VARCHAR(255) DEFAULT NULL COMMENT "Human-entered notes",
 PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>

<section end=sql />

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/tables/shop_log&oldid=6963"