📦 Magento_CatalogUrlRewrite · engine innodb

catalog_url_rewrite_product_category

url_rewrite_relation

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

flowchart LR
  c["catalog_url_rewrite_product_category"]:::center
  n0["catalog_product_entity"]
  click n0 "/schema/table/catalog_product_entity"
  n0 -- product_id --> c
  n1["url_rewrite"]
  click n1 "/schema/table/url_rewrite"
  n1 -- url_rewrite_id --> c
  n2["catalog_category_entity"]
  click n2 "/schema/table/catalog_category_entity"
  n2 -- category_id --> c
  click c "/schema/table/catalog_url_rewrite_product_category"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (3)

product_id → catalog_product_entity url_rewrite_id → url_rewrite category_id → catalog_category_entity

Columns (3)

Name	Type	Null	Comment
url_rewrite_id	int unsigned	no	url_rewrite_id
category_id	int unsigned	no	category_id
product_id	int unsigned	no	product_id

Keys & indexes

Primary key: url_rewrite_id

Indexes

CATALOG_URL_REWRITE_PRODUCT_CATEGORY_CATEGORY_ID_PRODUCT_ID (category_id, product_id) btree

References (3)

product_id → catalog_product_entity .entity_id (on delete CASCADE)
url_rewrite_id → url_rewrite .url_rewrite_id (on delete CASCADE)
category_id → catalog_category_entity .entity_id (on delete CASCADE)