📄 Magento_UrlRewrite · engine innodb

url_rewrite

Url Rewrites

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

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

Click a node to jump to that table.

Related tables (1)

catalog_url_rewrite_product_category → url_rewrite_id

Columns (10)

Name	Type	Null	Default	Comment
url_rewrite_id PK	int unsigned	no		Rewrite ID
entity_type	varchar(32)	no		Entity type code
entity_id	int unsigned	no		Entity ID
request_path	varchar(255)	yes		Request Path
target_path	varchar(255)	yes		Target Path
redirect_type	smallint unsigned	no	0	Redirect Type
store_id	smallint unsigned	no		Store ID
description	varchar(255)	yes		Description
is_autogenerated	smallint unsigned	no	0	Is rewrite generated automatically flag
metadata	varchar(255)	yes		Meta data for url rewrite

Keys & indexes

Primary key: url_rewrite_id

Unique

URL_REWRITE_REQUEST_PATH_STORE_ID (request_path, store_id)

Indexes

URL_REWRITE_TARGET_PATH (target_path) btree
URL_REWRITE_STORE_ID_ENTITY_ID (store_id, entity_id) btree
URL_REWRITE_ENTITY_ID (entity_id) btree
URL_REWRITE_IS_AUTOGENERATED_METADATA (is_autogenerated, metadata) btree

Referenced by (1)

catalog_url_rewrite_product_category .url_rewrite_id → .url_rewrite_id (on delete CASCADE)