Table customers basket

From Zen Cart(tm) Wiki
Revision as of 12:41, 8 September 2006 by Allcanadiansearch.ca (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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

customers_basket_id

Indexed Fields

customers_id


Columns

customers_basket_id Primary Key

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


customers_id Index

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.