Table customers wishlist

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

Database Version

1.3.5


Description

Stores all the items that the customer adds to their wishlist.


Reserved for a future feature of Zen Cart. Not used in 1.3.5. All descriptions and details are likely to change once this feature is implemented. Merely added in the interest of completeness.


Table Details

Primary Key

None.

Indexed Fields

None.


Columns

products_id

The products id of the item in the customer's wishlist.
Type: int(13)
Null: No
Default: 0


customers_id

The customer id of the customer that added the item to the wishlist.
Type: int(13)
Null: No
Default: 0


products_model

The products model of the item in the customer's wishlist.
Type: varchar(13)
Null: Yes
Default: NULL


products_name

The products name of the item in the customer's wishlist.
Type: varchar(64)
Null: No
Default:


products_price

The price of the item in the customer's wishlist.
Type: decimal(8,2)
Null: No
Default: 0.00


final_price

The final price of the item in the customer's wishlist.
Type: decimal(8,2)
Null: No
Default: 0.00


products_quantity

The quantity of a given item in the customer's wishlist.
Type: int(2)
Null: No
Default: 0


wishlist_name

The name of the customer's wishlist.
Type: varchar(64)
Null: Yes
Default: NULL


Default Entries

None.