📦 Magento_Catalog · engine innodb

catalog_product_frontend_action

Catalog Product Frontend Action Table

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

flowchart LR
  c["catalog_product_frontend_action"]:::center
  n0["customer_entity"]
  click n0 "/schema/table/customer_entity"
  n0 -- customer_id --> c
  n1["catalog_product_entity"]
  click n1 "/schema/table/catalog_product_entity"
  n1 -- product_id --> c
  click c "/schema/table/catalog_product_frontend_action"
  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 product_id → catalog_product_entity

Columns (6)

Name	Type	Null	Comment
action_id PK	bigint unsigned	no	Product Action ID
type_id	varchar(64)	no	Type of product action
visitor_id	int unsigned	yes	Visitor ID
customer_id	int unsigned	yes	Customer ID
product_id	int unsigned	no	Product ID
added_at	bigint	no	Added At

Keys & indexes

Primary key: action_id

Unique

CATALOG_PRODUCT_FRONTEND_ACTION_VISITOR_ID_PRODUCT_ID_TYPE_ID (visitor_id, product_id, type_id)
CATALOG_PRODUCT_FRONTEND_ACTION_CUSTOMER_ID_PRODUCT_ID_TYPE_ID (customer_id, product_id, type_id)

References (2)

customer_id → customer_entity .entity_id (on delete CASCADE)
product_id → catalog_product_entity .entity_id (on delete CASCADE)