📄 Magento_Theme · engine innodb

theme

Core theme

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

flowchart LR
  c["theme"]:::center
  n0["layout_link"]
  click n0 "/schema/table/layout_link"
  c -- theme_id --> n0
  n1["widget_instance"]
  click n1 "/schema/table/widget_instance"
  c -- theme_id --> n1
  n2["theme_file"]
  click n2 "/schema/table/theme_file"
  c -- theme_id --> n2
  click c "/schema/table/theme"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (3)

layout_link → theme_id theme_file → theme_id widget_instance → theme_id

Columns (9)

Name	Type	Null	Default	Comment
theme_id PK	int unsigned	no		Theme identifier
parent_id	int	yes		Parent ID
theme_path	varchar(255)	yes		Theme Path
theme_title	varchar(255)	no		Theme Title
preview_image	varchar(255)	yes		Preview Image
is_featured	boolean	no	false	Is Theme Featured
area	varchar(255)	no		Theme Area
type	smallint	no		Theme type: 0:physical, 1:virtual, 2:staging
code	text	yes		Full theme code, including package

Keys & indexes

Primary key: theme_id

Referenced by (3)

layout_link .theme_id → .theme_id (on delete CASCADE)
theme_file .theme_id → .theme_id (on delete CASCADE)
widget_instance .theme_id → .theme_id (on delete CASCADE)