Table customers basket attributes

From Zen Cart(tm) Wiki
Jump to: navigation, search

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

customers_basket_attributes_id

Indexed Fields

customers_id
products_id


Columns

customers_basket_attributes_id Primary Key

A unique, auto incremented value, to identify each customers basket attributes record.
Type: int(11)
Null: No
Default:
Extra: auto_increment


customers_id Index

Links the specific customers basket attributes record to the customer that created it.
Type: int(11)
Null: No
Default: 0


products_id Index

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.