📦 Magento_Catalog · engine innodb
catalog_eav_attribute
Catalog EAV Attribute Table
Neighbourhood (1-hop foreign-key graph — showing 1 of 1)
flowchart LR c["catalog_eav_attribute"]:::center n0["eav_attribute"] click n0 "/schema/table/eav_attribute" n0 -- attribute_id --> c click c "/schema/table/catalog_eav_attribute" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (1)
Columns (25)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| attribute_id | smallint unsigned | no | Attribute ID | |
| frontend_input_renderer | varchar(255) | yes | Frontend Input Renderer | |
| is_global | smallint unsigned | no | 1 | Is Global |
| is_visible | smallint unsigned | no | 1 | Is Visible |
| is_searchable | smallint unsigned | no | 0 | Is Searchable |
| is_filterable | smallint unsigned | no | 0 | Is Filterable |
| is_comparable | smallint unsigned | no | 0 | Is Comparable |
| is_visible_on_front | smallint unsigned | no | 0 | Is Visible On Front |
| is_html_allowed_on_front | smallint unsigned | no | 0 | Is HTML Allowed On Front |
| is_used_for_price_rules | smallint unsigned | no | 0 | Is Used For Price Rules |
| is_filterable_in_search | smallint unsigned | no | 0 | Is Filterable In Search |
| used_in_product_listing | smallint unsigned | no | 0 | Is Used In Product Listing |
| used_for_sort_by | smallint unsigned | no | 0 | Is Used For Sorting |
| apply_to | varchar(255) | yes | Apply To | |
| is_visible_in_advanced_search | smallint unsigned | no | 0 | Is Visible In Advanced Search |
| position | int | no | 0 | Position |
| is_wysiwyg_enabled | smallint unsigned | no | 0 | Is WYSIWYG Enabled |
| is_used_for_promo_rules | smallint unsigned | no | 0 | Is Used For Promo Rules |
| is_required_in_admin_store | smallint unsigned | no | 0 | Is Required In Admin Store |
| is_used_in_grid | smallint unsigned | no | 0 | Is Used in Grid |
| is_visible_in_grid | smallint unsigned | no | 0 | Is Visible in Grid |
| is_filterable_in_grid | smallint unsigned | no | 0 | Is Filterable in Grid |
| search_weight | float | no | 1 | Search Weight |
| is_pagebuilder_enabled | boolean | no | false | Is PageBuilder Enabled |
| additional_data | text | yes | Additional swatch attributes data |
Keys & indexes
Primary key: attribute_id
Indexes
- CATALOG_EAV_ATTRIBUTE_USED_FOR_SORT_BY (used_for_sort_by) btree
- CATALOG_EAV_ATTRIBUTE_USED_IN_PRODUCT_LISTING (used_in_product_listing) btree
References (1)
- attribute_id → eav_attribute .attribute_id (on delete CASCADE)