Table customers basket
From Zen Cart(tm) Wiki
Revision as of 12:41, 8 September 2006 by Allcanadiansearch.ca
- Stores all the items placed in the customers shopping cart. Each shopping cart can hold multiple items with one database entry for each.
- A unique, auto incremented value, to identify each customer basket record.
Type: int(11) Null: No Default: Extra: auto_increment
- Links the specific customers basket record to the customer that created it.
Type: int(11) Null: No Default: 0
- The product id of the item stored in the customers basket.
Type: tinytext Null: No Default:
- The quantity of the item stored in the customers basket.
Type: float Null: No Default: 0
- 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
- The date that the specific item was added to the customers basket.
Type: varchar(8) Null: Yes Default: NULL