VbzCart/docs/tables/shop cart data: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
(Type -> ID_Type)
imported>Woozle
("WhenCrypt" field)
Line 1: Line 1:
==About==
==About==
* '''Purpose''': This is a simple table for retaining customer data entered at check-out time before converting the cart to an order.
* '''Purpose''': This is a simple table for retaining customer data entered at check-out time before converting the cart to an order.
* '''Relates to''': {{l/same|shop_cart}}
* '''Relates to''': parent: {{l/same|shop_cart}}
* '''History''':
* '''History''':
** '''2009-07-24''' renamed: shop_cust_data -> shop_cart_data; changed ID_Key -> Type
** '''2009-07-24''' renamed: shop_cust_data -> shop_cart_data; changed ID_Key -> Type
** '''2009-08-02''' removed "ID" field; now using ID_Cart+Type as primary key
** '''2009-08-02''' removed "ID" field; now using ID_Cart+Type as primary key
** '''2014-11-04''' renamed "Type" field to "ID_Type"
** '''2014-11-04''' renamed "Type" field to "ID_Type"
** '''2015-01-20''' added '''WhenCrypt''' field
==Notes==
The "WhenCrypt" field is primarily a signal that "Val" has been encrypted. If it is NULL, then "Val" is plaintext. This is so we can encrypt sensitive data left in shopping carts.
==SQL==
==SQL==
<mysql>DROP TABLE IF EXISTS `shop_cart_data`;
<mysql>DROP TABLE IF EXISTS `shop_cart_data`;
CREATE TABLE `shop_cart_data` (
CREATE TABLE `shop_cart_data` (
   `ID_Cart`    INT NOT NULL COMMENT "shop_cart.ID",
   `ID_Cart`    INT NOT NULL COMMENT "shop_cart.ID",
   `ID_Type`       INT NOT NULL COMMENT "data type - defined in code",
   `ID_Type`   INT NOT NULL COMMENT "data type - defined in code",
   `Val`        VARCHAR(255) NOT NULL COMMENT "Value of data item",
   `Val`        VARCHAR(255) NOT NULL COMMENT "Value of data item",
  `WhenCrypt`  DATETIME DEFAULT NULL "when encrypted (NULL = is plaintext)",
   PRIMARY KEY(`ID_Cart`,`Type`)
   PRIMARY KEY(`ID_Cart`,`Type`)
  ) ENGINE = MYISAM;</mysql>
  ) ENGINE = MYISAM;</mysql>

Revision as of 19:08, 20 January 2015

About

  • Purpose: This is a simple table for retaining customer data entered at check-out time before converting the cart to an order.
  • Relates to: parent: shop_cart
  • History:
    • 2009-07-24 renamed: shop_cust_data -> shop_cart_data; changed ID_Key -> Type
    • 2009-08-02 removed "ID" field; now using ID_Cart+Type as primary key
    • 2014-11-04 renamed "Type" field to "ID_Type"
    • 2015-01-20 added WhenCrypt field

Notes

The "WhenCrypt" field is primarily a signal that "Val" has been encrypted. If it is NULL, then "Val" is plaintext. This is so we can encrypt sensitive data left in shopping carts.

SQL

<mysql>DROP TABLE IF EXISTS `shop_cart_data`; CREATE TABLE `shop_cart_data` ( 

 `ID_Cart`    INT NOT NULL COMMENT "shop_cart.ID",
 `ID_Type`    INT NOT NULL COMMENT "data type - defined in code",
 `Val`        VARCHAR(255) NOT NULL COMMENT "Value of data item",
 `WhenCrypt`  DATETIME DEFAULT NULL "when encrypted (NULL = is plaintext)",
 PRIMARY KEY(`ID_Cart`,`Type`)
) ENGINE = MYISAM;</mysql>
Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/tables/shop_cart_data&oldid=6115"