Table customers basket
From Zen Cart(tm) Wiki
Contents |
Database Version
- 1.3.5
Description
- Stores all the items placed in the customers shopping cart. Each shopping cart can hold multiple items with one database entry for each.
Table Details
Primary Key
Indexed Fields
Columns
customers_basket_id 
- A unique, auto incremented value, to identify each customer basket record.
Type: int(11) Null: No Default: Extra: auto_increment
customers_id 
- Links the specific customers basket record to the customer that created it.
Type: int(11) Null: No Default: 0
products_id
- The product id of the item stored in the customers basket.
Type: tinytext Null: No Default:
customers_basket_quantity
- The quantity of the item stored in the customers basket.
Type: float Null: No Default: 0
final_price
- The total price of the item stored in the customers basket in the default currency (based on product price x quantity).
Type: decimal(15,4) Null: No Default: 0.0000
customers_basket_date_added
- The date that the specific item was added to the customers basket.
Type: varchar(8) Null: Yes Default: NULL
Default Entries
- None.
