Table customers basket attributes
From Zen Cart(tm) Wiki
Contents
Database Version
- 1.3.5
Description
- Stores the attributes for each product added to the customer's shopping cart prior to checking out.
- This information is read from the database when the customer logs in, since "login" causes any saved shopping-cart data to be read from the database and restored into their current cart (and added to anything they may have just added prior to logging in).
- Data is only written to this table when a customer's login session times out or they log out.
- When an order is placed, the orders class takes the information in the currently active cart and transfers the order details from the cart into the orders_products_attributes table, constituting part of the order placed.
Table Details
Primary Key
Indexed Fields
Columns
customers_basket_attributes_id 
- A unique, auto incremented value, to identify each customers basket attributes record.
Type: int(11) Null: No Default: Extra: auto_increment
customers_id 
- Links the specific customers basket attributes record to the customer that created it.
Type: int(11) Null: No Default: 0
products_id
- Links the specific customers basket attributes record to the product that it's attached to.
Type: tinytext Null: No Default:
products_options_id
- The record number from the products_options table related to the attributes stored in the cart contents.
Type: varchar(64) Null: No Default: 0
products_options_value_id
- The record number of the related products_options_values table record for the option-value of attributes stored in the cart contents
Type: int(11) Null: No Default: 0
products_options_value_text
- The text components associated with related attributes stored in the cart contents.
Type: blob Attributes: BINARY Null: Yes Default: NULL
products_options_sort_order
- The sort order of the given product option.
Type: text Null: No Default:
Default Entries
- None.
