Difference between revisions of "VbzCart/tables/shop cart data"
Jump to navigation
Jump to search
(Type -> ID_Type) |
("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` | + | `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>