ProductAttributes
The table below describes the ProductAttributes table.
This table contains the following virtual tables:
- ProductAttributesApplyTo
- ProductAttributesValidationRules
- ProductAttributesOptions
- ProductAttributesStoreLabels
- ProductAttributesFrontendLabels
- ProductAttributesCustomAttributes
None of the columns in this table are updatable.
This table contains the following foldable columns:
- Attribute_Code
- Attribute_Id
- Backend_Model
- Backend_Type
- Default_Frontend_Label
- Default_Value
- Entity_Type_Id
- Frontend_Class
- Frontend_Input
- Is_Comparable
- Is_Filterable
- Is_Filterable_In_Grid
- Is_Filterable_In_Search
- Is_Html_Allowed_On_Front
- Is_Pagebuilder_Enabled
- Is_Required
- Is_Searchable
- Is_Unique
- Is_Used_For_Promo_Rules
- Is_Used_In_Grid
- Is_User_Defined
- Is_Visible
- Is_Visible_In_Advanced_Search
- Is_Visible_In_Grid
- Is_Visible_On_Front
- Is_Wysiwyg_Enabled
- Note
- Position
- Scope
- Source_Model
- Used_For_Sort_By
- Used_In_Product_Listing
| Column Name | SQL Type | Nullable | Returnable |
|---|---|---|---|
|
Attribute_Code Primary Key |
SQL_VARCHAR(255) | False | True |
|
Attribute_Id |
SQL_VARCHAR(255) | True | False |
|
Backend_Model |
SQL_VARCHAR(255) | True | False |
|
Backend_Type |
SQL_VARCHAR(255) | True | False |
|
Default_Frontend_Label |
SQL_VARCHAR(255) | True | False |
|
Default_Value |
SQL_VARCHAR(255) | True | False |
|
Entity_Type_Id |
SQL_VARCHAR(255) | False | False |
|
Frontend_Class |
SQL_VARCHAR(255) | True | False |
|
Frontend_Input |
SQL_VARCHAR(255) | False | False |
|
Is_Comparable |
SQL_VARCHAR(255) | True | False |
|
Is_Filterable |
SQL_BIT | True | False |
|
Is_Filterable_In_Grid |
SQL_BIT | True | False |
|
Is_Filterable_In_Search |
SQL_BIT | True | False |
|
Is_Html_Allowed_On_Front |
SQL_BIT | True | False |
|
Is_Pagebuilder_Enabled |
SQL_BIT | True | False |
|
Is_Required |
SQL_BIT | False | False |
|
Is_Searchable |
SQL_VARCHAR(255) | True | False |
|
Is_Unique |
SQL_VARCHAR(255) | True | False |
|
Is_Used_For_Promo_Rules |
SQL_VARCHAR(255) | True | False |
|
Is_Used_In_Grid |
SQL_BIT | True | False |
|
Is_User_Defined |
SQL_BIT | True | False |
|
Is_Visible |
SQL_BIT | True | False |
|
Is_Visible_In_Advanced_Search |
SQL_VARCHAR(255) | True | False |
|
Is_Visible_In_Grid |
SQL_BIT | True | False |
|
Is_Visible_On_Front |
SQL_VARCHAR(255) | True | False |
|
Is_Wysiwyg_Enabled |
SQL_BIT | True | False |
|
Note |
SQL_VARCHAR(255) | True | False |
|
Position |
SQL_INTEGER(unsigned) | True | False |
|
Scope |
SQL_VARCHAR(255) | True | False |
|
Source_Model |
SQL_VARCHAR(255) | True | False |
|
Used_For_Sort_By |
SQL_BIT | True | False |
|
Used_In_Product_Listing |
SQL_VARCHAR(255) | True | False |