CatalogProductAttribute
CatalogProductAttribute is an auto generated table
Columns
| Name | Type | ReadOnly | Description |
| ApplyTo | String | False |
Apply to value for the element |
| AttributeCode | String | False |
Code of the attribute. |
| AttributeId [KEY] | Int | False |
Id of the attribute. |
| BackendModel | String | False |
Backend model |
| BackendType | String | False |
Backend type. |
| DefaultFrontendLabel | String | False |
Frontend label for default store |
| DefaultValue | String | False |
Default value for the element. |
| EntityTypeId | String | False |
Entity type id |
| ExtensionAttributes | String | False |
This is an auto-generated column |
| FrontendClass | String | False |
Frontend class of attribute |
| FrontendInput | String | False |
HTML for input element. |
| FrontendLabels | String | False |
Frontend label for each store |
| IsComparable | String | False |
The attribute can be compared on the frontend |
| IsFilterable | Bool | False |
It used in layered navigation |
| IsFilterableInGrid | Bool | False |
It is filterable in catalog product grid |
| IsFilterableInSearch | Bool | False |
It is used in search results layered navigation |
| IsHtmlAllowedOnFront | Bool | False |
The HTML tags are allowed on the frontend |
| IsRequired | Bool | False |
Attribute is required. |
| IsSearchable | String | False |
The attribute can be used in Quick Search |
| IsUnique | String | False |
This is a unique attribute |
| IsUsedForPromoRules | String | False |
The attribute can be used for promo rules |
| IsUsedInGrid | Bool | False |
It is used in catalog product grid |
| IsUserDefined | Bool | False |
Current attribute has been defined by a user. |
| IsVisible | Bool | False |
Attribute is visible on frontend. |
| IsVisibleInAdvancedSearch | String | False |
The attribute can be used in Advanced Search |
| IsVisibleInGrid | Bool | False |
It is visible in catalog product grid |
| IsVisibleOnFront | String | False |
The attribute is visible on the frontend |
| IsWysiwygEnabled | Bool | False |
WYSIWYG flag |
| Note | String | False |
The note attribute for the element. |
| Options | String | False |
Options of the attribute (key => value pairs for select) |
| Position | Int | False |
Position |
| Scope | String | False |
Attribute scope |
| SourceModel | String | False |
Source model |
| UsedForSortBy | Bool | False |
It is used for sorting in product listing |
| UsedInProductListing | String | False |
The attribute can be used in product listing |
| ValidationRules | String | False |
Validation rules. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| AttributeCode_p | String |
This is an auto-generated column |