🗃️ Magento_Eav · engine innodb

eav_form_type

Eav Form Type

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

flowchart LR
  c["eav_form_type"]:::center
  n0["store"]
  click n0 "/schema/table/store"
  n0 -- store_id --> c
  n1["eav_form_element"]
  click n1 "/schema/table/eav_form_element"
  c -- type_id --> n1
  n2["eav_form_fieldset"]
  click n2 "/schema/table/eav_form_fieldset"
  c -- type_id --> n2
  n3["eav_form_type_entity"]
  click n3 "/schema/table/eav_form_type_entity"
  c -- type_id --> n3
  click c "/schema/table/eav_form_type"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (4)

store_id → store eav_form_element → type_id eav_form_fieldset → type_id eav_form_type_entity → type_id

Columns (6)

Name	Type	Null	Default	Comment
type_id PK	smallint unsigned	no		Type ID
code	varchar(64)	no		Code
label	varchar(255)	no		Label
is_system	smallint unsigned	no	0	Is System
theme	varchar(64)	yes		Theme
store_id	smallint unsigned	no		Store ID

Keys & indexes

Primary key: type_id

Unique

EAV_FORM_TYPE_CODE_THEME_STORE_ID (code, theme, store_id)

Indexes

EAV_FORM_TYPE_STORE_ID (store_id) btree

References (1)

store_id → store .store_id (on delete CASCADE)

Referenced by (3)

eav_form_element .type_id → .type_id (on delete CASCADE)
eav_form_fieldset .type_id → .type_id (on delete CASCADE)
eav_form_type_entity .type_id → .type_id (on delete CASCADE)