📄 Magento_Cms · engine innodb

cms_page

CMS Page Table

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

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

Click a node to jump to that table.

Related tables (1)

cms_page_store → page_id

Columns (20)

Name	Type	Null	Default	Comment
page_id PK	smallint	no		Entity ID
title	varchar(255)	yes		Page Title
page_layout	varchar(255)	yes		Page Layout
meta_keywords	text	yes		Page Meta Keywords
meta_description	text	yes		Page Meta Description
identifier	varchar(100)	yes		Page String Identifier
content_heading	varchar(255)	yes		Page Content Heading
content	mediumtext	yes		Page Content
creation_time	timestamp	no	CURRENT_TIMESTAMP	Page Creation Time
update_time	timestamp	no	CURRENT_TIMESTAMP	Page Modification Time
is_active	smallint	no	1	Is Page Active
sort_order	smallint	no	0	Page Sort Order
layout_update_xml	text	yes		Page Layout Update Content
custom_theme	varchar(100)	yes		Page Custom Theme
custom_root_template	varchar(255)	yes		Page Custom Template
custom_layout_update_xml	text	yes		Page Custom Layout Update Content
layout_update_selected	varchar(128)	yes		Page Custom Layout File
custom_theme_from	date	yes		Page Custom Theme Active From Date
custom_theme_to	date	yes		Page Custom Theme Active To Date
meta_title	varchar(255)	yes		Page Meta Title

Keys & indexes

Primary key: page_id

Indexes

CMS_PAGE_IDENTIFIER (identifier) btree
CMS_PAGE_TITLE_META_KEYWORDS_META_DESCRIPTION_IDENTIFIER_CONTENT (title, meta_keywords, meta_description, identifier, content) fulltext

Referenced by (1)

cms_page_store .page_id → .page_id (on delete CASCADE)