VbzCart/docs/tables/shop cart

About

• Purpose: Shopping cart data is kept separate from order data because we end up with a lot of carts that never become orders; eventually they get cleaned out. Order data may eventually get cleaned out too, but with different criteria; for now, we are keeping order data indefinitely.
• Relations:
  • each Template:Vbzcart has zero or one Template:Vbzcart record (it's only zero until the order is placed)
  • each Template:Vbzcart record has exactly one Template:Vbzcart
  • each Template:Vbzcart has zero or one Template:Vbzcart record (it's only zero until the order is placed, but ID_Cust isn't necessarily filled in when this happens)
  • each Template:Vbzcart record has one or more Template:Vbzcarts and one or more Template:Vbzcart
• Fields:
  • ID_Cust is for future use when customers can log in to retrieve their personal data
  • ID_Session is for future use when sessions are tracked
• History:
  • 2009-06-16 Changing names to singular (tables not in use yet, so this is the time to do it)
  • 2009-07-10 removing ID_Session: each session ties to a cart, not vice-versa

SQL

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

 `ID`          INT          NOT NULL AUTO_INCREMENT,
 `WhenCreated` DATETIME     NOT NULL COMMENT "when the cart was first created",
 `WhenViewed`  DATETIME DEFAULT NULL COMMENT "when the cart's contents were last displayed by the customer",
 `WhenUpdated` DATETIME DEFAULT NULL COMMENT "when the cart's contents were last changed",
 `WhenOrdered` DATETIME DEFAULT NULL COMMENT "when the cart's contents were transferred to an order",
 `ID_Order`    INT      DEFAULT NULL COMMENT "core_orders.ID of order into which cart was transferred",
 `ID_Cust`     INT      DEFAULT NULL COMMENT "core_custs.ID of customer for this order",
  PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>

<section end=sql />