MageSmith

🗃️ Magento_Eav · engine innodb

eav_attribute

Eav Attribute

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

flowchart LR
  c["eav_attribute"]:::center
  n0["eav_entity_type"]
  click n0 "/schema/table/eav_entity_type"
  n0 -- entity_type_id --> c
  n1["catalog_product_entity_media_gallery"]
  click n1 "/schema/table/catalog_product_entity_media_gallery"
  c -- attribute_id --> n1
  n2["salesrule_product_attribute"]
  click n2 "/schema/table/salesrule_product_attribute"
  c -- attribute_id --> n2
  n3["weee_tax"]
  click n3 "/schema/table/weee_tax"
  c -- attribute_id --> n3
  n4["catalog_category_entity_datetime"]
  click n4 "/schema/table/catalog_category_entity_datetime"
  c -- attribute_id --> n4
  n5["catalog_category_entity_decimal"]
  click n5 "/schema/table/catalog_category_entity_decimal"
  c -- attribute_id --> n5
  click c "/schema/table/eav_attribute"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (33)

entity_type_id → eav_entity_typecatalog_category_entity_datetime → attribute_idcatalog_category_entity_decimal → attribute_idcatalog_category_entity_int → attribute_idcatalog_category_entity_text → attribute_idcatalog_category_entity_varchar → attribute_idcatalog_eav_attribute → attribute_idcatalog_product_entity_datetime → attribute_idcatalog_product_entity_decimal → attribute_idcatalog_product_entity_gallery → attribute_idcatalog_product_entity_int → attribute_idcatalog_product_entity_media_gallery → attribute_idcatalog_product_entity_text → attribute_idcatalog_product_entity_varchar → attribute_idcustomer_address_entity_datetime → attribute_idcustomer_address_entity_decimal → attribute_idcustomer_address_entity_int → attribute_idcustomer_address_entity_text → attribute_idcustomer_address_entity_varchar → attribute_idcustomer_eav_attribute → attribute_idcustomer_eav_attribute_website → attribute_idcustomer_entity_datetime → attribute_idcustomer_entity_decimal → attribute_idcustomer_entity_int → attribute_idcustomer_entity_text → attribute_idcustomer_entity_varchar → attribute_idcustomer_form_attribute → attribute_ideav_attribute_label → attribute_ideav_attribute_option → attribute_ideav_entity_attribute → attribute_ideav_form_element → attribute_idsalesrule_product_attribute → attribute_idweee_tax → attribute_id

Columns (17)

NameTypeNullDefaultComment
attribute_id PKsmallint unsignednoAttribute ID
entity_type_id smallint unsignedno0Entity Type ID
attribute_code varchar(255) noAttribute Code
attribute_model varchar(255) yesAttribute Model
backend_model varchar(255) yesBackend Model
backend_type varchar(8) nostaticBackend Type
backend_table varchar(255) yesBackend Table
frontend_model varchar(255) yesFrontend Model
frontend_input varchar(50) yesFrontend Input
frontend_label varchar(255) yesFrontend Label
frontend_class varchar(255) yesFrontend Class
source_model varchar(255) yesSource Model
is_required smallint unsignedno0Defines Is Required
is_user_defined smallint unsignedno0Defines Is User Defined
default_value text yesDefault Value
is_unique smallint unsignedno0Defines Is Unique
note varchar(255) yesNote

Keys & indexes

Primary key: attribute_id

Unique

  • EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE (entity_type_id, attribute_code)

Indexes

  • EAV_ATTRIBUTE_FRONTEND_INPUT_ENTITY_TYPE_ID_IS_USER_DEFINED (frontend_input, entity_type_id, is_user_defined) btree

References (1)

Referenced by (32)