🗃️ Magento_Eav · engine innodb

eav_form_element

Eav Form Element

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

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

Click a node to jump to that table.

Related tables (3)

attribute_id → eav_attribute fieldset_id → eav_form_fieldset type_id → eav_form_type

Columns (5)

Name	Type	Null	Default	Comment
element_id PK	int unsigned	no		Element ID
type_id	smallint unsigned	no		Type ID
fieldset_id	smallint unsigned	yes		Fieldset ID
attribute_id	smallint unsigned	no		Attribute ID
sort_order	int	no	0	Sort Order

Keys & indexes

Primary key: element_id

Unique

EAV_FORM_ELEMENT_TYPE_ID_ATTRIBUTE_ID (type_id, attribute_id)

Indexes

EAV_FORM_ELEMENT_FIELDSET_ID (fieldset_id) btree
EAV_FORM_ELEMENT_ATTRIBUTE_ID (attribute_id) btree

References (3)

attribute_id → eav_attribute .attribute_id (on delete CASCADE)
fieldset_id → eav_form_fieldset .fieldset_id (on delete SET NULL)
type_id → eav_form_type .type_id (on delete CASCADE)