📄 Magento_Cms · engine innodb

cms_block

CMS Block Table

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

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

Click a node to jump to that table.

Related tables (1)

cms_block_store → block_id

Columns (7)

Name	Type	Null	Default	Comment
block_id PK	smallint	no		Entity ID
title	varchar(255)	no		Block Title
identifier	varchar(255)	no		Block String Identifier
content	mediumtext	yes		Block Content
creation_time	timestamp	no	CURRENT_TIMESTAMP	Block Creation Time
update_time	timestamp	no	CURRENT_TIMESTAMP	Block Modification Time
is_active	smallint	no	1	Is Block Active

Keys & indexes

Primary key: block_id

Indexes

CMS_BLOCK_IDENTIFIER (identifier) btree
CMS_BLOCK_TITLE_IDENTIFIER_CONTENT (title, identifier, content) fulltext

Referenced by (1)

cms_block_store .block_id → .block_id (on delete CASCADE)