📦 Magento_Catalog · engine innodb

catalog_category_entity

Catalog Category Table

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

flowchart LR
  c["catalog_category_entity"]:::center
  n0["catalog_category_entity_datetime"]
  click n0 "/schema/table/catalog_category_entity_datetime"
  c -- entity_id --> n0
  n1["catalog_category_entity_decimal"]
  click n1 "/schema/table/catalog_category_entity_decimal"
  c -- entity_id --> n1
  n2["catalog_category_entity_int"]
  click n2 "/schema/table/catalog_category_entity_int"
  c -- entity_id --> n2
  n3["catalog_category_entity_text"]
  click n3 "/schema/table/catalog_category_entity_text"
  c -- entity_id --> n3
  n4["catalog_category_entity_varchar"]
  click n4 "/schema/table/catalog_category_entity_varchar"
  c -- entity_id --> n4
  n5["catalog_url_rewrite_product_category"]
  click n5 "/schema/table/catalog_url_rewrite_product_category"
  c -- category_id --> n5
  click c "/schema/table/catalog_category_entity"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (7)

catalog_category_entity_datetime → entity_id catalog_category_entity_decimal → entity_id catalog_category_entity_int → entity_id catalog_category_entity_text → entity_id catalog_category_entity_varchar → entity_id catalog_category_product → category_id catalog_url_rewrite_product_category → category_id

Columns (9)

Name	Type	Null	Default	Comment
entity_id PK	int unsigned	no		Entity ID
attribute_set_id	smallint unsigned	no	0	Attribute Set ID
parent_id	int unsigned	no	0	Parent Category ID
created_at	timestamp	no	CURRENT_TIMESTAMP	Creation Time
updated_at	timestamp	no	CURRENT_TIMESTAMP	Update Time
path	varchar(255)	no		Tree Path
position	int	no		Position
level	int	no	0	Tree Level
children_count	int	no		Child Count

Keys & indexes

Primary key: entity_id

Indexes

CATALOG_CATEGORY_ENTITY_LEVEL (level) btree
CATALOG_CATEGORY_ENTITY_PATH (path) btree
CATALOG_CATEGORY_ENTITY_PARENT_ID_LEVEL_POSITION (parent_id, level, position) btree

Referenced by (7)

catalog_category_entity_datetime .entity_id → .entity_id (on delete CASCADE)
catalog_category_entity_decimal .entity_id → .entity_id (on delete CASCADE)
catalog_category_entity_int .entity_id → .entity_id (on delete CASCADE)
catalog_category_entity_text .entity_id → .entity_id (on delete CASCADE)
catalog_category_entity_varchar .entity_id → .entity_id (on delete CASCADE)
catalog_category_product .category_id → .entity_id (on delete CASCADE)
catalog_url_rewrite_product_category .category_id → .entity_id (on delete CASCADE)