👤 Magento_Wishlist · engine innodb

wishlist_item

Wishlist items

Neighbourhood (1-hop foreign-key graph — showing 4 of 4)

flowchart LR
  c["wishlist_item"]:::center
  n0["wishlist"]
  click n0 "/schema/table/wishlist"
  n0 -- wishlist_id --> c
  n1["catalog_product_entity"]
  click n1 "/schema/table/catalog_product_entity"
  n1 -- product_id --> c
  n2["store"]
  click n2 "/schema/table/store"
  n2 -- store_id --> c
  n3["wishlist_item_option"]
  click n3 "/schema/table/wishlist_item_option"
  c -- wishlist_item_id --> n3
  click c "/schema/table/wishlist_item"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (4)

wishlist_id → wishlist product_id → catalog_product_entity store_id → store wishlist_item_option → wishlist_item_id

Columns (7)

Name	Type	Null	Default	Comment
wishlist_item_id PK	int unsigned	no		Wishlist item ID
wishlist_id	int unsigned	no	0	Wishlist ID
product_id	int unsigned	no	0	Product ID
store_id	smallint unsigned	yes		Store ID
added_at	timestamp	yes		Add date and time
description	text	yes		Short description of wish list item
qty	decimal	no		Qty

Keys & indexes

Primary key: wishlist_item_id

Indexes

WISHLIST_ITEM_WISHLIST_ID (wishlist_id) btree
WISHLIST_ITEM_PRODUCT_ID (product_id) btree
WISHLIST_ITEM_STORE_ID (store_id) btree

References (3)

wishlist_id → wishlist .wishlist_id (on delete CASCADE)
product_id → catalog_product_entity .entity_id (on delete CASCADE)
store_id → store .store_id (on delete SET NULL)

Referenced by (1)

wishlist_item_option .wishlist_item_id → .wishlist_item_id (on delete CASCADE)