👤 Magento_Wishlist · engine innodb

wishlist

Wishlist main Table

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

flowchart LR
  c["wishlist"]:::center
  n0["customer_entity"]
  click n0 "/schema/table/customer_entity"
  n0 -- customer_id --> c
  n1["wishlist_item"]
  click n1 "/schema/table/wishlist_item"
  c -- wishlist_id --> n1
  click c "/schema/table/wishlist"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (2)

customer_id → customer_entity wishlist_item → wishlist_id

Columns (5)

Name	Type	Null	Default	Comment
wishlist_id PK	int unsigned	no		Wishlist ID
customer_id	int unsigned	no	0	Customer ID
shared	smallint unsigned	no	0	Sharing flag (0 or 1)
sharing_code	varchar(32)	yes		Sharing encrypted code
updated_at	timestamp	yes		Last updated date

Keys & indexes

Primary key: wishlist_id

Unique

WISHLIST_CUSTOMER_ID (customer_id)

Indexes

WISHLIST_SHARED (shared) btree

References (1)

customer_id → customer_entity .entity_id (on delete CASCADE)

Referenced by (1)

wishlist_item .wishlist_id → .wishlist_id (on delete CASCADE)